Q Really big numbers
I’m fairly new to Linux and run Linux Mint 21 on my desktop. Every time I try to open an XLSX sheet that I have either been sent or downloaded, I get the error message below:
Warning loading document abc.xlsx The data could not be loaded completely because the maximum number of columns per sheet was exceeded
Is there a way to overcome this or know what has been lost, if anything?
Ian Madley
A Looking at the sample sheet you sent, which produced no warnings in LibreOffice 7.6, there are no sheets with large numbers of columns. The column limit in LibreOffice was 1,024 up until version 7.3. From LibreOffice 7.4 onwards, the column limit was increased to 16,384, so you are unlikely to hit this.
We have seen this behaviour in the past, but not recently. It appears to be a combination of the way saves the information in the files and the way reads it, leading to think there are more columns than there really are. As long as your XLSX files do not include insane numbers of columns, you are safe to ignore this warning, as annoying and alarming as it may be. Saving the file from should prevent the message appearing again. Linux Mint 21 currently includes which has the lower column limit, but still within the needs of your files. So, it is a matter of waiting for updates to install a later version without this issue. If you find it really annoying, you could uninstall from the Mint software manager, but that is a course of action that we do not recommend. The software manager makes sure everything on your system works in harmony; installing packages outside of this system can cause problems, especially for a fairly new user.