Faq/Calc/022

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

Template:TopMenu/en Template:Menu/en Template:Menu.Documentation/en Template:Menu.FAQ/en

Other languages:
dansk • ‎Deutsch • ‎English • ‎français • ‎italiano • ‎русский

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;
  • 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?