[Libreoffice-bugs] [Bug 98481] SUM is zero when some cells are empty and some cells reference other sheet AND file is .xlsx AND file was created by Google Sheets.

https://bugs.documentfoundation.org/show_bug.cgi?id=98481 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreof

[Libreoffice-bugs] [Bug 98481] SUM is zero when some cells are empty and some cells reference other sheet AND file is .xlsx AND file was created by Google Sheets.

https://bugs.documentfoundation.org/show_bug.cgi?id=98481 --- Comment #10 from Eike Rathke --- Great fun .. :-/ Google writes t="str" for formula content. Excel writes t="str" for formula string results, which we consider during import and set a string result at the formula cell, which of course

[Libreoffice-bugs] [Bug 98481] SUM is zero when some cells are empty and some cells reference other sheet AND file is .xlsx AND file was created by Google Sheets.

https://bugs.documentfoundation.org/show_bug.cgi?id=98481 --- Comment #9 from Eike Rathke --- And actually this is it: Google Sheets attributes formula cells with t="str", which means "Cell containing a formula string.", which is correct but Excel does not (at least not 2010). Removing those attr

[Libreoffice-bugs] [Bug 98481] SUM is zero when some cells are empty and some cells reference other sheet AND file is .xlsx AND file was created by Google Sheets.

https://bugs.documentfoundation.org/show_bug.cgi?id=98481 Eike Rathke changed: What|Removed |Added Summary|SUM is zero when some cells |SUM is zero when some cells