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+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
