Bug 128299 - LibreOffice Unable to Open .xlsx spreadsheet
Summary: LibreOffice Unable to Open .xlsx spreadsheet
Status: RESOLVED DUPLICATE of bug 50916
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-21 15:12 UTC by Vaughn Reid III
Modified: 2019-10-21 16:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample Spreadsheet that Fails to Open Correctly (9.54 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-10-21 15:14 UTC, Vaughn Reid III
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Vaughn Reid III 2019-10-21 15:12:37 UTC
Description:
LibreOffice appears to fail when trying to open larger xlsx spreadsheets.  



Steps to Reproduce:
1.  Download Lenovo "ThinkPad, ThinkCentre, ThinkStation, Ideapad and Ideacentre Option Compatibility Matrix from here:  https://support.lenovo.com/us/en/solutions/accs-guide

For Example, the October 2019 version is here:  https://download.lenovo.com/pccbbs/options_iso/ocm_october_2019.xlsx
2. Open the downloaded xlsx file with LibreOffice Calc
3.  The document will try to open for several minutes.  After this time, Calc will pop up a notification "Warning loading document ocm_october_2019.xlsx: The data could not be loaded completely because the maximum number of columns per sheet was exceeded."

Actual Results:
The spreadsheet then loads, but some portions may not have loaded correctly -- at least according to the warning message.

Expected Results:
I expect LibreOffice to open an .xlsx spreadsheet without errors


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Vaughn Reid III 2019-10-21 15:14:39 UTC
Created attachment 155202 [details]
Sample Spreadsheet that Fails to Open Correctly

I'm attaching a sample spreadsheet that I got from the Lenovo link provided in the bug report that causes the error to happen.
Comment 2 Gabor Kelemen (allotropia) 2019-10-21 16:16:59 UTC
This happens because Calc supports only 1024 columns and Excel does 16384.

*** This bug has been marked as a duplicate of bug 50916 ***