https://bugs.documentfoundation.org/show_bug.cgi?id=95273
Bug ID: 95273
Summary: XLSX import: SUM(cellref) returns 0, while cell
contains value != 0.
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: hugo.jon...@gmail.com
Created attachment 119901
--> https://bugs.documentfoundation.org/attachment.cgi?id=119901&action=edit
spreadsheet showing the SUM bug on sheet 1, in cell E3.
For an imported XLSX spreadsheet (attached), we have the following cell values:
... | D E
2 | 10 =D2
3 | 15 =SUM(D3,E2)
Displayed value for E3 is 15.
Expected result: E3 is 25.
The file was not created by me. As I understand it, it's a Google Docs
spreadsheet, which was either exported to XLSX or to LibreOffice and then XLSX.
For added fun: when trying to get a minimal example, I deleted sheet 2. The bug
disappeared then. (sheet 2 is a copy of sheet one with extra colors)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
