It's well known that 0^0 doesn't exist, but LibO says that 0^0=1
The ODF 1.2 standard says 0^0 shall be 0, 1 or an Error. The choice is implementation-defined.
To see the bug in LibO, just put =0^0 in a cell.
MS Excel in this case gives #NUM!
AOO developers are trying to solve the same problem https://issues.apache.org/ooo/show_bug.cgi?id=114430
Thank you for reporting this bug,
I can reproduce this bug running LibreOffice on Mac os x 10.6.8.
"It's well known that 0^0 doesn't exist"
it is not well known that 0^0 does not exist. in fact Euler in ~1740 already defined it to be 1. 0^0 is an indeterminate 'form' in the context of extension by continuity of multi-variables functions... but that is only in that narrow specific sub-set of Math that 0^0 is considered an indeterminate 'form'...
but in many other area of mathematics the convention of 0^0 = 1 is useful and commonly used.
1/ The ODF standard allow for 0^0=1
2/ Changing that would break backward compatibility as LibreOffice, OpenFoffice and StarOffice have always returned 1 for 0^0
*** Bug 63231 has been marked as a duplicate of this bug. ***