Issue 121773 - OOXML import: 0 ^ 0 should evaluate to "#DIV/0!" and not to 1
Summary: OOXML import: 0 ^ 0 should evaluate to "#DIV/0!" and not to 1
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: interop_OOXML
Depends on:
Reported: 2013-02-14 12:32 UTC by Andrea Pescetti
Modified: 2013-02-14 12:32 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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]