[Libreoffice-bugs] [Bug 132567] FILEOPEN High CPU, does not complete loading a .xlsx file

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132567

--- Comment #2 from Bart <bart-dn at tushmail.com> ---
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 at 86-TDF, Branch:master, Time:
2020-04-26_05:59:56
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200430/5f9b23c4/attachment.htm>