Issue 126344

Summary: Hand made (validated) xlsx displayed blank
Product: Calc Reporter: raffaele
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CLOSED DUPLICATE QA Contact: Dolores Zurdo <dolores.zurdo.consuegra>
Severity: Normal    
Priority: P5 (lowest) CC: allan.jardine, damjan, dolores.zurdo.consuegra, raffaele
Version: 4.1.2Keywords: interop_OOXML
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
Sample file generated
none
Image of the file open with oppenoffice
none
Image of the file open with excel (in a virtual machine) none

Description raffaele 2015-05-29 08:12:36 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.
Comment 1 oooforum (fr) 2015-11-12 08:26:28 UTC
*** Issue 126644 has been marked as a duplicate of this issue. ***
Comment 2 Dolores Zurdo 2015-11-12 16:09:17 UTC
Created attachment 85127 [details]
Image of the file open with oppenoffice
Comment 3 Dolores Zurdo 2015-11-12 16:10:01 UTC
Created attachment 85128 [details]
Image of the file open with excel (in a virtual machine)
Comment 4 Dolores Zurdo 2015-11-12 16:11:53 UTC
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
Comment 5 damjan 2023-01-08 08:56:59 UTC
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 ***