Ask Your Question

Erroneous warning of max num of columns exceeded.

asked 2018-04-24 12:48:46 +0200

kbou gravatar image

updated 2018-04-24 13:02:46 +0200

Hi. When I open in Calc most xlsx files created by MS 365, I get a warning that not all data have been loaded since the max number of columns per sheet has been exceeded. The max number of columns in one example is only 15. Also when I drag the scrollbar to the right, it goes up to column AMJ (I guess it is the 1024th column). Obviously all cells after column N are empty and I don't see any loss of data. Am I missing something? Libreoffice 6.0.3 fresh install on Win 10.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-04-24 13:00:29 +0200

erAck gravatar image

Excel may add an excess columns definition even if there isn't any data, which triggers the warning. Related is tdf#116274.

edit flag offensive delete link more


Fixed for 6.0.4

erAck gravatar imageerAck ( 2018-04-26 13:13:29 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-24 12:48:46 +0200

Seen: 1,333 times

Last updated: Apr 24 '18