@prefix sioc: . @prefix dc: . @prefix dcterms: . @prefix xsd: . @prefix content: . @prefix rdf: . @prefix rdfs: . a sioc:Post ; dc:title "Development" ; dcterms:identifier 152398 ; dc:modified "2026-10-25T02:45:19Z"^^xsd:dateTime ; dc:created "2026-10-25T01:48:58Z"^^xsd:dateTime ; sioc:link ; sioc:has_creator ; sioc:has_container ; content:encoded "

Saving edits

  • The host listens to Univer’s CommandExecuted event and reacts only to mutations of this workbook: type is MUTATION, the mutation is not onlyLocal (formula calculation), and params.unitId is the workbook’s id. The cell editor is a separate internal Univer document that mutates on every keystroke; without the unit check the post was marked dirty as soon as it opened.
  • Changes are debounced (400 ms), then the edit component compares the snapshot’s JSON with the last one it saw and only then calls setAttributes( { workbook } ). WordPress’s own Save, autosave and revisions take it from there.
  • When the attribute changes from outside the grid (editor undo, a restored revision, a collaborator’s save) the grid reloads from it.

Collaboration

The block editor’s real-time collaboration syncs the whole workbook as one attribute, so two people editing different cells at the same moment overwrite each other: the last change wins for the whole workbook. Presence, title, status and terms sync normally. Cell-level co-editing needs Univer’s mutations mapped onto the editor’s Yjs document (planned).

REST API

Namespace lh/v1, base spreadsheets (filters lh_spreadsheets_rest_return_namespace, lh_spreadsheets_rest_return_rest_base). GET lists up to 50 (own only without edit_others_posts), POST creates, and GET, PUT and DELETE on /{id} read, patch and delete. Writes take title, description, status and workbook (an object); the API wraps the workbook in the block itself. Publishing without publish_posts is demoted to pending. Core’s wp/v2/spreadsheets route also exists, returning the raw block markup.

Building

Source is in src/; build/ is generated with npm install then npm run build and deployed as is (nothing is built on the server). webpack.config.js runs two builds: the block with WordPress packages as externals, and the Univer host with everything bundled. Univer is pinned to an exact version in package.json; upgrade it deliberately and retest, since its API has moved between releases.

Roadmap

  • Cell-level collaboration over the block editor’s Yjs transport.
  • A Grist-compatible API adapter.
"^^rdf:XMLLiteral ; sioc:content "Part of: LH SpreadsheetsSaving editsThe host listens to Univer’s CommandExecuted event and reacts only to mutations of this workbook: type is MUTATION, the mutation is not onlyLocal (formula calculation), and params.unitId is the workbook’s id. The cell editor is a separate internal Univer document that mutates on every keystroke; without the unit check the post was marked dirty as soon as it opened.Changes are debounced (400 ms), then the edit component compares the snapshot’s JSON with the last one it saw and only then calls setAttributes( { workbook } ). WordPress’s own Save, autosave and revisions take it from there.When the attribute changes from outside the grid (editor undo, a restored revision, a collaborator’s save) the grid reloads from it.CollaborationThe block editor’s real-time collaboration syncs the whole workbook as one attribute, so two people editing different cells at the same moment overwrite each other: the last change wins for the whole workbook. Presence, title, status and terms sync normally. Cell-level co-editing needs Univer’s mutations mapped onto the editor’s Yjs document (planned).REST APINamespace lh/v1, base spreadsheets (filters lh_spreadsheets_rest_return_namespace, lh_spreadsheets_rest_return_rest_base). GET lists up to 50 (own only without edit_others_posts), POST creates, and GET, PUT and DELETE on /{id} read, patch and delete. Writes take title, description, status and workbook (an object); the API wraps the workbook in the block itself. Publishing without publish_posts is demoted to pending. Core’s wp/v2/spreadsheets route also exists, returning the raw block markup.BuildingSource is in src/; build/ is generated with npm install then npm run build and deployed as is (nothing is built on the server). webpack.config.js runs two builds: the block with WordPress packages as externals, and the Univer host with everything bundled. Univer is pinned to an exact version in package.json; upgrade it deliberately and retest, since its API has moved between releases.RoadmapCell-level collaboration over the block editor’s Yjs transport.A Grist-compatible API adapter." ; sioc:topic . rdfs:seeAlso . rdfs:seeAlso .