Ask Your Question
0

Maximum number of columns exceeded warning

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

bujjiece4u gravatar image

Hi,

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
1

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

Mike Kaganski gravatar image
edit flag offensive delete link more

Comments

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

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

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

I have Calc 6.0.6.2 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

Comments

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 +0200 )edit
0

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

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

Comments

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 +0200 )edit

Released today.

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

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

Cesar gravatar imageCesar ( 2018-05-16 17:41:40 +0200 )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 +0200 )edit

Same error. Version 6.0.5.2.

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 +0200 )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 +0200 )edit

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

jj6308 gravatar imagejj6308 ( 2018-09-16 00:59:16 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 2,681 times

Last updated: Aug 28