Bug 71121 - VIEWING: Opening xlsx file brings empty cells
Summary: VIEWING: Opening xlsx file brings empty cells
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium major
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-11-01 12:19 UTC by Mirza
Modified: 2015-10-27 16:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

This is the example file generated programatically in ASP.NET code. This file cant be opened correctly in libreoffice (8.77 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-11-01 12:19 UTC, Mirza

Note You need to log in before you can comment on or make changes to this bug.
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: release
Comment 1 ign_christian 2013-11-01 14:53:42 UTC
I don't know coding, but I can confirm reproducible with LO (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. 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.
Comment 7 QA Administrators 2015-04-19 03:23:41 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2015-06-19 14:47:53 UTC
No emptiness anymore on opening. WFM.

Win 7 Pro 64-bit Version:
Build ID: 437210d58f32177ef1829d704f7f4d2f1bbfbfdd
TinderBox: Win-x86@39, Branch:master, Time: 2015-06-18_07:21:56
Locale: fi-FI (fi_FI)
Comment 9 Mirza 2015-06-19 14:59:39 UTC
I can confirm that this now works for me also on LibreOffice on Win 8
Comment 10 Felipe 2015-10-27 16:29:23 UTC
Same problem here
LibreOffice 4.4.5