Skip to content
SumOfficeSumOfficeSumOffice

Diagnostics

Typical first-run problems and how to pin them down.

If the first run isn’t working, find your case in the table: next to it are the cause and what to check.

Symptom Cause Action
The program stays silent on startup The wrong path, or the file doesn’t run Confirm the file is at the given path and runs manually
The request went out, there’s no response, the process is alive The core asked a counter-question and is waiting for an answer — this happens with operations that need the network Read the line it sent: it has a kind field. Answer with a line carrying the same id. The core has no timeout of its own — the deadlineMs in its line is addressed to you — so it will wait indefinitely without an answer. Closing the input stream ends the wait with a refusal, not a hang (how the conversation works)
Opening returned ok=false — for an unparseable address, invalid-source-uri An error in the file address, format, or access permissions Pass the full file address, from the root — in Node.js, pathToFileURL from the node:url module gives you that; read code and message from the response
A stale revision — apply-cell-edits-stale-revision A different request already changed the workbook Request a fresh projection with the new revision number and deliberately retry the operation
The operation goes to the wrong sheet — unknown-sheet-key A visible name was passed instead of the sheet key Use activeSheet.path from the response to open
The saved file didn’t appear — invalid-destination-uri An invalid destination address, or no write permission Check the absolute URI and the folder
subsetId not found — unknown-subset-session The core process was restarted and lost its open subsets Call open_workbook_subset again
A formula shows a stale value — the cached-formula-preview warning The workbook was just opened in a new process This is the value saved in the file; to get a fresh one, trigger a recalculation. The core already told you this: check warnings in the response to open
  • the SumSheet version and the platform;

  • the sha512 checksum of the installer file — the one checked during installation;

  • the operation name (operation) and the refusal code (code);

  • the smallest anonymized XLSX workbook that reproduces it;

  • one JSON request line and one JSON response line;

  • whether it reproduces after a new process.

Send what you’ve gathered to hello@sumoffice.com — that’s enough to start triage without a follow-up email asking for what’s missing.

The response contents on a refusal — on the How the API session works page.

Documentation assistant

Answers are assembled from the documentation and may be inaccurate — check the sources.