Bug 71121

Summary: VIEWING: Opening xlsx file brings empty cells
Product: LibreOffice Reporter: Mirza <mirza.dervisevic>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium    
Version: 3.6.7.2 release   
Hardware: Other   
OS: All   
Whiteboard: BSA
i915 platform: i915 features:
Attachments: This is the example file generated programatically in ASP.NET code. This file cant be opened correctly in libreoffice

Description Mirza 2013-11-01 12:19:05 UTC
Created attachment 88472 [details]
This is the example file generated programatically in ASP.NET code. This file cant be opened correctly in libreoffice

Problem description: Opening xlsx file brings empty cells
Please see the attached file

Steps to reproduce:
1. Open xlsx file
2. ....
3. ....

Current behavior: It opens as everything is empty

Expected behavior: The file is not empty and it contains data, when opened in google docs or ms office data is displayed correctly

              
Operating System: Windows 7
Version: 4.1.2.3 release
Comment 1 ign_christian 2013-11-01 14:53:42 UTC
I don't know coding, but I can confirm reproducible with LO 3.6.7.2 (Ubuntu 12.04 32bit)
Comment 2 Urmas 2013-11-04 03:29:33 UTC
Confirmed in master.
Comment 3 reddish 2013-11-06 11:55:35 UTC
Confirmed in L.O. 4.1.3.2 under WinXP. 

Convering the file to xls with MS XML converter allows the content to be seen OK in L.O.
Comment 4 Mirza 2013-11-19 08:17:09 UTC
If this gets fixed in development version or something, please notify me by updating this bug report, as I am using LibreOffice at my office and this is causing me problems.

Also if there is anything else that I can contribute testing or something please just say.

Thank you for your efforts.
Comment 5 Maxim Monastirsky 2013-11-19 11:03:57 UTC
Correcting Version & Platform according to comment 1.
Comment 6 Mirza 2013-11-27 13:48:39 UTC
The colleague of mine that was working on generating this file problematically in .NET code found and fixed the problem in file generation process.

While generating file he didn't enter cell references for example A14, B23 etc.

This didn't seem to bother MSOffice Excel but did cause problems with LibreOffice where it seem it is mandatory to properly fill cell reference.

I hope this helps.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.