# Frequently asked questions - Calc

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## What is the maximum number of cells, rows, columns and sheets in a LibreOffice spreadsheet?

- The maximum number of columns is 1,024 (from column A to column AMJ);
- the maximum number of rows is 1,048,576 (2
^{20}); - the maximum number of cells in one sheet is 1,073,741,824 (2
^{30}which is more than 1 billion cells);- the maximum number of characters in one cell is
~~32767~~(needs updating - likely 2^{31}is the programmatic limit; tested to accept 70 million characters, although worked exceptionally laggy);- the maximum number of characters in a function result is 2
^{28}(256Mi)^{[1]}; - the maximum number of a formula's
**tokens**(internal data units after parsing the formula) is**4096/sizeof(pointer)**(1024 in 32-bit program, 512 in 64-bit program)^{[2]}. This does not map 1:1 to number of characters or functions in a formula, but still limits its complexity (would give error for too complex formulas);

- the maximum number of characters in a function result is 2

- the maximum number of characters in one cell is
- the maximum number of individual sheets in a complete worksheet is 10000.