# HyperFormula guide

# What is HyperFormula?

HyperFormula is an open-source calculation engine that allows you to perform Excel-like calculations in your business applications. It is written in TypeScript and works with major JavaScript frameworks like Vue, React, and Angular. You can use it in a browser or as a service, with Node.js as your back-end technology.

HyperFormula comes with a huge library of 389 built-in functions grouped into categories:

  • Array manipulation
  • Date and time
  • Engineering
  • Financial
  • Information
  • Logical
  • Lookup and reference
  • Math and trigonometry
  • Matrix functions
  • Operator
  • Statistical
  • Text

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
  • Spreadsheets
  • 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
  • Works with popular JavaScript frameworks
  • Written in TypeScript and extensively tested
  • Function syntax compatible with Excel and Google Sheets
  • Double-licensed: GPL/Commercial
  • Actively maintained and supported by the Handsontable (opens new window) team

# Resources

This documentation is licensed under CC BY 4.0 (opens new window).