Ask Your Question

Maximum number of columns exceeded warning

asked 2018-05-08 17:50:36 +0100

bujjiece4u gravatar image


I use the LibraOffice on windows 10 and see this error. image description

"The data could not be loaded completely because the maximum number of columns per sheet was exceeded" Warning

Please help on the same.

Thanks, Bujji

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-05-08 18:01:08 +0100

Mike Kaganski gravatar image
edit flag offensive delete link more


Likely not related (unless there are really more than 1024 columns used), see my answer.

erAck gravatar imageerAck ( 2018-05-08 19:19:06 +0100 )edit

answered 2018-05-08 19:18:23 +0100

erAck gravatar image

tdf#116274 and tdf#116939 will be fixed in 6.0.4 (and btw it's always good to state the version number you use).

edit flag offensive delete link more


I agree to be clear we need to provide the version. I'm using latest 6.0.3 version. I will wait for the latest release 6.0.4. Is there some tentative time for the new release?

bujjiece4u gravatar imagebujjiece4u ( 2018-05-09 12:10:18 +0100 )edit

Released today.

erAck gravatar imageerAck ( 2018-05-09 17:33:48 +0100 )edit

I just installed (x64) on a Windows 10 machine. Yet this problem persists. Any update? Thanks in advance.

Cesar gravatar imageCesar ( 2018-05-16 17:41:40 +0100 )edit

Your document probably has applied custom widths to columns >1024, see tdf#116939#c22. It's not a real problem, just a warning, albeit confusing, hence that check will be disabled for 6.0.5.

erAck gravatar imageerAck ( 2018-05-16 17:56:28 +0100 )edit

Same error. Version

The file in question has 22 worksheets. There are references to other sheet. But they are at most N columns (14 columns).

So the error actually indicates something else is causing it.

jj6308 gravatar imagejj6308 ( 2018-09-16 00:34:05 +0100 )edit

Another xlsx has 17 worksheets. There are at most M columns (13). Got the same error.

Both file open correctly, though.

jj6308 gravatar imagejj6308 ( 2018-09-16 00:53:16 +0100 )edit

Upgrade to . Both xlsx are seeing the same errors but still open fine.

jj6308 gravatar imagejj6308 ( 2018-09-16 00:59:16 +0100 )edit

Upgraded to 6.1.2 and still getting this warning on multiple xlsx's, eventhough there's not where near the 1024 column limit. Will this ever be fixed?

dachr gravatar imagedachr ( 2018-10-23 13:45:09 +0100 )edit

Where's your document and how can you be sure that Excel doesn't write something that tells that a column > 1024 is used? If it's about one of the documents mentioned in tdf#116274then see for why the warning is correct.

erAck gravatar imageerAck ( 2018-10-23 14:44:40 +0100 )edit

answered 2018-08-28 14:46:19 +0100

I have Calc and still have the same problem:

Warning loading document wookbook.xlsx: The data could not be loaded completely because the maximum number of columns per sheet was exceeded.

Any update?

edit flag offensive delete link more


See my answer and comment by @erAck - so if you actually happen to have more than 1024 columns, it's expected.

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-28 14:51:39 +0100 )edit
Login/Signup to Answer

Question Tools



Asked: 2018-05-08 17:50:36 +0100

Seen: 4,266 times

Last updated: Aug 28 '18