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 |