Apache OpenOffice (AOO) Bugzilla – Issue 121773
OOXML import: 0 ^ 0 should evaluate to "#DIV/0!" and not to 1
Last modified: 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]