Skip to main content

Worksheet and Workbook Specifications

  • 3 minutes to read

Worksheet and workbook specifications (XLSX and XLTX file formats)


Feature Maximum limit
Open workbooks Limited by available memory and system resources
Worksheet size Number of rows and columns is limited by available memory and system resources. When exporting to Microsoft Excel®, the maximum number of columns is 16384, the maximum number of rows is 1048576.
Column width 255 characters
Row height 409 points
Length of cell contents (text) Limited by available memory and system resources
Sheets in a workbook Limited by available memory (default is 3 sheets).
Colors in a workbook 16 million colors (32 bit with full access to 24 bit color spectrum)
Cell styles in a workbook 64,000
Custom number formats Between 200 and 250, depending on the language version
Linked sheets Limited by available memory
Custom functions Limited by available memory

Calculation specifications (XLSX and XLTX file formats)


Feature Maximum limit
Number precision 15 digits
Largest allowed positive number 9.99999999999999E+307
Smallest allowed negative number -2.2251E-308
Smallest allowed positive number 2.2251E-308
Largest allowed negative number -9.99999999999999E+307
Length of formula contents 8,192 bytes
Selected ranges 1
Arguments in a function The argument string’s length should be less than 255 characters
Nested levels of functions Limited by available memory
Number of available worksheet functions Limited by available memory
Zero based date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used)
Largest amount of time that can be entered 9999:59:59

Worksheet and workbook specifications (XLS file format)


Feature Maximum limit
Open workbooks Limited by available memory and system resources
Worksheet size Number of rows and columns is limited by available memory and system resources. When exporting to Microsoft Excel®, the maximum number of columns is 256, the maximum number of rows is 65536.
Column width 65536 points
Row height 65536 points
Length of cell contents (text) Limited by available memory and system resources
Sheets in a workbook 256 max (default is 3 sheets).
Colors in a workbook 56 colors in the custom palette
Cell styles in a workbook Number of cells + 1, up to 4050 styles total
Custom number formats Not available in the current version
Linked sheets Limited by available memory
Custom functions Only correctly registered functions that correspond to Excel functions can be exported.

Calculation specifications


Feature Maximum limit
Number precision 15 – 16 digits
Largest allowed positive number 1.7 x 10^308
Smallest allowed negative number -5.0 x 10^-324
Smallest allowed positive number 5.0 x 10^-324
Largest allowed negative number -1.7 x 10^308
Length of formula contents 8024 bytes
Selected ranges 1
Arguments in a function The argument string’s length should be less than 254 characters
Nested levels of functions Limited by available memory
Number of available worksheet functions Limited by available memory
Zero based date allowed for calculation January 1, 1900
Largest amount of time that can be entered 9999:99:99