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

            Bug ID: 101694
           Summary: Formula displays wrong number
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: bordma...@gmail.com

User-Agent:       Mozilla/5.0 (Windows NT 10.0; rv:47.0) Gecko/20100101
Firefox/47.0
Build Identifier: LibreOffice 5.0.4.2

Several times (rarely) I cought LibreOffice not updating formulas in calc but
now I have proof a file I'm working: R5 cell is a formula referring to other
cell (=L5*N5*(1+O5+P5)) and dsplays the corect 17.41 result. U5 copies the R5
value (=R5) but dysplays 10.24 instead of 17.41?
Same for the other U cells.
The list is filtered, perhaps that's why?

Reproducible: Sometimes

Steps to Reproduce:
1. no ideea, just happens. I worked on that file on the 11 of august than
copied it on 22aug unchanged to add some details. When I copy that row on a
fresh page, the values are correct.
2. did not change those cells since 11 august
3. at any rate, shouldn't they display correctly ?



[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no


Reset User Profile?No

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to