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 (220);
- the maximum number of cells in one sheet is 1,073,741,824 (230 which is more than 1 billion cells);
- the maximum number of characters in one cell is
32767(needs updating - likely 231 is the programmatic limit; tested to accept 70 million characters, although worked exceptionally laggy);
- the maximum number of characters in one cell is
- the maximum number of individual sheets in a complete worksheet is 10000.
See also this FAQ I converted a large spreadsheet from another application into LibreOffice. Some rows are missing; what has happened?