https://bugs.documentfoundation.org/show_bug.cgi?id=98481
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|SUM is zero when some cells |SUM is zero when some cells
|are empty and some cells |are empty and some cells
|reference other sheet AND |reference other sheet AND
|file is xlsx. |file is .xlsx AND file was
| |created by Google Sheets.
--- Comment #8 from Eike Rathke <er...@redhat.com> ---
The difference seems rather to be that formulas in E2:E4 and B5:D5 are shared,
whereas the formula in E8 is not. The .xlsx file loaded and re-saved in Excel
works fine in LinreOffice. Apparently Google Sheets does something Excel does
not, which LibreOffice is not prepared for.
--
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
