To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=26755
User discoleo changed the following:
What |Old value |New value
================================================================================
CC|'er,laurentgodard,vinc17' |'discoleo,er,laurentgodard
| |,vinc17'
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Aug 6 16:53:04 +0000
2008 -------
To add further weight to the mathematical correct interpretation:
- all scientifically advanced programs DO interpret -4^2 = -16
- including mathematical and statistical software, e.g:
R, Octave, Mathematica (did not test it personally, but I am confident
that the person whom I asked, did actually test it), ...
Adding parenthesis (as does gnumeric) is necessary for some other reason, too:
- files may get imported into different software that:
-- DO interpret it mathematically correct
-- BUT do NOT implement all ODF-engine (and every quirk)
[e.g. a simple ODF-parser/importer]
- ODF and implementations might change in the future and handle
such expressions correctly
-- this will break all backwards-compatibility and
-- make old spreadsheets rather unusable
To be safe for future changes, removing all mathematical ambiguity when saving
these expressions is the better approach.
Another weirdness of the current implementation is described in issue 92515:
-(5+3)^2 is interpreted as + 64 instead of -64
[tested in OOo-dev m28]
If it wasn't tragic, it would be rather grotesque. In the latter case it can't
be even argued that the number (-8) is meant, because we have "-(an
expression)". Also, this breaks completely the mathematical commutativity, like:
x - b^n != - b^n + x
Hope this will foster adopting sound mathematical rules in interpreting such
expressions.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
