Skip to content

Sheetwrite v0.6.1

Search documentation

Home Docs Releases Showcases llms.txt

NewOct 30, 2026Sheetwrite 0.6.1Faster data-grid edits, paged scrolling, text lookups and XLSX rejects.Read the release notes →

Overview

Getting startedNew

Overview Installation First grid Choose an engineNew Upgrade to 0.6.0New

Frameworks

Vanilla React Vue Svelte Adapter lifecycle

ConceptsUpdated

Overview Runtime ownership Calculation engineUpdated Documents and operations Error handling

FeaturesNew

GridNew

Overview Options and presentation Toolbar and ribbonNew Selection and keyboard Editing and clipboardUpdated Custom editors Resize, merge and fill Context menu Search Status barNew Touch Grid methods

FormattingUpdated

Overview Styles and themes Fonts and alignmentUpdated Number formats Conditional formats

Data

Overview Data operations Datasources Host-owned rows Validation, protection and notes Persistence

FormulasNew

Overview Authoring and references Operators and reference operatorsNew Dynamic arrays and spills OFFSET and INDIRECTNew Volatile functionsNew Iterative calculationNew Lookup, criteria and financial rules Analysis formulas (full engine)Custom functions

AnalysisNew

Overview Pivot tablesNew ChartsNew

Collaboration Worker rendering Accessibility

Import and exportNew

Overview XLSX import XLSX export CSV and TSV Kept parts and round tripsNew Large files and streamingUpdated LibreOffice compatibilityNew

TutorialsNew

Overview Excel in JavaScriptNew Excel in ReactNew Excel in VueNew Excel in SvelteNew Excel in Node.jsNew Spreadsheet app with the ribbonNew

Performance

Overview

Overview Render Data engine Core write path Formula engine XLSX codec Delivery size Memory Release comparison Benchmark protocol

Reference

Formula functions

Overview Dynamic array Date and time Financial Information and error Logical and control flow Lookup and reference Math and trigonometry Statistical Text Database

Excel function coverage Document operations Events Compatibility limits Compatibility results Package entry points Moved pages

API packages

All entry points @sheetwrite/charts @sheetwrite/core @sheetwrite/formulas @sheetwrite/react @sheetwrite/svelte @sheetwrite/vue @sheetwrite/wasm @sheetwrite/xlsx

Release notes

All releases 0.6.1 · Oct 30, 2026 0.6.0 · Oct 30, 2026 0.5.4 · Oct 24, 2026 0.5.3 · Oct 24, 2026 0.5.2 · Oct 23, 2026 0.5.1 · Oct 18, 2026 0.5.0 · Oct 17, 2026

Explore Sheetwrite

Home Showcases GitHub

For LLMs

llms.txt llms-full.txt

Documentation
API packages
All entry points
@sheetwrite/core/functions

@sheetwrite/core/functions

API reference for @sheetwrite/core/functions.

On this page

Loading documentation…

Sheetwrite is MIT licensed.Report a documentation issue

Documentation

NewOct 30, 2026Sheetwrite 0.6.1Faster data-grid edits, paged scrolling, text lookups and XLSX rejects.Read the release notes →

Overview

Getting startedNew

Overview Installation First grid Choose an engineNew Upgrade to 0.6.0New

Frameworks

Vanilla React Vue Svelte Adapter lifecycle

ConceptsUpdated

Overview Runtime ownership Calculation engineUpdated Documents and operations Error handling

FeaturesNew

GridNew

Overview Options and presentation Toolbar and ribbonNew Selection and keyboard Editing and clipboardUpdated Custom editors Resize, merge and fill Context menu Search Status barNew Touch Grid methods

FormattingUpdated

Overview Styles and themes Fonts and alignmentUpdated Number formats Conditional formats

Data

Overview Data operations Datasources Host-owned rows Validation, protection and notes Persistence

FormulasNew

Overview Authoring and references Operators and reference operatorsNew Dynamic arrays and spills OFFSET and INDIRECTNew Volatile functionsNew Iterative calculationNew Lookup, criteria and financial rules Analysis formulas (full engine)Custom functions

AnalysisNew

Overview Pivot tablesNew ChartsNew

Collaboration Worker rendering Accessibility

Import and exportNew

Overview XLSX import XLSX export CSV and TSV Kept parts and round tripsNew Large files and streamingUpdated LibreOffice compatibilityNew

TutorialsNew

Overview Excel in JavaScriptNew Excel in ReactNew Excel in VueNew Excel in SvelteNew Excel in Node.jsNew Spreadsheet app with the ribbonNew

Performance

Overview

Overview Render Data engine Core write path Formula engine XLSX codec Delivery size Memory Release comparison Benchmark protocol

Reference

Formula functions

Overview Dynamic array Date and time Financial Information and error Logical and control flow Lookup and reference Math and trigonometry Statistical Text Database

Excel function coverage Document operations Events Compatibility limits Compatibility results Package entry points Moved pages

API packages

All entry points @sheetwrite/charts @sheetwrite/core @sheetwrite/formulas @sheetwrite/react @sheetwrite/svelte @sheetwrite/vue @sheetwrite/wasm @sheetwrite/xlsx

Release notes

All releases 0.6.1 · Oct 30, 2026 0.6.0 · Oct 30, 2026 0.5.4 · Oct 24, 2026 0.5.3 · Oct 24, 2026 0.5.2 · Oct 23, 2026 0.5.1 · Oct 18, 2026 0.5.0 · Oct 17, 2026

Explore Sheetwrite

Home Showcases GitHub

For LLMs

llms.txt llms-full.txt

supported

Supported public entry point. Import this entry point as @sheetwrite/core/functions.

Declaration target: ./dist/functions.d.ts
Exports: 8

Source entry: packages/core/src/functions.ts

Exported symbols

Functions 3

FlistFunctionsMetadata of every function that formulas in store can call: the built-in functions of the active engine, then the host functions of store in registration order. FregisterFunctionRegisters a synchronous JavaScript function that formulas in store can call, then recalculates every formula. FunregisterFunctionRemoves a host function from store.

Interfaces 2

IFormulaArgumentMetadataArgument documentation used by built-in and host functions. IFormulaFunctionMetadataOne metadata format for built-in and host functions.

Types 3

TFormulaArgumentRanges use row-major nested arrays. TFormulaFunctionA synchronous host function. TFormulaScalarA scalar passed to or returned from a synchronous host formula function.