This guide lists the maximum number of rows, columns, and cells in LibreOffice Calc.
LibreOffice Calc is a powerful spreadsheet program that provides users with a wide range of features for data analysis, calculation, and organization. Whether you are a student, a professional, or anyone who deals with numbers and data regularly, LibreOffice Calc is a valuable tool. One of the essential aspects of any spreadsheet software is its capacity to handle data, and LibreOffice Calc is no exception. In this article, we will explore the maximum number of rows, columns, and cells supported by LibreOffice Calc.
LibreOffice Calc has limits below for the number of rows, columns, and cells it can handle. This is for versions greater than 7.3.
Table of Contents
Maximum number of rows and columns in LibreOffice
- Maximum number of Columns per worksheet = 16384 (Col A to XFD).
- Maximum number of Rows per worksheet = 1048576 (2^20).
- Maximum number of cells per worksheet = 1,073,741,824 (2^30) (~more than 1 billion cells).
- Maximum number of characters in one cell = 2147483648 (~2^31) (~70 million characters).
- Maximum number of worksheets in a workbook = 10000.
- Maximum number of characters in a function result is 2^28.
- Maximum number of a formula’s tokens (internal data units after parsing the formula) is 8192.
Performance Considerations
While LibreOffice Calc provides an extensive workspace, it’s essential to consider performance implications when dealing with large sheets or workbooks. The responsiveness of LibreOffice may vary based on your computer’s processing power and available memory. If your spreadsheet is becoming sluggish, you may want to optimize your formulas, consider using data consolidation techniques, or split your data across multiple sheets.
About OpenOffice
- Maximum number of Columns per worksheet = 1024 (Col A to AMJ).
- Maximum number of Rows per worksheet = 1048576 (2^20).
Conclusion
With support for over a million rows and a thousand columns, it provides a vast workspace for organizing, analyzing, and presenting information. While using the above numbers, make sure to check the latest versions because they have the best performance.
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 how get count of filled rows?
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!
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”