Hi,
On 27.05.2013 11:20, Torokhov Sergey wrote:
There is a some strange behaviour in "OpenOffice Calc" (and in
Microsoft Office too). Did it was made in OpenOIffice for compability
with MSO?
This seems to concern all combinations of even degrees and "minus"
sign in the begining of formula
1. Enter in cell the expression: =-1^2 The result will be equal "1"
instead of "-1" Note that "=1-2^2" results in "-3" and it's true but
"-2^2" results "4" instead of "-4"
2. Well, now enter the expression: =-(1)^2 The result will be equal
"1" instead of "-1" again (or expression like "=-(1+2)^2" the result
will be "9" instead of "-9")
3. Only if enter the expression: = -(1^2) The result now will be
right and equal "-1"
Such behaviour contradicts mathematical notation of formula.
I tried Microsoft Office Excel 2003, 2010 and 2013. All three
applications showed the same results on the above formulas as OpenOffice
Calc.
Thus, I believe that your guess is true that the reason for OpenOffice's
behavior is the compatibility with Microsoft Office.
Best regards, Oliver.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
