Apache OpenOffice (AOO) Bugzilla – Issue 126344
Hand made (validated) xlsx displayed blank
Last modified: 2023-01-08 15:51:37 UTC
Created attachment 84765 [details] Sample file generated This XLSX file, hand generated and validated by Open XML SDK 2.5 Productivity Tool, opens in OpenOffice 4.1.1 but it is displayed as an empty sheet. Opening the same file in other programs (i.e. Microsoft Excel, LibreOffice) correctly displays data. No errors or warnings are displayed.
*** Issue 126644 has been marked as a duplicate of this issue. ***
Created attachment 85127 [details] Image of the file open with oppenoffice
Created attachment 85128 [details] Image of the file open with excel (in a virtual machine)
I have checked the error: I open the file in OpenOffice 4.1.2. con Ubuntu 14.04 LTS 64 bits and i can not see any data. I attached figure: Testing_Issue 126344_Openoffice.png I have opened the same file with a Virtual Machine (Win 7) Operating System Windows 7 (32-bit). Microsoft Office Profesional Plus 2010 (32 bits). See figure: Testing_Issue 126344_Openoffice.pn
The problem is that the cells in this file lacks the r="..." attribute, and OpenOffice previously just ignored such cells: <c t="inlineStr"> <is> <t>Iban</t> </is> </c> This was fixed recently in bug 127672, so resolving this bug as a DUPLICATE. The fixed version opens the file just fine and displays everything. Thank you for your bug report and sample file :-). *** This issue has been marked as a duplicate of issue 127672 ***