Re: [libreoffice-users] Awkward behaviour of LO Calc

Mike Scott wrote:
> A quick search brings up
> https://en.wikipedia.org/wiki/Order_of_operations
>
> which says
>
> "There exist differing conventions concerning the unary operator − 
> (usually read "minus"). In written or printed mathematics, the 
> expression −3^2 is interpreted to mean 0 − (3^2) = −9 .... but in .... 
> Microsoft Office Excel (and other spreadsheet applications) and the 
> programming language bc, unary operators have a higher priority than 
> binary operators"
>
> Contrary to, eg, perl.
>
> Ouch! Quite contrary to expectation. Here lie monsters :-)

The ODF specification explicitly says that the unary - has higher precedence than ^, which is 
compatible with Excel. So it is not a bug.
-- 
Piet van Oostrum <piet@vanoostrum.org>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted