https://bugs.documentfoundation.org/show_bug.cgi?id=112434
--- Comment #5 from MD <[email protected]> ---
comment #2. You have misunderstood this bug report
The bug is that cells in column B are incorrect after the paste operation.
Cells with a REF shown in the formula should display REF not 0.
Cells B147 to B153 should display a 1 not 0.
Any formula that then references cells B147 to B153 uses the value of zero and
gets incorrect results.
This results in a spreadsheet quietly miscalculating.
Clearly I have a simple case that makes it obvious a bug is present.
Others may have more complex sheets and be unaware their calculations are
wrong.
This is why I marked it critical. The spreadsheet is not fit for purpose.
IMPORTANT NOTE
I tried to reproduce this before making this comment and instead of cell A150
as my starting point I used cell A7. The sheet worked correctly.
However when I used cell A150 again I got the problem.
--
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
