8 examples of useful Excel functions in HyperFormula
Our calculation engine supports over 380 functions in 16 languages. To get a quick glimpse of what HyperFormula has to offer—read on.
Notes on Tutorials
Feature spotlight: Multi-column sorting
How multi-column sorting arrived in Handsontable 6.0.0, how the sorting mechanism works, why stability matters, and how to plug in custom compare functions.
Advanced Data Validation in Handsontable
Validation patterns for Handsontable beyond the basics: numeric data such as phone numbers, mixed values checked with regex, and cross-column rules.
Guide to Basic Data Validation
How to validate cell input in Handsontable in three steps: select the target cells, set the rules, and decide what happens to invalid entries.
Custom Keyboard Shortcuts in Handsontable
How to add custom keyboard shortcuts to Handsontable that turn text into a link, change text color, validate a cell or insert a comment.
What You Should Know About Cell Types
What a Handsontable cell type is, which nine ship with it, and how to set one per column, row, cell or merged cell, or change it from a menu.
Getting Started with Cell Renderers
What a cell renderer is in Handsontable, which renderers ship with it, and how to write a custom renderer without hurting rendering performance.
Customize Handsontable Context Menu
How to enable the Handsontable context menu, add predefined and custom items, disable entries, and what its limitations are.
4 Ways to Handle Read-only Cells
How to lock data in Handsontable with the readOnly option, applied to the whole grid, to columns, to rows or to individual cells.
Easy Ways to Sort Different Types of Data in Your App
How to sort Handsontable columns that hold currencies, heights, weights, distances and areas by writing a custom sortFunction.
Make every data point count. Turn millions of them into actionable wisdom.
Let’s make it easier.
Smoother. Faster. All Handsontable.