Excel 2003 SP2 computes the power of a negative number wrong.
Giovanni Ciriani wrote...
Google Spreadsheets=8
Open Office Calc=8
....
Because both adopted Excel's operator precedence.
This has been done before, but WTH.
Gnumeric 1.6.x 8 though it changes the formula to =(-A1)^2+A1^2
Lotus 123 R97 0 Lotus always understood math better than
Microsoft
VBA 0 using ? -2^2+2^2 in the Immediate window
In short, any software that puts compatibility with Excel worksheet
formula syntax as a high priority is likely to produce the same results
as Excel, and other software (aside from COBOL apps and some SQL
dialects) won't.
|