This release adds 3 notable features for engineering teams evaluating rollout.
✓ No known CVEs patched in this version
Topics
+14 more
ReleasePort's take
Light signalLibraries v0.42.0 publishes agent-first workbook APIs with structured planning and formula inputs, plus 16 Excel compatibility fixes for table references, spill caching, and structural moves. Substantial release enabling autonomous workbook automation.
Why it matters: Agent planning APIs unlock autonomous workbook operations; Excel bugfixes improve round-trip fidelity for complex sheets. Test agent workflows and Excel import/export in dev before deploying workbook automation.
Summary
AI summaryLibraries v0.42.0 updates workbook, excel-import, headless, spill handling, and internal runtimes.
Changes in this release
| Type | Severity | Summary | CVE |
|---|---|---|---|
| Feature | Medium |
Publish agent-first workbook API enabling autonomous planning. Publish agent-first workbook API enabling autonomous planning. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Add structured agent planning with formula inputs. Add structured agent planning with formula inputs. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Expose formula inputs and resolved references in agent plans. Expose formula inputs and resolved references in agent plans. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Describe agent action plans and verify entire workbook models. Describe agent action plans and verify entire workbook models. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Describe planning failures and runtime requirements for workbooks. Describe planning failures and runtime requirements for workbooks. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Support custom checks and track custom check references. Support custom checks and track custom check references. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Add readback check expectations and validate agent contracts. Add readback check expectations and validate agent contracts. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Execute workbook action plans and row selectors. Execute workbook action plans and row selectors. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Import Excel data tables and one-variable data tables. Import Excel data tables and one-variable data tables. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Materialize cached external ranges backed by hidden ranges. Materialize cached external ranges backed by hidden ranges. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Describe run results and action inputs for workbooks. Describe run results and action inputs for workbooks. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Stabilize run error codes and harden agent workbook intent. Stabilize run error codes and harden agent workbook intent. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Scope agent model phases and prove runtime handoff materialization. Scope agent model phases and prove runtime handoff materialization. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Feature | Medium |
Preserve Excel pivot semantics in pivot operations. Preserve Excel pivot semantics in pivot operations. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Preserve dynamic array spill caches in Excel export. Preserve dynamic array spill caches in Excel export. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Match Excel structural move semantics and table references. Match Excel structural move semantics and table references. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Match Excel table header renames and rewrite deleted table names. Match Excel table header renames and rewrite deleted table names. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Match Excel implicit intersection errors in formulas. Match Excel implicit intersection errors in formulas. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Rewrite renamed table names and canonicalize headers like Excel. Rewrite renamed table names and canonicalize headers like Excel. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Preserve spaced table references and escape structured headers. Preserve spaced table references and escape structured headers. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Scalarize standalone INDEX and OFFSET references like Excel. Scalarize standalone INDEX and OFFSET references like Excel. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Support CHOOSE virtual table spills in headless operations. Support CHOOSE virtual table spills in headless operations. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Encode spill references and preserve implicit intersections for Excel. Encode spill references and preserve implicit intersections for Excel. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Read desktop Excel spill errors and preserve dynamic arrays. Read desktop Excel spill errors and preserve dynamic arrays. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Rematerialize structural spill edits and rebind moved spill refs. Rematerialize structural spill edits and rebind moved spill refs. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Match Excel blocked child edits and preserve calculated column formulas. Match Excel blocked child edits and preserve calculated column formulas. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Preserve deleted refs as ref errors and rebind moved spill references. Preserve deleted refs as ref errors and rebind moved spill references. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Honor aggregate options and preserve native metadata. Honor aggregate options and preserve native metadata. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Distinguish row selector refs and retarget native metadata. Distinguish row selector refs and retarget native metadata. Source: llm_adapter@2026-05-21 Confidence: high |
— |
| Bugfix | Medium |
Gate workflow applies on mutation proof and fail unverified checks. Gate workflow applies on mutation proof and fail unverified checks. Source: llm_adapter@2026-05-21 Confidence: high |
— |
Full changelog
Libraries v0.42.0
- Release type: minor
- Previous libraries tag: libraries-v0.40.42
- Manual override: yes
Features
- feat(workbook): publish agent-first workbook API (e2fc16ed)
- feat(workbook): add structured agent planning (8f14305b)
- feat(workbook): expose formula inputs in plans (b04ab9ab)
- feat(workbook): expose resolved refs in plans (51fcfc41)
- feat(workbook): describe agent action plans (3f3cafe6)
- feat(workbook): describe planning failures (fb4eda3b)
- feat(workbook): verify action plans (4313167a)
- feat(workbook): verify entire models (41be866d)
- feat(workbook): expose simple find helpers (dfb05d8a)
- feat(workbook): expose simple check helpers (8f1190a7)
- feat(workbook): describe model manifests (7eaebafe)
- feat(workbook): support custom checks (6505a3c5)
- feat(workbook): track custom check refs (4fa18c6c)
- feat(workbook): compile number format actions (ab2e00ef)
- feat(workbook): allow guarded low-level ops (acd4492b)
- feat(workbook): declare raw formula inputs (0eb46af3)
- feat(workbook): add parameterized action input (27c2fdce)
- feat(workbook): add readback check expectations (ce1613fa)
- feat(workbook): add generic run readback receipts (8fb77566)
- feat(workbook): add generic check verifier hook (0d0e225e)
- feat(core): execute workbook action plans (b18019df)
- feat(excel-import): import Excel data tables (e658ca15)
- feat(excel-import): import one-variable data tables (4bd97433)
- feat(workbook): execute row selectors (733ba978)
- feat(workbook): describe runtime requirements (7d0d525a)
- feat(excel-import): materialize cached external ranges (2bf89130)
- feat(excel-import): back external caches with hidden ranges (b3f8d7f8)
- feat(workbook): describe run results (02b4aacb)
- feat(workbook): harden agent workbook intent (486e6851)
- feat(workbook): scope agent model phases (14351c2f)
- feat(workbook): describe action inputs (42951a13)
- feat(workbook): stabilize run error codes (e96bf90c)
- feat(workbook): prove runtime handoff materialization (7778726c)
- feat(workbook): validate agent readback contracts (c35b935e)
- feat(pivots): preserve Excel pivot semantics (7c141a24)
Fixes
- perf(excel-import): finalize simple sheets earlier (c8c573cd)
- fix(excel-export): preserve dynamic array spill caches (7e7ef8d6)
- perf(excel-import): reuse streamed zip read buffers (e553d848)
- perf(headless): bind fresh direct scalar formulas directly (45f1d9e7)
- perf(excel-import): lazy materialize medium sheets (49e98655)
- fix(headless): match Excel structural move semantics (53a6552d)
- fix(excel-import): preserve reusable zip byte reads (92b675aa)
- fix(workbook): distinguish row selector refs (b0ec8d69)
- fix(workbook): finish package rename after rebase (1819bd40)
- fix(headless): match Excel table structural refs (51a49667)
- perf(excel-import): finalize unstyled sheets before styles (5b50b1b7)
- fix(ci): build renamed workbook package (36e0bf6d)
- fix(headless): rewrite deleted table refs like Excel (e05bf105)
- perf(core): restore mixed runtime family runs (df933ce9)
- fix(corpus): slim memory gate worker (c5e168f3)
- fix(headless): match Excel table header renames (e904bc7b)
- perf(excel-import): lower large xlsx verifier rss (02c71a22)
- perf(excel-import): unblock simple sheets with artifact peers (0d13bd2e)
- fix(headless): rewrite deleted table names like Excel (21ebf354)
- fix(headless): rewrite renamed table names like Excel (5f4794de)
- perf(excel-import): coalesce streamed axis metadata (895b106d)
- fix(headless): canonicalize table headers like Excel (82b9375d)
- perf(excel-import): drain no-op styled sheet arenas (e535bb6c)
- perf(core): route formula literal batches earlier (14576712)
- perf(excel-import): intern streamed metadata in place (7b69df5b)
- fix(headless): preserve spaced table references like Excel (882c118e)
- perf(core): index criteria aggregate range edges (6cbb97ae)
- fix(excel): escape structured table headers (3251a9b8)
- fix(workbook): clear type-aware lint blockers (cd4e52da)
- fix(headless): scalarize standalone INDEX references like Excel (a03ba0de)
- perf(excel-import): reuse stored zip entry buffers (14956861)
- perf(excel-import): combine streamed style artifact parsing (fe10b931)
- fix(headless): scalarize standalone OFFSET references like Excel (a0260c6a)
- perf(excel-import): shrink sparse dimension preallocation (15aeafc9)
- fix(headless): support CHOOSE virtual table spills (a0b6db1d)
- perf(excel-import): spool large public source bytes (9d941257)
- fix(excel-import): encode spill references for desktop excel (cf2b6148)
- fix(excel-import): preserve single implicit intersections (35cb7208)
- perf(excel-import): lazy load sheetjs fallback (e743b6c9)
- fix(grid): refresh visible tile interest and style invalidations (a9befb54)
- fix(excel-oracle): read desktop excel spill errors (55e18e06)
- fix(core): expose default package export (8d15060a)
- perf(excel-import): drop import buffers before scanner load (6637f3db)
- fix(package): expose default runtime exports (fb252a93)
- perf(excel-import): lazy load byte-source scanner modules (bbde0a9d)
- fix(formula): match Excel implicit intersection errors (d61d3180)
- perf(excel-import): cap dimension arena preallocation (21c0f9be)
- perf(excel-import): intern resolved metadata strings (f253215a)
- perf(excel-import): detach lazy sheet cells from arena (f9c05822)
- perf(headless): tune fresh aggregate native threshold (5416ff5d)
- fix(formula): honor aggregate options (d1e0da30)
- fix(workbook): gate workflow applies on mutation proof (313bedbf)
- perf(excel-import): trim formula scan storage (78a2b168)
- fix(workbook): fail unverified checks (11e4816c)
- perf(headless): fast path compact numeric changes (84cf58fa)
- perf(excel-import): transfer detached lazy pools (c0c3bda4)
- fix(spill): preserve one-cell dynamic arrays (aece2475)
- perf(core): shortcut single aggregate owner lookup (45000053)
- fix(spill): match Excel blocked child edits (a4776ff8)
- perf(excel-import): reduce formatted cell materialization memory (42c13802)
- fix(spill): rematerialize structural spill edits (3a800128)
- perf(core): keep small aggregate appends numeric (b84ec201)
- fix(spill): rebind moved spill refs (d6ffbb2f)
- perf(excel-import): finalize spooled sheets earlier (e1b782f3)
- fix(names): preserve deleted refs as ref errors (1440d7a0)
- perf(excel-import): reduce inline string import RSS (cb7cbe12)
- fix(data-table): retarget native metadata (0b16a0a0)
- perf(core): bulk-bind fresh direct scalar runs (15cd6c27)
- perf(excel-import): retain shared strings for lazy sheets (bddb0593)
- fix(array-formulas): preserve native metadata (b9c40823)
- perf(excel-import): keep sparse string ids during import (6f9d1fdc)
- fix(release): align WorkPaper MCP metadata version (45cf4c16)
- fix(tables): preserve calculated column formulas (086fb131)
- perf(excel-import): reduce real xlsx import memory (0491e484)
- perf(headless): pass compact aggregate matrix plans (67040529)
- fix(release): align workpaper MCP metadata version (1ba7ffaf)
Internal runtime changes
- chore(release): runtime packages v0.40.43 (4c021baa)
- docs(agent): align WorkPaper MCP discovery (f9934bbd)
- refactor(core): split live effect runner (3fe3b47c)
- docs(agent): publish workpaper mcp metadata (cb44b298)
- docs(growth): surface n8n formula readback path (62351045)
- chore(bench): require 200-sample competitive evidence (3326c11e)
- refactor(formula): split workbook reference calls (06a97af8)
- chore(release): runtime packages v0.41.0 (2d56cc9c)
- chore(release): runtime packages v0.42.0 (aac1e61a)
Weekly OSS security release digest.
The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.
No spam, unsubscribe anytime.
Share this release
About Bilig
All releases →Related context
Related tools
Beta — feedback welcome: [email protected]