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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136465
           Summary: Cell contains incorrect value from formula
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ajones2001 at googlemail.com

Description:
I have a sheet with a cell which shows an incorrect value.  F9 does not cause
reevaluation.  Copying the exact formula into the cell next to it (not copy and
paste cell) gives a different result.  The difference is not a number which
appears in any cells referenced by the formula.  clicking on the cell and
pressing return on the formula bar does not update the cell.  Copying and
pasting the cell onto itself re evaluates the formula to the correct result

Steps to Reproduce:
I have a copy of the spreadsheet which illustrates the problem.  I have no idea
how to reproduce the problem.  The problem is difficult to spot because the
cell contains the result of a sum of many cells.

Actual Results:
The value in the cell contains the incorrect value and is not recalculated
using the normal methods

Expected Results:
The Cell should never contain the wrong value


Reproducible: Didn't try


User Profile Reset: No



Additional Info:
I have a copy of the spreadsheet but do not know how to reproduce 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/20200904/ab61c305/attachment.htm>