https://bugs.documentfoundation.org/show_bug.cgi?id=98481
Bug ID: 98481
Summary: SUM is zero when some cells are empty and some cells
reference other sheet AND file is xlsx.
Product: LibreOffice
Version: 5.1.0.2 rc
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: fl...@flintobrien.com
Created attachment 123362
--> https://bugs.documentfoundation.org/attachment.cgi?id=123362&action=edit
File with bug created with Google Docs and downloaded as xlsx.
On Sheet1, reference two cells from 'Sheet 2'. Cells B2:B4 display values: [1][
][3]
On Sheet1, =SUM(B2:B4) displays zero when it should be 4.
SUM() works if the B2, B3, B4 all have values (even if each value is a
reference to another sheet).
SUM() works if the B2 and B4 are simple numeric values (not references to
another sheet).
I created the spreadsheet with Google Docs Sheets. Downloaded it as .xlsx and
.ods. The xlsx has the bug, but the .ods version behaves as expected. The bug
remains even if I edit the cells in LibreOffice.
I've attached the test file that has the bug.
LibreOffice
Version: 5.0.1.2
Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Locale: en-US (en.UTF-8)
Mac OS X 10.11.3
--
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
