The maximum number of columns per sheet was exceeded

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?

Solution 1:

How can i increase number of column limit?

The maximum number of columns per sheet is 1024. If the file from Excel you are trying to open has more than 1024 columns, you won't be able to open it. Currently, there is no workaround to increase the number.

Other limits in Libre Office Calc include:

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

Version 7 might support it when it is released. Try the prerelease of version 7 and enable support as indicated on the link.

Solution 2:

1. Options... ▸ LibreOffice ▸ Advanced ▸ Optional Features ▸ Enable experimental features (may be unstable)

2. Restart LibreOffice

3. Options... ▸ LibreOffice Calc ▸ Defaults ▸ New Spreadsheet ▸ Enable very large spreadsheets (16m rows, 16384 cols)