Ask Your Question

Calc truncated columns from an imported (huge) xlsx sheet. Is this a bug or a known limitation of LibreOffice Calc?

asked 2016-02-10 15:43:55 +0200

acsipak gravatar image

updated 2016-03-09 18:26:31 +0200

Alex Kemp gravatar image

So, I got this big xlsx sheet: last nonempty column is ARP (1160 columns). I imported it into Calc (, the last visible column is AMJ (1024 columns remained), the rest got truncated.

Is this a bug or a known limitation of the xlsx import function / Calc itself?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-02-10 16:01:59 +0200

acsipak gravatar image

Looks like it's a bug, see Bug 50196 in the DocumentFoundation Bugzilla.

(Also some personal opinion: Bugzilla is a disaster, especially because it's difficult to search efficiently. I searched for this bug before posting the question with Bugzilla's built-in search and with Google too, and did not find the linked bug. Thanks for the Wikipedia article on LibreOffice Calc mentioning the 1024-column limitation and linking the bug in the references section.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-02-10 15:21:05 +0200

Seen: 65 times

Last updated: Feb 10 '16