[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|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | --- Comment #11 from Eike Rathke --- So, actually Google got this wrong, the 't' attribute indicates the cell's data type, which is of the cell value ( element), not the formula string (that is the element) but the formula result. See ECMA-376 18.3.1.4 c (Cell) 18.18.11 ST_CellType (Cell Type) Excel uses t="str" for a formula result string, that is not a formula string ... probably because t="s" could not be used because the result string is not a shared string, and with t="inlineStr" the element could not be used for the result but an element instead but formulas can't return rich strings ... That's totally f*cked up. -- 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
[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 is ignored in SUM(range), hence that result is 0. -- 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
[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 attributes from the xl/worksheets/sheet1.xml stream makes LibreOffice load the document correctly. -- 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
[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 |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 --- 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
