# Welcome

# What is HyperFormula?

HyperFormula is an open-source calculation engine that allows you to perform Excel-like calculations in your business applications. HyperFormula 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.

It comes with a built-in library of functions grouped into different categories, such as Math and trigonometry, Engineering, Statistical, Financial, and Logical. 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 it be used 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 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
  • Works with popular JavaScript frameworks
  • Written in TypeScript and extensively tested
  • Uses GPU acceleration for better performance
  • Function syntax compatible with Excel and Google Sheets
  • Triple-licensed: AGPL/Non-commercial/Commercial
  • Actively maintained and supported by the Handsontable (opens new window) team

# Useful resources

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