Issue 121773

Summary: OOXML import: 0 ^ 0 should evaluate to "#DIV/0!" and not to 1
Product: Calc Reporter: Andrea Pescetti <pescetti>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues
Version: 3.4.1Keywords: 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
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]