https://bugs.documentfoundation.org/show_bug.cgi?id=103701
--- Comment #7 from Regina Henschel <[email protected]> ---
(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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
