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