...
Changes that Impact Backwards Compatibility
...
Calc and OpenFormula Support
Exponentiation
The current version of Calc produces 1 for POWER(0,0). This is one of the implementation-defined results that is permitted by ODF 1.2 OpenFormula.
It is proposed to change POWER(0,0) to result in #VALUE!. This is also permitted as the implementation-defined result. This is also compatible with Excel and the Excel 2013 support for ODF 1.2 OpenFormula in .ods Spreadsheets.
This proposed change is tracked in https://issues.apache.org/ooo/show_bug.cgi?id=114430 Bugzilla Issue #114430.
In addition to being reflected in these release notes, it is important that Calc documentation be specific about the implementation-defined result being #VALUE!. It is also valuable to advise users that permissible implementation-defined values are 0, 1, and an error value. Users concerned about having an implementation-independent, interoperable use of Calc need to provide formulations that do not depend on their being a specific one of those values produced by POWER(0,0).
Wiki Markup |
---|
\[Note: It is also necessary to provide an explicit definition for the case of POWER(a,b) where a <= 0 and b is not an exact integer. It is not proposed to change the current result for that case, since #VALUE! is allowable and interoperable with other spreadsheet implementations, including Excel. The Calc documentation does need to specify this implementation-dependent choice.\] |
Bug Fixes
As of <2012/10/30, there were 227 verified issues that have been resolved.
...