Thats enough Geovanni....Lets find solution (at least temporary) so that the
faithful user like me can still continue with all the workbooks established
by engineers like me....I will start a new ? thread to find solution by
find/replace functions, hopefully to be replied by other excel
users....thanks anyway....see THREAD : EXCEL FUNCTION CROSS SOLUTION ?
--
"Bright minds are blessed to those who share them.."-rsb.


"Harlan Grove" wrote:

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.