Maximum Number of Rows, Columns, Cells in LibreOffice Calc

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


SEE ALSO:  Protect LibreOffice Document with Password

arindam

IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

17 thoughts to “Maximum Number of Rows, Columns, Cells in LibreOffice Calc”

  1. 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

  2. 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.

  3. 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

  4. 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”

Leave a Reply

Your email address will not be published. Required fields are marked *

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