Bug 116306 - Warning maximum number of columns exceeded
Summary: Warning maximum number of columns exceeded
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2018-03-09 09:50 UTC by Elmar
Modified: 2018-06-25 13:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

example file (2.73 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-03-09 09:55 UTC, Elmar

Note You need to log in before you can comment on or make changes to this bug.
Description Elmar 2018-03-09 09:50:35 UTC
Warning loading document dale EC_ProjectUpdatedReport_2018-03-08 09-17.xlsx:
The data could not be loaded completely because the maximum number of columns per sheet was exceeded.

Steps to Reproduce:
1. Open document 
2. warning, document opens, seems fine
3. Open using Calc v5.4, no warning

Actual Results:  
as described

Expected Results:
as described

Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 Elmar 2018-03-09 09:55:14 UTC
Created attachment 140497 [details]
example file
Comment 2 Aron Budea 2018-03-10 07:25:44 UTC
No warning with LO 6.1 x64 daily build (d5837fcf2b1c60cfe29e2f41f32e22213710a1b8, 2018-02-28_02:16:25) / Windows 7.
Might be Linux-only, nevertheless, could you paste the version details from Help -> About?
Comment 3 Elmar 2018-03-10 07:35:52 UTC
Build ID: d4347f5d585232e1b025b4199ded53e6619d6242
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-03-09_02:44:04
Locale: en-ZA (en_ZA.UTF-8); Calc: group
Comment 4 Elmar 2018-03-10 08:02:30 UTC
I can confirm that it opens fine in Excel 2010.

I have saved it to ODS in Calc and it then ODS opens without a problem in Calc.

I did also open the ODS in Excel 2010, and gte this message:
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Comment 5 Buovjaga 2018-03-11 14:50:29 UTC
It is not a bug, see bug 114555
Comment 6 Aron Budea 2018-03-11 15:09:48 UTC
The interesting part is that when I open the file in Excel, it doesn't seem to contain that many columns... maybe it's saved with empty values that are disregarded or something, one would have to check the XML to see.