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.
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."
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
Created attachment 160158 [details] LibreOffice70-MaxColumns.png
Created attachment 160159 [details] LibreOffice7.0-ColumnsACYandACZ.png
Created attachment 160160 [details] LibreOffice70-ColumnsALWandALX.png
(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
(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.