Skip to content

LocalSheets v1.1 - Local AI panel + JSONL telemetry import

Latest

Choose a tag to compare

@zohaibus zohaibus released this 02 Jun 05:25
· 3 commits to main since this release
4c958e3

New in v1.1

  • Charts - bar / line / pie SVG via Data ▾ → Chart selection…, with copy + download.
  • =SPARKLINE(range, [type], [color]) - handwritten inline SVG cell function (line or bar).
  • Insert/delete row or column rewrites pointing formulas - including cross-sheet refs. Refs to a deleted row become #REF!; refs past it shift. Same for columns.
  • Fill handle propagates formulas - dragging =A1+B1 down produces =A2+B2 instead of copying the value.
  • Absolute references - $A$1, $A1, A$1 tokenized and honored by the fill handle.
  • Local AI panel (toolbar AI) - optional. Talks to a local Ollama instance at localhost:11434. Two modes: freeform text reply or deterministic JSON-patch cell mutations. Streams tokens as they arrive with a live elapsed-time ticker so a 60-second CPU inference doesn't read as "frozen."
  • JSONL / NDJSON import - drop a .jsonl / .log / .ndjson file (one JSON object per line) into Import CSV / JSONL. Union of keys becomes the header; one row per line. Common in robotics and telemetry log streams; valid up to the last complete line after a power loss.
  • 10,000-row sheets (up from 1,000 in v1.0).
  • 199 unit + 28 Playwright e2e specs - all green on Chromium and WebKit.

Verify the file you downloaded (60 seconds)

Local-first means you don't have to trust me - verify locally:

# 1. Network surface — should print exactly 2 lines, both to localhost:11434
grep -nE 'fetch\(|XMLHttpRequest|WebSocket|sendBeacon' localsheets.html

# 2. Integrity -  confirm the file matches the audited version below
sha256sum localsheets.html      # Linux / Git Bash on Windows
shasum -a 256 localsheets.html  # macOS

# 3. Expected SHA-256:
a7e01e62122d6e2c5d75fb5e67f5ee24d45e19858f72197172ec1db8839036a5