agentsclimarketplace
Sign in

Hyperformula

Skill handsontable/handsontable-skills/skills/hyperformula

Use this skill when the user works with HyperFormula (HF) — a headless, open-source TypeScript spreadsheet calculation engine. Use it when the user: mentions HyperFormula or HF; wants to integrate Excel-like formulas into a JS/TS app; evaluate formulas programmatically in a browser or Node.js; simulate spreadsheet or Excel calculation behavior server-side; run calculations over data parsed from XLSX files (e.g. via SheetJS) in code; build a pricing engine, financial model, or what-if analysis in code; define custom spreadsheet functions or named expressions outside of a UI context. Do NOT use this skill for: general Excel questions unrelated to HF; general Google Sheets questions; generic spreadsheet formula-syntax questions outside an HF context; formulas used inside Handsontable (use the "handsontable" skill instead).From its SKILL.md

Install
npx -y skills add handsontable/handsontable-skills --skill hyperformula

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 8 stars8 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

9.5 KB, as published. Nobody here has run it

HyperFormula

HyperFormula is a headless, open-source TypeScript spreadsheet calculation engine for embedding spreadsheet logic in any JavaScript/TypeScript application (browser or Node.js). ~420 built-in functions, dependency graph, undo/redo, i18n (18 languages). Dual-licensed: GPLv3 or commercial.

Where to go next

Task-oriented references in references/ (open the one that matches what the user is doing):

  • getting-started.md — how to install, create an instance (buildFromArray / buildFromSheets / buildEmpty), and work with cell addresses. Open this for onboarding questions and first-run errors.
  • api-quickref.md — runnable examples for CRUD, rows/columns, sheets, exporting data, batching, named expressions, events, undo/redo, clipboard. Open this when implementing or debugging HF API calls.
  • custom-functions.md — extending HyperFormula via FunctionPlugin: minimal plugin, argument types, volatile functions, range arguments, returning arrays, error handling, aliases, localized names. Open this when adding or debugging custom spreadsheet functions.
  • configuration.md — ConfigParams options, Excel-compatibility preset, Google-Sheets preset, and config-related pitfalls (separator collisions, Node ICU, precisionRounding change in v3). Open this when tuning behavior or diagnosing locale issues.
  • vue3.md — Vue 3 integration: markRaw requirement, Composition API, Pinia/Vuex stores, destroy() on unmount. Open this when embedding HF in a Vue 3 app.
  • error-handling.md — inspecting CellError, ErrorType enum, getCellValueDetailedType, common error causes (#NAME?, #CYCLE!, #REF!, …). Open this when a cell returns an error or you need to branch on result type.
  • general-pitfalls.md — cross-cutting gotchas: destroy() lifecycle, forcing literal strings, Excel-parity caveats, hard limits. Open this when results look wrong or memory grows unboundedly.

Below this section is the Documentation map — the canonical directory of links to the official HyperFormula docs. Use it when pointing the user to authoritative material.

Documentation map

All links resolve to hyperformula.handsontable.com unless noted.

Introduction

Overview

Getting Started

Framework Integration

Data Operations

Formulas

Internationalization

Compatibility

Advanced Topics

Upgrade & Migration

API Reference

npm

Community & Support

Last updated: 2026-08-11 · Aligned with HyperFormula 3.4.0. If the user is on a newer release, confirm API shape against the latest docs (see the Release notes link above) before relying on this file.

Keep looking

Skills are one crate of 628,971. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.