[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #14 from Eike Rathke  ---
It's an implementation detail, you'd need to dive into the formula cell related
source code under sc/source/core/{data,tool}

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #13 from Vianney Stroebel  ---
(In reply to Eike Rathke from comment #12)
> A concept of Calc, a concept of Excel, maybe others as well.

What exact name does this concept have in Calc? Googling 'libreoffice calc
"grouped formula"' or 'libreoffice calc "group formula"' doesn't produce
anything.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #12 from Eike Rathke  ---
A concept of Calc, a concept of Excel, maybe others as well.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #11 from Vianney Stroebel  ---
(In reply to Eike Rathke from comment #10)
> The problem seems to be a shared grouped formula that is created from the
> two subsequent SUM formulas in B.C1:C2, changing one of them, for example in
> C1 to =A1+B1 or in C2 to =A2+B2, makes the calculation work as expected.

Is a "shared grouped formula" a concept of LibreOffice Calc?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #10 from Eike Rathke  ---
The problem seems to be a shared grouped formula that is created from the two
subsequent SUM formulas in B.C1:C2, changing one of them, for example in C1 to
=A1+B1 or in C2 to =A2+B2, makes the calculation work as expected.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #9 from Regina Henschel  ---
I just confirm it and list some additional problems.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #8 from Vianney Stroebel  ---
(In reply to Regina Henschel)

I think I understand each of your messages but I don't understand your point.

If you're just confirming the bug that I filed, then... ok... we have no
disagreement then.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #7 from Regina Henschel  ---
(In reply to Vianney Stroebel from comment #6)
> > I agree that the formula template in A.A2 resolves to being actually
> > "=A.A1". But you have not considered, that
> > "=MULTIPLE.OPERATIONS($A$2;$A$3;$B2;$A$1;C$1)" has the replacement rule to
> > use the value of A.C1 at all places where the formula template has the
> > reference to A.A1.
> 
> Don't you agree that MULTIPLE.OPERATIONS should only affect the value of the
> cells that actually contains the "MULTIPLE.OPERATIONS" function?
> 
> If so, why should the presence of a MULTIPLE.OPERATIONS function in A.C2
> affect the value of A.A2?

You are right that using MULTIPLE.OPERATIONS in A.C2 should have no effect on
the formula result in A.A2.

But my concerns are these and therefore I set it to New:

A.C2 should show the value of A.C1, but that is not the case after you force
recalculate after a change in A.A1.

B.A1 should show the value of A.A1. But that is not the case after you change
the value in A.C1.

My guess is, that the problem is the range in the SUM function in B.C1. Without
this range it works as expected.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #6 from Vianney Stroebel  ---
> I agree that the formula template in A.A2 resolves to being actually
> "=A.A1". But you have not considered, that
> "=MULTIPLE.OPERATIONS($A$2;$A$3;$B2;$A$1;C$1)" has the replacement rule to
> use the value of A.C1 at all places where the formula template has the
> reference to A.A1.

Don't you agree that MULTIPLE.OPERATIONS should only affect the value of the
cells that actually contains the "MULTIPLE.OPERATIONS" function?

If so, why should the presence of a MULTIPLE.OPERATIONS function in A.C2 affect
the value of A.A2?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #5 from Regina Henschel  ---
(In reply to Vianney Stroebel from comment #4)
> (In reply to Regina Henschel from comment #3)
> > I think, there is a problem, but I disagree, that "A.A2 should be equal to
> > A.A1".
> 
> Well, A.A2 has the formula "=$B.C1" and B.C1 has the formula "=$A.A1", so
> it's pretty clear that A.A2 = A.A1 (with just B.C1 between them).

I agree that the formula template in A.A2 resolves to being actually "=A.A1".
But you have not considered, that
"=MULTIPLE.OPERATIONS($A$2;$A$3;$B2;$A$1;C$1)" has the replacement rule to use
the value of A.C1 at all places where the formula template has the reference to
A.A1.

For definition of MULTIPLE.OPERATIONS read
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018432_715980110

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #4 from Vianney Stroebel  ---
(In reply to Regina Henschel from comment #3)
> I think, there is a problem, but I disagree, that "A.A2 should be equal to
> A.A1".

Well, A.A2 has the formula "=$B.C1" and B.C1 has the formula "=$A.A1", so it's
pretty clear that A.A2 = A.A1 (with just B.C1 between them).

I agree with what I understood from the rest of your comment.

Ctrl+Shift+F9 make the calculation right (with A.A2 = A.A1) in the case of this
file, which is the most minimal example of the bug I could find. But in my real
workbook with 7 interconnected sheets and much more calculations, the problem
is compounded and many values are not right (some in the MULTIPLE.OPERATIONS
cells, some elsewhere), and a hard recalculation doe not help in this case. I
could attach the file here but I doubt you could navigate easily among the
dependencies between cells.

Suffice to say a MULTIPLE.OPERATIONS formula should not interfere with the
calculation of the rest of the cells. The manual recalculation (Ctrl+Shift+F9)
command is useless when there are multiple dependent sheets that need a
recalculation in a precise order in order to be right.

The order (and possibly the concurrence) of recalculations in the different
sheets might be the culprit here.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||rb.hensc...@t-online.de
 Ever confirmed|0   |1

--- Comment #3 from Regina Henschel  ---
I think, there is a problem, but I disagree, that "A.A2 should be equal to
A.A1". I think the result in cell A.C2 should be the value of A.C1.

Cell A.C2 has content "=MULTIPLE.OPERATIONS($A$2;$A$3;$B2;$A$1;C$1)"
That means:
The formula template is in A.A2
The first variable in the formula template is A.A3
The actual value to replace the first variable is in A.B2
The second variable in the formula template is A.A1
The actual value to replace the second variable is in A.C1

Cell A.A2 has content "=B.C1". This formula has neither a direct reference to
A.A3 nor to A.A1.

The reference "=B.C1" is resolved to "=SUM(B.A1:B.B1)" and that should be
handled as "=B.A1+B.B1" and with resolving the reference in B.A1 it should be
handled as "=A.A1+B.B1".

Now we do the replacements. Instead of the variable A.A1 the replacement from
A.C1 is used and we get the calculation "=A.C1+B.B1" with their current values
"=1000+empty" resulting in value 1000, which can be seen in cell A.C2.

But if you change A.A1 e.g. to 123 and use Ctrl+Shift+F9 to hard recalculate,
you get as result the value 123. It seems that the references in the arguments
of SUM are not resolved for purpose of MULTIPLE.OPERATIONS. If you use
B.A1+B.B1 instead of SUM, then the reference chain of MULTIPLE.OPERATIONS
resolves to "=A.A1+B.B1" and the replacement A.C1 instead of A.A1 works.

This issue needs a Calc-expert to explain, what result is the correct one for
MULTIPLE.OPERATIONS.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #2 from Vianney Stroebel  ---
This bug might be related to
https://bugs.documentfoundation.org/show_bug.cgi?id=76447

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103701] MULTIPLE.OPERATIONS interferes with calculations in certain conditions

[bugzilla-daemon]

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

--- Comment #1 from Vianney Stroebel  ---
Created attachment 128486
  --> https://bugs.documentfoundation.org/attachment.cgi?id=128486=edit
Please use this file in order to reproduce the bug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs