[Libreoffice-bugs] [Bug 140691] calc: calculation: sequence of operations neglected in many tasks, only mathematical better results should be allowed if calc differs from ex$el | was: sum of range: (and similar) - no compatibility with ex$el reg. ordering of operands

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from b. <newbie-02 at gmx.de> ---
Created attachment 171360
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171360&action=edit
sample comparing different operand sequences affecting the sum

did a little more investigation, and found something what blocks consistent
sheets in calc ... 

calc has no fixed order how it calculates ranges, 

from experiments with three operands i concluded column by column from right to
left and in the column bottom up, 

but attached sheet tells me - already with 4 operands - it's somehow not a
fixed one-way work through the stack, and additional reacting on free cells
between the operands, 

this blocks: 

ex$el compatibility, 

any efforts to gain better results by operand ordering, what can! be done in
ex$el, 

thus in this point calc is weak against excel, and weak in itself, which may
contribute to plenty other irritations,

-- 
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/20210422/2ac4b07f/attachment-0001.htm>