Hi,
please see the (long) discussions in
https://issues.apache.org/ooo/show_bug.cgi?id=24271 and
https://issues.apache.org/ooo/show_bug.cgi?id=26755 and its duplicates.
Torokhov Sergey schrieb:
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.
My personal favorite is the way Gnumeric does it. It puts brackets
around -1 when you enter the formula, so that there is no doubt about
the meaning.
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org