Bug 132567 - FILEOPEN High CPU, does not complete loading a .xlsx file
Summary: FILEOPEN High CPU, does not complete loading a .xlsx file
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2020-04-30 21:37 UTC by Alain Williams
Modified: 2020-09-02 19:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
LibreOffice70-MaxColumns.png (22.60 KB, image/png)
2020-04-30 22:52 UTC, Bart
Details
LibreOffice7.0-ColumnsACYandACZ.png (83.76 KB, image/png)
2020-04-30 22:53 UTC, Bart
Details
LibreOffice70-ColumnsALWandALX.png (84.42 KB, image/png)
2020-04-30 22:54 UTC, Bart
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alain Williams 2020-04-30 21:37:55 UTC
The file is here, copy it & try to load it and it does not complete.

https://www.ons.gov.uk/file?uri=%2fpeoplepopulationandcommunity%2fcrimeandjustice%2fdatasets%2fdomesticabuseinenglandandwalesdatatool%2fyearendingmarch2019/datatool1819final.xlsx

I am running CentOS 6 on a 64 bit AMD machine.
Comment 1 MM 2020-04-30 22:34:30 UTC
Well, it opens on windows 10 x64 with Version: 6.4.3.2 (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: default; VCL: win

But there's an error: "The data could not be loaded completely because the maximum number of columns per sheet was exceeded."
Comment 2 Bart 2020-04-30 22:52:03 UTC
With LibreOffice 6.1 , 6.3 and 7.0 the document opens, but I get a message that the spreadsheet contains too many columns.

   Here are some details:

I first tried this with LibreOffice 7.0.

Loading the document went fairly fast, but then I had the message:
   Warning loading document datatool1891final.xlsx
   The data could not be loaded completely because 
   the maximum number of columns was exceeded

This can also be seen in attachment:
   "LibreOffice70-MaxColumns.png"

I click "OK" and I thought that the program would quit, but after a few seconds I still have the spreadsheet on my screen. Then I click and hold the scroll-bar underneath and drag it to the right to see how many columns I actually have. I had to do this repeatedly and at first I thought I was scrolling to the right where there are no more real (stored) columns, but then I saw a few columns that were slightly wider or narrower, like columns ACY , ACZ , ALW and ALX. In the end I could scroll all the way to column AMJ.

You can also see this in attachments:
   "LibreOffice70-ColumnsACYandACZ.png" and 
   "LibreOffice70-ColumnsALWandALX.png" 

As a short-term solution, did you receive the spreadsheet from someone else? If so, can you ask him or her to remove the redundant columns? Or maybe you can open the spreadsheet yourself in Excel and remove these columns yourself?

To check if anything still needs to be improved, please add the version you are using. Usually you can find it when clicking:
   Help -> About Libreoffice

It's most useful if you copy all the data there and paste it here in the report.

PS: 
- I'm not a developer. I submitted a few bugs/reports myself and I'm trying to confirm bug reports from other people here.
- As I don't know the level of your expertise, I may be adding information you already know and that's obvious to you, or not enough information.

					~~~

   These are the versions that I used:

Version: 6.1.5.2
Build ID: 1:6.1.5-3+deb10u5
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group threaded

Version: 6.3.4.1
Build ID: a21169d87339dfa44546f33d6d159e89881e9d92
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Version: 7.0.0.0.alpha0+
Build ID: 4d03bd252274308f64332e7c0523068c38ac684a
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-04-26_05:59:56
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 Bart 2020-04-30 22:52:58 UTC
Created attachment 160158 [details]
LibreOffice70-MaxColumns.png
Comment 4 Bart 2020-04-30 22:53:39 UTC
Created attachment 160159 [details]
LibreOffice7.0-ColumnsACYandACZ.png
Comment 5 Bart 2020-04-30 22:54:39 UTC
Created attachment 160160 [details]
LibreOffice70-ColumnsALWandALX.png
Comment 6 Telesto 2020-05-06 18:52:33 UTC
(In reply to MM from comment #1)
> Well, it opens on windows 10 x64 with Version: 6.4.3.2 (x64)
> Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
> CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
> 
> But there's an error: "The data could not be loaded completely because the
> maximum number of columns per sheet was exceeded."

Sounds like bug 50916
Comment 7 Buovjaga 2020-09-02 19:33:31 UTC
(In reply to Telesto from comment #6)
> (In reply to MM from comment #1)
> > Well, it opens on windows 10 x64 with Version: 6.4.3.2 (x64)
> > Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
> > CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
> > 
> > But there's an error: "The data could not be loaded completely because the
> > maximum number of columns per sheet was exceeded."
> 
> Sounds like bug 50916

Indeed, no need to keep this open as the loading otherwise works fine. Alain's result is understandable, if he indeed used the ancient 4.3 version.