On 10 February 2013 00:39, Dennis E. Hamilton <orc...@apache.org> wrote:
> It is not clear that OpenOffice-lineage software has returned the same value > for POWER(0,0) over the years. It seems that a third-party library has been > relied upon for the implementation and there was apparently not much > attention to edge cases. If that library changes or is different on > different platforms, there is the prospect of unexpected differences. It is > good that this is being nailed down. Out of curiosity, I just tried on OOo 1.0.3, 2.2 and 2.4 and LO 4.0 (all Windows); all return value 1 for =0^0 . MS Word 2007, of course, returns NaN. For interop, there is LO 4.0 to consider as well as MS Word. - d.