[Libreoffice-bugs] [Bug 140691] calc: calculation: 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 #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
This must be WONTFIX.

We do not try to follow the order of evaluation that Excel does, when it's
unspecified in any standard. They may have different data layout that makes
their specific order more efficient, and our data layout may make another order
preferred; also they may change it tomorrow, without notice. It's for purpose
that various standards do not define the order of evaluation.

And then, if you think that it would "improve compatibility", then you are
breaking compatibility with our documents. Then, what about Excel following the
order used in Calc when opening ODS?

It's just splitting hairs, and is absolutely useless to pursue this. As said in
the bug 55960 comment 22 cited here in comment 0, we only worry about real
problems, and suggestions that allow to improve calculations. E.g., Excel gives
0 for SUM(1e20;-1;-1e20) and 1 for SUM(1e20;-1e20;-1), and it would be just
fine for Calc to start producing proper -1 for both; trying to mimic Excel here
is *not* a goal (which would be, if we accept this bug).

-- 
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/20210420/94789244/attachment-0001.htm>