# HyperFormula guide
# What is HyperFormula?
HyperFormula comes with a huge library of 389 built-in functions grouped into categories:
- Array manipulation
- Date and time
- Lookup and reference
- Math and trigonometry
- Matrix functions
The functions use A1 notation and are compatible with popular spreadsheet software like Excel or Google Sheets, which means that you can easily transfer the data and formulas between them.
HyperFormula covers most user-triggered actions such as CRUD operations, undo/redo, and clipboard operations. It also supports the use of cross-sheet references, named expressions, different data types, and custom functions.
# What can I use it for?
HyperFormula doesn't assume any existing user interface (UI), which makes it a great general-purpose library that can be used in various business applications. Here are some ideas on what you can build with HyperFormula:
- Smart documents
- Educational apps
- Computation notebooks
- Data grid components
- Business logic builders
- Forms and form builders
- Online calculators
- Low connectivity apps
# Core features
The features that HyperFormula offers make it a flexible and easy to use tool for many types of software.
- High-speed formula calculations
- A library of 389 built-in functions available in 16 languages
- Support for cross-sheet references
- Support for undo/redo
- Support for copy/cut/paste
- Support for wildcard characters
- Support for data sorting
- Written in TypeScript and extensively tested
- Uses GPU acceleration for better performance
- Function syntax compatible with Excel and Google Sheets
- Double-licensed: GPL/Commercial
- Actively maintained and supported by the Handsontable (opens new window) team
This documentation is licensed under CC BY 4.0 (opens new window).