JSPM

ethercalc

0.20260424.0
  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • Downloads 261
  • Score
    100M100P100Q92620F
  • License CC0-1.0

Multi-User Spreadsheet Server — TypeScript rewrite (Cloudflare fullstack)

Package Exports

    This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (ethercalc) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

    Readme

    EtherCalc

    EtherCalc is a web spreadsheet for real-time collaborative editing. This branch is the TypeScript rewrite on the Cloudflare fullstack (Hono + Workers + Durable Objects + D1 + KV + R2). It deploys to Cloudflare via wrangler deploy, and self-hosts anywhere via docker compose up with no Cloudflare account required. See CLAUDE.md for the plan-of-record, full architecture, and phase status.

    Integrated with content management systems:

    Browsers tested: Safari, Chrome, Firefox.

    Install

    Via npm (requires Bun ≥ 1.1 on PATH — the CLI spawns bunx wrangler):

    npm install -g ethercalc
    ethercalc              # starts on http://localhost:8000

    Via Docker (no Bun needed on the host — the image carries it):

    git clone https://github.com/audreyt/ethercalc
    cd ethercalc
    docker compose up -d

    Both paths boot the same Miniflare-backed Worker, persist state under ./ethercalc-data/ (or /data in the container), and need no Cloudflare account.

    Self-hosting

    git clone https://github.com/audreyt/ethercalc
    cd ethercalc
    docker compose up -d

    This boots the Miniflare-backed Worker on http://localhost:8000 and persists all spreadsheet state (Durable Objects, D1, KV, R2) to ./ethercalc-data/ in the repo. No Redis, no Node runtime, no Cloudflare account.

    Environment variables

    Override defaults by exporting these before docker compose up:

    Variable Default Effect
    ETHERCALC_PORT 8000 Listening port (remaps container bind).
    ETHERCALC_HOST 0.0.0.0 Listening address.
    ETHERCALC_KEY (unset) HMAC secret; enables read-only vs. edit auth.
    ETHERCALC_CORS (unset) 1 enables permissive CORS headers.
    ETHERCALC_BASEPATH (unset) URL prefix, e.g. /ethercalc behind a proxy.
    ETHERCALC_EXPIRE (unset) Seconds of inactivity before a room is pruned.

    On Apple Silicon, Docker Desktop's virtio networking has an intermittent quirk that can make curl localhost:8000 hang even against a healthy container. If you hit it, run the worker directly (bun run --cwd packages/worker dev) or use a Linux host.

    CLI

    For non-Docker runs (local dev, systemd, etc.) use the bin/ethercalc wrapper. It accepts the legacy flag surface and forwards to wrangler dev + Miniflare env vars:

    bin/ethercalc [--key SECRET] [--cors] [--port N] [--host ADDR] \
                  [--expire SEC] [--basepath PREFIX] \
                  [--persist-to DIR]

    Run bin/ethercalc --help for the full flag table. --keyfile / --certfile are accepted for backward compatibility but currently print a warning — wrangler dev does not expose TLS. Terminate TLS at a reverse proxy (nginx/caddy/traefik).

    Deploy to Cloudflare

    cd packages/worker
    npx wrangler deploy

    Store the HMAC secret as a Worker secret:

    npx wrangler secret put ETHERCALC_KEY

    Migration from a legacy (Redis-backed) EtherCalc

    If you have a legacy Redis-backed EtherCalc and just want to upgrade:

    git clone https://github.com/audreyt/ethercalc
    cd ethercalc
    cp /path/to/your/dump.rdb ./legacy-dump.rdb    # e.g. /var/lib/redis/dump.rdb
    ./bin/migrate-legacy.sh

    One command stands up a temporary Redis loaded with your dump, builds and runs the new Worker, streams every room across, and writes a dated backup to ./backups/ethercalc-<timestamp>.tar.gz containing both the migrated state and your source dump. On success the Worker is left running on http://localhost:8000 — open any existing room by its URL to confirm.

    Requires only docker + the docker compose plugin on the host. Tested against OrbStack and Docker Desktop on macOS/arm64; Docker Engine on Linux.

    Manual (advanced)

    bin/ethercalc migrate streams a running Redis or Zedis directly into a Worker you already have up:

    bin/ethercalc migrate \
      --source redis://localhost:6379 \
      --target http://new-worker.example/ \
      --token $ETHERCALC_MIGRATE_TOKEN

    O(1)-per-room memory regardless of dump size — Redis owns the decoding. The target endpoint is gated by env.ETHERCALC_MIGRATE_TOKEN (when unset, the route returns 404). Pass --dry-run to preview without writing. --source file:///path (or bare /path) also works for on-disk legacy dumps (the Sandstorm grain fallback format).

    Development

    bun install
    bun run --cwd packages/worker dev          # wrangler dev --local
    bun run --cwd packages/worker test         # workers-pool + node tests

    See CLAUDE.md for the directory map, testing strategy (100% line/branch/function/statement coverage plus Stryker mutation gates on gated packages), and the remaining phase plan.

    REST API

    See API.md. The public HTTP surface is preserved byte-for-byte where deterministic, minus a small allow-list of sensible fixes documented in CLAUDE.md §6.1.

    Licensing

    Common Public Attribution License (Socialtext Inc.)

    • socialcalcspreadsheetcontrol.js
    • socialcalctableeditor.js

    Artistic License 2.0 (Socialtext Inc.)

    • formatnumber2.js
    • formula1.js
    • socialcalc-3.js
    • socialcalcconstants.js
    • socialcalcpopup.js

    Artistic License 2.0 (Framasoft)

    • l10n/fr.json

    MIT License (John Resig, The Dojo Foundation)

    • static/jquery.js

    MIT License (HubSpot, Inc.)

    • static/vex-theme-flat-attack.css
    • static/vex.combined.min.js
    • static/vex.css

    MIT License (Stuart Knightley, David Duponchel, Franz Buchinger, Ant'onio Afonso)

    • static/jszip.js

    Apache License 2.0 (SheetJS)

    • static/shim.js
    • static/xlsx.core.min.js
    • static/xlsxworker.js
    • assets/start.html (xlsx2socialcalc.js)

    CC0 Public Domain (唐鳳 / Audrey Tang)

    • src/*.ls (legacy LiveScript sources, preserved until Phase 12 sweep)
    • packages/**/*.ts (TypeScript rewrite)

    Mozilla Public License Version 2.0 (LibreOffice contributors)

    • images/sc_*.png