Changelog

v15.5.0 (2026-03-05)

Features

• Cell notes CRUD via NotesManager (workbook.notes): add, get, getByCell, update, delete

Bug fixes

• AND/OR/XOR/NOT evaluation with strings and other edge-case arguments, matching Excel and Google Sheets behavior
• TEXTJOIN and JOIN now apply cell display formats (e.g. date formats) in Google mode

Interface changes

These are technically breaking, but very minor and in very recent features, so did not demand a major-version bump.

• CommentsManager now throws SheetNotFoundError (instead of plain Error) for missing sheets, with a differently worded message.
• WorkSheet.notes type changed to Note[] (no longer possibly undefined)

Dependencies

• Update @grid-is/jsf2xlsx to ^1.3.2, updating default column width and fixing extraneous activeTab="0" attributes in workbookView elements.

v15.4.0 (2026-03-02)

Features

• Respect ‘autoNoTables’ from XLSX file, plus deferDataTables option for manual control
  • And more generally, mark any formula cells to be deferred in recalculation
• Threaded comments CRUD via CommentsManager (workbook.comments)

Bug fixes

• MATCH returned #N/A instead of #REF! in Excel missing-sheet edge case
• toJsf export expanded external workbooks to nonexistent cells if referenced in ranges
• Error-like strings (e.g. #REF!) not treated as error values when loading styled cells from CSF
• Default (named) styles were not preserved in toJsf export

Performance

• Much faster worst-case describeWorkbook (label-detection) performance

Documentation

• Update quickstart to use Model.fromXlsxFile instead of manual xlsx-convert

v15.3.1 (2026-02-23)

Bug fixes

• Preserve formula type (array or not) when result is 1x1, and classify correctly on edit
• Serialization did not preserve views, annotations, rows, and externals
• Remove Node.js util imports so consumers need not polyfill for browser compatibility

Documentation

• Add changelog to public docs

v15.3.0 (2026-02-19)

Features

• Excel data tables
• Function SORTN
• getViews method in WorkSheet and Workbook
• Google Sheets FLATTEN function
• Merge/unmerge cells

Bug fixes

• Make HYPERLINK()-derived hyperlinks ephemeral
• Preserve external workbooks in JSF roundtrip
• Update comment and note cell refs on move, insert, and delete
• Wrap fs/promises imports in try-catch to avoid bundler errors

Performance

• Speed up describeWorkbook by pre-filtering parseDate calls

Documentation

• Pare down public API, marking stuff @deprecated and/or @internal
• Use code blocks in Typedoc-generated docs

v15.2.0 (2026-02-10)

Features

• Support JSF cell notes and threaded comments

Bug fixes

• describeWorkbook crash on cross-workbook ref to formula cell
• Support QUERY with COUNT(DISTINCT value)

v15.1.1 (2026-02-10)

Bug fixes

• Missed dynamic dependencies in lambda-calling functions at init time
• Preserve cells with explicit empty styles through round-trip
• Strip numberFormatFromFormula from exported styles in toJSF

v15.1.0 (2026-02-04)

Features

• toJsf
• toXlsx
• Add fromXlsx methods for direct XLSX loading
• Native QUERY without pg-mem (calling it “feat” because it supports a lot that the old one did not)
• Output style indexes on rows and columns

Bug fixes

• Real workbooks override external workbooks with same name
• Fix invariant error on insert after row is deleted
• Export ft property in toCSF for array formulas
• Init recalc was skipped if !recalcVolatiles && !recalcErrors
• Load XLSX files in Excel mode by default
• Respect recalcVolatiles option during initial recalculation
• Preserve text strings that look like errors in JSF loading
• ERROR.TYPE did not support modern error codes
• describeWorkbook throws on JSF workbook with externals
• Upgrade xlsx-convert to 3.6.4 for bugfixes
• Fix handlerRels to work with absolute paths
• Fix external refs order
• The r property on cells is optional

Breaking changes

• Remove Flags module and flags export

v15.0.0 (2026-01-14)

Features

• Public Model.attachWorkbook, and document addWorkbook as just a wrapper
• Export StyleManager
• Export CellData type
• Add support for JSF workbook/worksheet view props
• Specific Error subclass for invalid reference strings
• Add missing detail messages on #CALC! errors

Bug fixes

• Google-mode early-date date function discrepancies
• Matrix.expand makes fully-populated matrices, causing performance disasters
• Nonresolving name in LOOKUP vector arg borks reference analysis
• Propagate markDirty to all dependents of spill ranges
• Blank spill anchor missing in Cells.getCells
• Don’t propagate recalc from unchanged spill matrix
• numberFormatFromFormula propagation
• SUMIFS etc. wrong for Matrix with defaulted regions
• Incorrect swap in Brent root-finding setup
• QUERY with now() not treated as volatile if no dependencies
• GSDV blocker in extended range should not block other columns
• Evaluate array expressions with mismatched row widths as #VALUE!
• Fix default column-width units discrepancy
• Fix Table serialization property name mismatch
• Fix serialization invariant violation
• Fix errors in toCSF export structures
• Fix GSDV spill range inference: use offset not absolute row
• Fix regression in evaluateExpression
• Preserve CSF style array when loading workbooks

Performance

• Add vertexId to Cell and DefinedName
• Non-volatile OFFSET and INDIRECT and ANCHORARRAY with dynamic dependencies

Breaking changes

• CSF type should have filename, not name
• Change NameReference.width and .height to be undefined, not throw

Dependencies

• Update fx to 5.0
• Upgrade Waspiary to 1.10.0 to permit R and C names

v15.0.0-rc3 (2026-01-08)

Features

• Add missing detail messages on #CALC! errors
• Export CellData type
• Specific Error subclass for invalid reference strings
• Add support for JSF workbook/worksheet view props
• Preserve CSF style array when loading workbooks

Bug fixes

• GSDV blocker in extended range should not block other columns
• numberFormatFromFormula propagation
• SUMIFS etc. wrong for Matrix with defaulted regions
• Incorrect swap in Brent root-finding setup
• QUERY with now() not treated as volatile if no dependencies
• Evaluate array expressions with mismatched row widths as #VALUE!
• Fix GSDV spill range inference: use offset not absolute row
• Fix Table serialization property name mismatch
• Fix serialization invariant violation
• Fix errors in toCSF export structures

v15.0.0-rc2 (2025-12-10)

Bug fixes

• Blank spill anchor missing in Cells.getCells
• Don’t propagate recalc from unchanged spill matrix
• Fix regression in evaluateExpression
• CSF type should have filename, not name

Performance

• Non-volatile OFFSET and INDIRECT and ANCHORARRAY with dynamic dependencies

v15.0.0-rc1 (2025-12-08)

Features

• Public Model.attachWorkbook, and document addWorkbook as just a wrapper
• Export StyleManager

Bug fixes

• Google-mode early-date date function discrepancies
• Matrix.expand makes fully-populated matrices, causing performance disasters
• Non-resolving name in LOOKUP vector arg borks reference analysis
• Propagate markDirty to all dependents of spill ranges
• Fix default column-width units discrepancy

Performance

• Add vertexId to Cell and DefinedName

Breaking changes

• Change NameReference.width and .height to be undefined, not throw

Dependencies

• Update fx to 5.0

v14.13.0 (2025-11-19)

Features

• Read JSF directly

Bug fixes

• Bugs in row and column deletion and moves
• Support R1C1 syntax in INDIRECT
• Handle changed serialization
• Replace ERROR_SPILL 'foo' placeholder with proper detail message
• Serialize model with lambdas in arrays
• VLOOKUP/HLOOKUP can return non-up-to-date value
• Direct call to UPLUS fails with internal error
• Recalculate affected formulas if clearGsdv clears cells

Breaking changes

• Remove reset value from DefinedName and CellInterface

Dependencies

• Switch to @jsfkit/types for JSF type definitions

Other

• Install from, and publish to, npmjs.com registry

v14.12.0 (2025-10-17)

Breaking changes

• Make FormulaError and Reference fully immutable

Features

• Store origin cell in FormulaError
• Add and improve error-value detail messages
• Add detail messages to #SPILL! errors

Bug fixes

• Make Cell.isBlank() closer to what its name implies
• Minor bugs in reference intersection and add a test
• Rename and deprecate Cell methods

Documentation

• Deploy public API docs to GitHub Pages site
• Remove internal stuff from docs
• Mention case-insensitivity in name parameters

v14.11.0 (2025-10-15)

Features

• Recalculate error-valued cells at init time
• Remove defined name

Bug fixes

• Wrong spill-operator result for blocked spill
• QUERY coerces dates to string by local timezone
• Support structured references in INDIRECT
• IF result should not be marked dynamic
• Make apiary bin work again

v14.10.1 (2025-10-01)

Features

• Allow disabling common-subexpression extraction

Bug fixes

• Fix 1904 epoch bug when converting JSF to CSF

v14.10.0 (2025-09-25)

Features

• Export FormulaSyntaxError and EvaluationError
• Add Model.empty() convenience method
• Export recalculation option symbols

Bug fixes

• ADDRESS with invalid coordinates yields wrong results or throws exception
• Use source number format in TO_TEXT
• Set number format in TO_* functions
• XLOOKUP third argument wrongly forced up-to-date
• ROW etc. fail to update when name ref updates
• False-pos circdep in SUMIF/AVERAGEIF on target range extension
• Workbook.iterFormulaCells had a bug and a redundant sibling
• Update JSF support

Documentation

• Add a quick start guide
• Add Starlight-based documentation system
• Add tutorial for creating a spreadsheet from scratch
• Document some methods on the Model class

v14.9.5 (2025-09-01)

Features

• Add support for loading and converting JSF format

v14.9.3 (2025-08-12)

Bug fixes

• CONVERT failed to handle reference value argument

Dependencies

• Bump fx from 4.11.2 to 4.12.0 [bot]
• Bump msgpackr from 1.11.4 to 1.11.5 [bot]

v14.9.2 (2025-07-23)

Bug fixes

• Fix defined names causing slow iterative calculation

v14.9.1 (2025-07-22)

Version revoked due to incorrect fix.

v14.9.0 (2025-06-27)

• Detect parent labels

v14.8.7 (2025-06-26)

Bug fixes

• Label sequence confusion from sparse values at island top/left

Dependencies

• Bump component-emitter from 1.3.0 to 2.0.0
• Upgrade pg-mem to 2.6.15

v14.8.6 (2025-06-12)

Bug fixes

• Leftmost-column data mistaken for a label sequence

v14.8.5 (2025-06-08)

Bug fixes

• Skip over gaps in mixed-type label subsequences

v14.8.4 (2025-06-08)

• Improve island-based label detection