Skip to content

v0.0.5 — Co-edit fidelity pass, charts, pivots, autosave

Choose a tag to compare

View all tags
@schnsrw schnsrw released this 22 May 20:40
· 198 commits to main since this release
v0.0.5
f39c49f

What's new in v0.0.5

Co-editing fidelity pass

All major mutation types now sync cross-peer in real time:

  • Conditional formatting — rules propagate to all peers immediately
  • Data validation — validation rules sync across the room
  • Drawings — shape inserts, moves, and resizes replicate to peers
  • Workbook/worksheet metadata — tab colors, zoom levels, frozen panes, and sheet visibility all sync cross-peer

Co-edit UX improvements

  • View-only enforcement at the engine layer — view-only joiners are locked out in Univer itself, not just in the UI
  • Session-history side panel — per-room op log with timestamps; any peer can review or revert changes
  • Divergence detector — amber "Out of sync" pill appears when state vectors diverge between peers
  • "Waiting to reconnect" banner — shown on WebSocket drop with faster offline detection
  • Improved live-edit ghost — smoother character-by-character preview with instant selection sync
  • Cursor improvements — peer cursors correctly track scroll in frozen panes and scale with canvas zoom
  • Tab strip live refresh — the sheet tab bar updates immediately when a peer adds, renames, or removes a sheet
  • Share/join hardening — fixed password gate race, owner-empty room crash, and duplicate unit ID crash on fast rejoin

Charts (P1–P5b — complete)

  • Insert dialog with range picker
  • 8 chart types: Column, Bar, Line, Area, Pie, Scatter + Stacked and 100% variants
  • Drag-to-move, resize handles, right-click menu, delete
  • Format Chart Area dialog (title, legend, axes, palette, gridlines, data labels)
  • Co-edit sync via a dedicated Yjs map
  • Chart PNGs embedded in exported .xlsx — charts are visible when the file is opened in Excel

Pivot tables (P0)

  • Insert → PivotTable — pick a source range, choose row/column fields and a value aggregate
  • Results written as cell values into a new sheet area

ODS fidelity

  • Styles, cell dimensions, freeze panes, hyperlinks, comments, and defined names all round-trip through ODS correctly

Autosave

  • Workbook state is snapshotted to IndexedDB after every edit
  • A restore banner appears on reload if an unsaved session is found

Excel keyboard shortcuts

30+ additional bindings: Ctrl+1 (Format Cells), Shift+F8 (Add to Selection), number-format shortcuts, hide/unhide, AutoFilter, AutoSum, Alt+F1 (chart), F9 (recalculate), Ctrl+W (close), border combos, and more.

xlsx round-trip

  • Defined names (named ranges) round-trip correctly through xlsx import/export

Test coverage

337 Playwright e2e tests across 79 files (up from 141) — new suites cover CF sync, DV sync, drawings sync, workbook metadata sync, cursor math in frozen panes, view-only gating, divergence detection, and ODS fidelity.

Upgrading

docker pull schnsrw/casual-sheets:0.0.5
# or: docker pull schnsrw/casual-sheets:latest

No breaking changes to the API surface or room protocol.

Assets 2
Loading