Skip to content
v3.4.0
Search
Ctrl
K
Cancel
—
Guide
API
Demo
GitHub
Support
GitHub Issues
Contact
Commercial license
Introduction
Welcome
Demo
Getting started
Client-side installation
Server-side installation
Basic usage
Advanced usage
Configuration options
License key
Set up your coding agent
Integrations
Integration with React
Integration with Vue
Integration with Angular
Integration with Svelte
Integration with Vercel AI SDK
Integration with LangChain
HyperFormula MCP Server
Data operations
Basic operations
Batch operations
Clipboard operations
Undo-redo
Sorting data
Formulas
Specifications and limits
Cell references
Types of values
Types of errors
Types of operators
Order of precedence
Built-in functions
Volatile functions
Named expressions
Array formulas
Internationalization
Internationalization features
Localizing functions
Date and time handling
Currency handling
Compatibility
Compatibility with Microsoft Excel
Compatibility with Google Sheets
Runtime differences with Microsoft Excel and Google Sheets
Advanced topics
Key concepts
Dependency graph
Building & testing
Custom functions
Performance
Known limitations
File import
Upgrade and migration
Release notes
Migrating from 0.6 to 1.0
Migrating from 1.x to 2.0
Migrating from 2.x to 3.0
About
Quality
Supported browsers
Dependencies
Licensing
Miscellaneous
Contributing
Code of conduct
Branding
Contact
API Reference
API Reference Overview
classes
AbsoluteCellRange
AbsoluteColumnRange
AbsoluteRowRange
AddColumnsCommand
AddColumnsUndoEntry
AddNamedExpressionUndoEntry
AddRowsCommand
AddRowsUndoEntry
AddSheetUndoEntry
AdvancedFind
AliasAlreadyExisting
ArraySize
ArraySizePredictor
ArrayValue
BaseUndoEntry
BatchUndoEntry
BuildEngineFactory
Boolean
Empty
Error
Formula
Number
String
CellContentParser
CellError
ChangeNamedExpressionUndoEntry
ClearSheetUndoEntry
Clipboard
ClipboardOperations
ColumnBinarySearch
ColumnIndex
ColumnsSpan
Config
ConfigValueEmpty
ConfigValueTooBigError
ConfigValueTooSmallError
ContentChanges
CrudOperations
DateTimeHelper
DetailedCellError
Emitter
EmptyStatistics
ErroredArray
ErrorMessage
EvaluationSuspendedError
Evaluator
ExpectedOneOfValuesError
ExpectedValueOfTypeError
ExportedCellChange
ExportedNamedExpressionChange
Exporter
FunctionPluginValidationError
GraphBuilder
HyperFormula
HyperFormulaNS
InternalNamedExpression
InvalidAddressError
InvalidArgumentsError
LanguageAlreadyRegisteredError
LanguageNotRegisteredError
LazilyTransformingAstService
MissingTranslationError
MoveCellsUndoEntry
MoveColumnsUndoEntry
MoveRowsUndoEntry
NamedExpressionDoesNotExistError
NamedExpressionNameIsAlreadyTakenError
NamedExpressionNameIsInvalidError
NamedExpressions
NoOperationToRedoError
NoOperationToUndoError
NoRelativeAddressesAllowedError
NoSheetWithIdError
NoSheetWithNameError
NotAFormulaError
NotComputedArray
NothingToPasteError
NumberLiteralHelper
Operations
PasteUndoEntry
ProtectedFunctionError
ProtectedFunctionTranslationError
RemoveColumnsCommand
RemoveColumnsUndoEntry
RemoveNamedExpressionUndoEntry
RemoveRowsCommand
RemoveRowsUndoEntry
RemoveSheetUndoEntry
RenameSheetUndoEntry
RowSearchStrategy
RowsSpan
Serialization
SetCellContentsUndoEntry
SetColumnOrderUndoEntry
SetRowOrderUndoEntry
SetSheetContentUndoEntry
SheetNameAlreadyTakenError
SheetSizeLimitExceededError
SheetsNotEqual
SimpleRangeValue
SimpleStrategy
SourceLocationHasArrayError
Statistics
TargetLocationHasArrayError
UnableToParseError
UndoRedo
WorkbookStore
WorksheetStore
enums
CellType
CellValueJustNumber
CellValueNoNumber
ClipboardCellType
ClipboardOperationType
ErrorType
Events
FormatExpressionType
LicenseKeyValidityState
StatType
TokenType
API Reference Overview
interfaces
AdvancedFindOptions
CellArray
CellRange
CellValueChange
ChangedCell
ChangeExporter
ClipboardCellEmpty
ClipboardCellFormula
ClipboardCellParsingError
ClipboardCellValue
ColumnSearchStrategy
ColumnsRemoval
ConfigParams
FormatExpression
FormatToken
GraphBuilderStrategy
Listeners
MoveCellsResult
NamedExpression
RowsRemoval
SearchOptions
SearchStrategy
SerializedNamedExpression
SheetBoundaries
SheetCellAddress
SimpleCellAddress
SimpleCellRange
SimpleColumnAddress
SimpleDate
SimpleRowAddress
SimpleTime
TemplateVars
TypedEmitter
UndoEntry
ValueIndex
modules
CellContent
GitHub
CellValueJustNumber
Enumeration members
Section titled “Enumeration members”
NUMBER
Section titled “NUMBER”
•
NUMBER
: = “NUMBER”
Defined in
src/Cell.ts:88
