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 <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@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
