Issue 121773

Summary:	OOXML import: 0 ^ 0 should evaluate to "#DIV/0!" and not to 1
Product:	Calc	Reporter:	Andrea Pescetti <pescetti>
Component:	open-import	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	issues
Version:	3.4.1	Keywords:	interop_OOXML
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Andrea Pescetti 2013-02-14 12:32:45 UTC

In a huge discussion about 0 ^ 0 in Calc on the dev list
http://mail-archives.apache.org/mod_mbox/openoffice-dev/201302.mbox/browser
Dennis Hamilton pointed out a OOXML import problem which is not necessarily related to the issue discussed there.
  ---
In OOXML POWER(0,0) is defined to return #DIV/0!  The definitions are carried over verbatim from ECMA-376-4 of December 2006.  
Nevertheless, Excel 2010 and 2013 (Preview) both result in #NUM! for =POWER(0,0).  
  ---
In the current OpenOffice 3.4.1 implementation we have no way to conform to OOXML on this, since 0 ^ 0, in case someone doesn't know, returns 1 in OpenOffice 3.4.1 and previous versions; so it doesn't return "#DIV/0!" (nor "#NUM!").

[Note: this bug only refers to reading XLSX files and to nothing else; and note that this is about implementing a standard, not finding out what the "right" value is]