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 |