https://bugs.documentfoundation.org/show_bug.cgi?id=103701
Regina Henschel <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |[email protected]
Ever confirmed|0 |1
--- Comment #3 from Regina Henschel <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
