The maximum number of columns per sheet was exceeded

English
,
#1

When i tried to open some MS Excel files in LibreOffice Calc i get this warn. I searched solution of this issue but i did not find useful things. How can i increase number of column limit?

image description

I asked this question elsewhere. And I got the this answer:

LibreOffice Calc has below limits for number of rows, columns and cells that it can handle.

  • Maximum number of Columns per worksheet = 1024 (Col A to AMJ).
  • Maximum number of Rows per worksheet = 1048576 (2^20).
  • Maximum number of cells per worksheet = 1,073,741,824 (2^30).
  • Maximum number of characters in one cell = 32767
  • Maximum number of worksheets in a workbook = 10000

is this answer right?

#2

is this answer right?

It follows official FAQ.

There’s tdf#50916, which is not solved yet; it adds an experimental (and highly unstable) big table support, with 16k columns and 2m rows in upcoming version 7.0.

#3

Why this “2m” already used in the release notes? What about using standards and giving clearly understandable information? Somebody trying to make everything as funny as the date formats used in this site?
“Highly unstable” confirmed.

#4

Oh it was 16 million rows? I must had been confused.

#6

I’m working on an .xlsx format, currently with Libreoffice Calc only.
Recently I get this warning.
Actually I hide all columns greated G and all rows greater 500 anyway, as I don’t need them.
What lead to that warning? How can I cut all the higher columns and rows? How can I get rid of that warning?

Document saving also takes quite long currently, eventhough the resulting file size is only 94,1KiB.

#7

so you should change to »working with …ods«, until youre really need converting to …xlsx

#8

I need to, and working with .xlsx format is an official feature.
Is there no way to cut or delete columns and rows that are not needed? Exceeding the maximum nunnber of columns is a common issue and I don’t need more than 7 columns up to G. Maybe the max size was exceeded by inserting columns or something.

#9

I got it solved by:
Unhide all columns, mark all columns greater than G, delete columns, hide columns greater than G again.
It was not obvious that columns are deleted. The columns are still there after deletion as Calc does not seem to be able to really delete columns, only hide. But after saving the warning has disappeared.

#10

Can you upload this “phenomenal” .xlsx file?
In what version of LibreOffice did you open it?
Here is a book with the maximum number of columns possible. It opens for me without warning.

Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

Book.xlsx (8.1 KB)

#11

I tried to share the “phenomenal” .xlsx. As soon as I delete private notes and bitmaps, the issue disappears as well.
It’s weird, because notes and bitmaps are not affecting the column count…

#12

Where is the ‘last’ cell with data? Use Ctrl+End to find it. Perhaps you have a stray cell with data you don’t realise is there…

#5

@mesutcfc,

How can i increase number of column limit?

Can’t. Source: I have converted a large spreadsheet from another application to LibreOffice. Some rows are missing. What has happened? (2019-09-30 13:21:40)

Maximum number of characters in one cell = 32767
[Is] this answer right?

No. “70 million characters, although worked exceptionally laggy.” (I verified until 47001). Source: What is the maximum number of cells, rows, columns and sheets in a LibreOffice spreadsheet? (2020-04-13 13:07:46).

See more at: Frequently asked questions - Calc

You could edit your question, or comment an answer. Do not use Answer to comment.

If the answer solved your question, mark the circle to the left.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.