Skip to content

Sheetwrite v0.3.0 release tracker #27

Description

@chh-ay

Goal

Ship Sheetwrite v0.3.0 as a visibly complete, measurable spreadsheet, data-grid, and multi-sheet workbook release: stronger semantic and workbook behavior, broader portable formulas, faster real interactions, honest compatibility evidence, and eight production-quality interactive showcases.

Grid and framework contracts

  • Execute DOM cell renderers with bounded retained-node lifecycle and absolute ARIA indices
  • Expose generation-safe mutation, renderer fallback, datasource, and export failure callbacks across React, Vue, and Svelte
  • Add an explicit semantic data-grid mode with semantic headers and host-owned editors
  • Make wide-sheet active-cell navigation and shared presence labels remain visible and legible
  • Add a stable, framework-neutral row-model bridge
  • Publish executable onboarding and member-level API guidance

Formula and workbook behavior

  • Add standard operator precedence for exponentiation, concatenation, postfix percent, and dynamic-array spill behavior
  • Expand the portable analytical, financial, date/time, lookup, text, and array-function kernel
  • Complete worksheet create/rename/reorder/duplicate/hide/delete behavior and accessible tab UX
  • Make workbook import/export compatibility claims executable against a typed behavior matrix
  • Normalize public async failure envelopes and recovery behavior
  • Add canonical workbook tables with stable table/column IDs, structured-reference evaluation, structural rewrites, history/rebase, and native bounded OOXML table parts
  • Add host-safe HTTPS/mailto and internal hyperlinks with bounded metadata, host-owned activation, and native OOXML relationships
  • Add dependency-scoped conditional formatting with ordered precedence, stop-if-true, Worker parity, a 32-rule bound, and native OOXML subset support
  • Generate the source/provenance-checked protocol-1 compatibility test set: 2,000 formula vectors, 250 mutation sequences, and 100 workbook scenarios (2,350 total; SHA-256 bdf94c76df81ea1fa2e1bf96a557c41b21a0f11ea11ae612fcccc35157d7275a)
  • Run Sheetwrite/LibreOffice and supported cross-producer workbook round-trip chains with normalized semantic diffs and exact warnings
  • Publish protocol-backed public compatibility test set results

Scale and performance

  • Add bounded directional datasource prefetch without fabricating unloaded values
  • Replace row-scale inverse lookup objects with a packed representation
  • Separate sparse dirty edits from paged storage when the measured memory gate admits it
  • Attribute startup, scroll, ingest, edit, and persistence costs by owner before optimizing
  • Deliver measured interaction improvements on real Grid journeys, with exact before/after artifacts
  • Attempt the exact 1,000,000-row × 1,000-column logical-cell architecture gate with a dedicated 1K-column spike; keep the feature only if startup, memory, correctness, and interaction ceilings pass

Product experience and release

  • Introduce the v0.3 visual system without eager engine initialization or invented performance claims
  • Add an inspectable live engine-dataflow view using real public instrumentation
  • Overhaul the showcase hub and all eight live interactive showcases while preserving their existing behavior
  • Expose tables, hyperlinks, conditional formatting, and protocol-backed conformance evidence in the interoperability showcase with real Grid behavior
  • Converge documentation on shipped behavior and executable evidence
  • Restore every unchanged delivery-size ceiling; no ceiling was raised to absorb feature growth

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestreleaseRelease coordination and verification

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions