[Libreoffice-bugs] [Bug 136465] Cell contains incorrect value from formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Alan Jones <ajones2001 at googlemail.com> ---
Created attachment 165137
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165137&action=edit
This spreadsheet illustrates the problem

Cell AV 284 and cell AW284 contain the same formula.  The results differ by the
value shown in AX284.  

The value in cell AV284 is not updated if the sheet is recalculated or if the
formula is inspected by clicking on the cell and confirmed by pressing enter
where the formula is displayed.

Copying and pasting the cell onto itself will cause an update.

There does not appear to be any easy means of identifying cells which exhibit
this problem.  

This seems to be a critical bug, in that the cell value is incorrect and very
difficult to spot (unless all the calculations are performed by hand).  I would
expect recalculation of the spreadsheet to refresh all calculated values.

-- 
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/20200904/fe6b54da/attachment.htm>