/

Maximum Number of Rows, Columns, Cells in LibreOffice Calc

15479 views
17

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

 

libreoffice-calc-max-row-col


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

17 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Akos

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…

Umair

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

Alex

Ok, but how get count of filled rows?

Alex

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

Alex

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

Alex

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

Alex

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

Alex

Ok, but how get count of filled rows?

SSis

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.

mh

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

dan

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

Willim

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

Willim

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”

17
0
Would love your thoughts, please comment.x