[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from MD <mike.giftrise at btinternet.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170920/5d1c65eb/attachment-0001.html>