**This guide lists the maximum number of rows, columns, and cells in LibreOffice Calc.**

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**

Based on this: https://wiki.documentfoundation.org/Faq/Calc/022 the maximum number of sheets was increased to 10000. I test in LO 5.3 and I can create 270, but I don’t try to create more…

I am using latest version of libre office. I get maximum character limit exceeded alert in calc. I have addresses in the sheet. It is in csv format. When I open it in ms excel, all works fine. For example, the address looks like this – 10 Rue Verte Newport Beach California 92660 USA

Hi

Maximum character limit in a single cell is 32767 in LibreOffice CALC and Microsoft Excel both. I am not sure what your spreadsheet contains. Please share your spreadsheet at support@libreofficehelp.com. Let me take a look.

Ok, but how get count of filled rows?

Ok, but where I can get number of filled rows? Not maximum, but filled, not empty!

Ok, I found it!

For get number of filled rows need go to Edit -> Selection -> Select Data Area and see number in status bar!

Ok, but where I can get number of filled rows? Not maximum, but filled, not empty!

Ok, I found it!

For get number of filled rows need go to Edit -> Selection -> Select Data Area and see number in status bar!

Ok, but how get count of filled rows?

Noticed that there is also a MAX number of entries that the pivot tables in LO Calc will process.

Have a clinical data dbase here of 26 columns. Data entries past ~ 5200 – 5300 are no longer entered in the resulting pivot tables.

Posting it here, because some might not notice and thus end up with weird/ wrong conclusions with regard to their data.

Since I don’t use/ have MS, can’t tell you whether Excel handles this better/ worse.

There is no limit to row/cols in Pivot tables as per doc. How many rows+cols your source data have?

hello bro

how i open the first 1000 column from my csv file?

You have to open and then delete the columns you don’t want.

I need more columns than 1024. I need more 130 at least. Can i do something about it??

That’s the 1024 limitation at the moment. You can try to split your data logically into multiple sheets.

Linux Mint 20 16GiB Memory 2.0GiB Swap

Calc Build ID 1:6.4.6-0ubuntu0.20.04.1

From my tests there seems to be a limit of between 11 534 336 and 13 037 568 active cells that will save to disc. More can be displayed but don’t save – Calc is terminated and file has to be recovered.

From variation in file size 56.7Mb 120.1Mb I doubt if it is a file size restriction, I could be wrong.

if A -AMJ filled only 12732 rows 120.1Mb 13_037_568 cells

A1=1 B1=A1+10 C1=B1+10 … AMJ1=AMI1+10

A2=A1+1 B2=B1+1 C2=C1+1 … AMJ2=AMJ1+1

row 2 copied to rows 3 – 12732

if A1 – A1048576 filled only to column K 56.7Mb 11_534_336 cells

column B copied to columns C to K

A1=1 B1=A1+1

A2=A1+1 B2=B2+1

A3=A2+1 B3=A3+1

A1048576=A1048575+1 B1048576=A1048576+1

A1 can be changed to say 10 file saves and can be changed to 1 again

with no issues if 12732 rows or K columns

Linux Mint 20 16GiB Memory 2.0GiB Swap

Calc Build ID 1:6.4.6-0ubuntu0.20.04.1

From my tests there seems to be a limit of between 11 534 336 and 13 037 568 active cells that will save to disc. More can be displayed but don’t save – Calc is terminated and file has to be recovered. But it is only recovered to last “Save.”

From variation in file size 56.7Mb 120.1Mb I doubt if it is a file size restriction, I could be wrong. To me it seems to be related to the number of active cells.

if A -AMJ filled only 12732 rows 120.1Mb 13_037_568 cells

A1=1 B1=A1+10 C1=B1+10 … AMJ1=AMI1+10

A2=A1+1 B2=B1+1 C2=C1+1 … AMJ2=AMJ1+1

row 2 copied to rows 3 – 12732

if A1 – A1048576 filled only to column K 56.7Mb 11_534_336 cells

column B copied to columns C to K

A1=1 B1=A1+1

A2=A1+1 B2=B2+1

A3=A2+1 B3=A3+1

A1048576=A1048575+1 B1048576=A1048576+1

A1 can be changed to say 10 file saves and can be changed to 1 again

with no issues if 12732 rows or K columns

Further tests and summary

12732 AMJ (1024) 13_037_568 120.1MB

25347 SR (512) 12_973_056 117.8MB

50601 IV (256) 12_956_160 117.3MB

100810 DX (128) 12_903_680 108.7MB

198896 BL ( 64) 12_729_344 102.5MB

Working downwards Columns halved and Rows duplicated

262144 AV (48) 12_582_912 61.0MB

524288 X (24) 12_582_912 61.6MB

1048576 K (11) 11_534_336 56.5MB

Working upwards Rows halved and Columns duplicated

Cannot copy row 50601 to 50602 or column AV to AW …

Additional rows/columns are calculated properly but do NOT save to disc.

When document is recovered it is only to last “Save”