[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 #13 from Eike Rathke <erack at redhat.com> ---
(In reply to b. from comment #12)
> - calc disregards this rule by calculating e.g. '=SUM(A1:A3)' not in the
> order A1 + A2 + A3, 

Is changing with implementation of KahanSum for bug 137679 anyway.

> Example: '=RAWSUBTRACT(A1; A2; A3)' calculates calc as 'A1 - A3 - A2', 

I already mentioned in
https://bugs.documentfoundation.org/show_bug.cgi?id=137679#c19 that we can
reverse order of processing for RAWSUBTRACT().

> I think it makes sense to make this intuitive for the users or 'according to
> normal mathematical logic', also I see 'When processing a ReferenceList, the
> references are processed in order (first, second if any, and so on).' from
> the standard applicable here, @Mike Kaganski disagrees. 

I agree with Mike disagreeing. A ReferenceList is *not* a list of parameters. A
ReferenceList is a type of *one* argument passed where the argument is a list
of references. See
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs02/part4-formula/OpenDocument-v1.3-cs02-part4-formula.html#__RefHeading__1017906_715980110

-- 
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/20210427/7c9ae381/attachment.htm>