github audreyt/ethercalc 0.20260423.0
0.20260423.0 — formula-preserving round-trip

7 hours ago

Since 0.20260422.3:

Export / import — formulas now round-trip

  • xlsx/ods/fods export walks sheet.cells directly into SheetJS {t, v, f, z, c} cell objects. Formulas, number formats, merged ranges, and cell comments all survive the export — reopening the file in Excel / LibreOffice shows live formulas rather than baked values. Previously the pipeline routed through exportCSV and flattened everything to strings. (54c191e)
  • xlsx/ods import decodes via SheetJS and emits SocialCalc set A1 formula SUM(A1:A2) commands, so formulas (including Excel drag-fill formulas, see #305) come in as live formulas. (ecb18d3)
  • Multi-sheet export routes (GET /_/=:room/xlsx, .ods, .fods) — previously 501 stubs in the TS rewrite — now walk the TOC row-by-row, fetch each sub-room via /_do/sheet-data, and assemble one workbook with formula fidelity per sub-sheet. (ecb18d3)
  • Cross-sheet formula resolution ('other'!A1). findCrossSheetRefs enumerates sibling refs; #fetchSibling pulls each sibling's snapshot via /_do/snapshot; addSiblingSheet populates SocialCalc's formula cache; recalc re-evaluates so stored snapshots carry live values instead of #NAME?. (ecb18d3)

Closes long-standing issues#55, #234, #289, #305, #573, #717, #762, #783, #795.

Client

CI / docs

  • Bump GitHub Actions to latest node / checkout / cache versions (#821, c7af13e).
  • Misc docs + spelling fixes.

Install

npm install -g ethercalc@0.20260423.0

Don't miss a new ethercalc release

NewReleases is sending notifications on new releases.