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