# 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

Feature Maximum limit
Number of cells

Limited by system resources (JavaScript)

Can be set in the configuration:

  • MaxRows (default: 40 000)
  • MaxColumns (default: 18 278)
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

Feature Maximum limit
Default number precision 15 digits (inherited from JavaScript)
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)