https://bugs.freedesktop.org/show_bug.cgi?id=64403

          Priority: medium
            Bug ID: 64403
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: LibreOffice Calc cannot open document without explicit
                    cell indexes
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: squink...@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.0.2.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 79065
  --> https://bugs.freedesktop.org/attachment.cgi?id=79065&action=edit
libreoffice_bugreport.xlsx

LibreOffice does not display cells without an explicit rowindex and cellindex,
while Microsoft Office correctly displays the generated spreadsheet and
verifies it as valid.

Attached you will find the sample generated file (libreoffice_bugreport.xlsx)
and the code used to generate it (using OpenXML SDK 2.0). The spreadsheet is
reported as valid in the OpenXML SDK productivity tool, and opens correctly in
Microsoft Office. The text in cell A1 displays "test". In LibreOffice, the text
in cell A1 is empty.

Reproduction:
1. Open the sample .xlsx document in LibreOffice.
2. If cell A1 is empty, the bug is repeated.
3. Open the sample .xlsx document in Microsoft Office.
4. Cell A1 contains the text "test".

[optional]
5. Open the .xlsx file in the OpenXML SDK 2.0 Productivity Tool
6. Click the "validate" button to see that Microsoft sees the generated
spreadsheet as valid OpenXML.

Attachments:
1. libreoffice_bugreport.xlsx: spreadsheet displaying the bug.
2. ExcelReport.cs: sample report generation using OpenXML SDK 2.0 from
Microsoft without row and cell indexes

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to