https://issues.apache.org/ooo/show_bug.cgi?id=121773
Bug ID: 121773
Issue Type: DEFECT
Summary: OOXML import: 0 ^ 0 should evaluate to "#DIV/0!" and
not to 1
Classification: Application
Product: spreadsheet
Version: AOO 3.4.1
Hardware: All
OS: All
Status: CONFIRMED
Keywords: interop_OOXML
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
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]
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
