Specifications and limits
The following table presents the limits of features. Many of them are bounded only by system resources. This means the actual limit depends on several factors, for example, the resources (such as available memory) of the device HyperFormula is running on.
Sheet and cell limits
Section titled “Sheet and cell limits”| Feature | Maximum limit |
|---|---|
| Number of cells |
Limited by system resources (JavaScript) Can be set in the configuration:
|
| Number of nested levels of functions | 120 |
| Earliest date allowed for the calculation | December 30, 1899 |
| Latest date allowed for the calculation | December 31, 9999 |
| Number of named expressions | Limited by system resources (JavaScript) |
| Characters in a cell | Limited by system resources (JavaScript) |
| Characters in a named expression | Limited by system resources (JavaScript) |
| Characters in a sheet name | Limited by system resources (JavaScript) |
| Characters in a column name | Depends on the configuration of MaxColumns |
| Number of sheets in a workbook | Limited by system resources (JavaScript) |
| Number of custom functions | Limited by system resources (JavaScript) |
| Undo levels | Limited by the configuration - undoLimit (default: 20) |
| Number of elements in a batch operation | Limited by system resources (JavaScript) |
Calculation limits
Section titled “Calculation limits”| Feature | Maximum limit |
|---|---|
| Number precision | ~15 significant digits (with all the limitations of the JavaScript floating-point arithmetics). HyperFormula rounds the operation results according to the precisionRounding configuration option. |
| Smallest magnitude allowed negative number | -5E-324 (inherited from JavaScript) |
| Smallest magnitude allowed positive number | 5E-324 (inherited from JavaScript) |
| Largest magnitude allowed positive number | 1.79E+308 (inherited from JavaScript) |
| Largest magnitude allowed negative number | -1.79E+308 (inherited from JavaScript) |
| Length of a single formula’s contents | Limited by system resources (JavaScript) |
| Number of iterations | Not supported |
| Arguments in function | Limited by system resources (JavaScript) |
| Number of cross-sheet dependencies | Limited by system resources (JavaScript) |
| Number of dependencies in a single cell | Limited by system resources (JavaScript) |