On 29/03/16 11:45, Regina Henschel wrote: ...
To force a result of -4 you need to tell Calc, that the minus is a binary operator. The formula "=0-2^2" would do that.Of course changing such behavior will cause a hell lot of trouble in existing documents… but perhaps the operator precedence should be explicitly specified on the wiki ?The precedence is defined in ODF http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Operators
Doubtless so.But of little comfort to the hapless user, expecting a more mathematical convention:
mike@spock> perl -e 'print -3**2, "\n"' -9 Oh well. Caveat programmer, I suppose. -- Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk) Harlow Essex England -- 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