[Libreoffice-bugs] [Bug 136268] Math function not evaluated correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136268

--- Comment #4 from b. <newbie-02 at gmx.de> ---
sad to say and hard to bear: 

TDF or LO or whoever has in 

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Operators 

and repeatedly in 

https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/part4-formula/OpenDocument-v1.3-cs01-part4-formula.html#__RefHeading__1017940_715980110 

deliberately made a documented distinction between 'unary' sign operators +/-
and binary calculation operators +/-, whereof the former are assigned a higher
preference than exponentiating, multiplikation and addition,  
(in contrast to the fact that some commenters claim that LO
would not! arbitrarily set standards),  
(and imho very! questionable as the same signs get different functionality on
very little changes in context) 
(and imho very! questionable as the evaluation deviates from school math!) 

1. there will be / have been a plausible reason for this hard and incompatible
measure,  

2. i can think of little else but compatibility with ex$el,  

3. a change becomes very unlikely,  

4. i find the automatic insertion of brackets difficult, when (file open or
input) and under what conditions should it be done? How to avoid damage to
existing files or intentional settlements, but before do nothing and continue
calculating errors and angry users creating new bugs and questions i support
the proposal, 

5. alternatively i suggest similar to the way ex$el introduced a labeling of
potentially wrongly formatted cells - by comparing them with surrounding cells,
to adopt this and to add a labeling of possibly wrongly 'formulated' cells,
like a small red triangle in the lower right corner of the cell, and a
popup-assistant on mouseover: 

'be aware that the formula in this cell contains a term that is calculated
differently by LO-calc and ordinary school mathematics, calc interprets single
minus signs in front of numbers and values as belonging to this number and more
tightly bound to it than subsequent arithmetic operators, "-2^2" is thus
calculated as 4 instead of -4 (as many users would expect). this quirk was / is
necessary to stay compatible to other spreadsheets, for another calculation
formulate the term as -(2^2). if there is a value in front of the negative term
the "-" sign is used as a calculation operator and it is not necessary to put
brackets.'

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200901/e8a78e7c/attachment.htm>