Skip to content

JSheets 0.4.4

Pre-release
Pre-release

Choose a tag to compare

@matsonj matsonj released this 10 Nov 21:16

JSheets is a desktop spreadsheet for people who know Excel well, with DuckDB as its calculation engine and a built-in MCP server so AI agents can build and check workbooks. This pre-release is for Linux x86-64, and it also runs on WSL Ubuntu. It adds the table editor. The Mac build follows as 0.4.5.

Install

curl -LO https://github.com/matsonj/jsheets-releases/releases/download/v0.4.4/jsheets-0.4.4-linux-x86_64.tar.gz
curl -LO https://github.com/matsonj/jsheets-releases/releases/download/v0.4.4/jsheets-0.4.4-linux-x86_64.tar.gz.sha256
sha256sum -c jsheets-0.4.4-linux-x86_64.tar.gz.sha256
tar -xzf jsheets-0.4.4-linux-x86_64.tar.gz
./jsheets-0.4.4-linux-x86_64/jsheets-desktop [file.jsheets | file.xlsx] [--mcp [port]]

It needs glibc 2.35 or later and a desktop with OpenGL.

New: the table editor

Data ▸ Open table… (or File ▸ Open table… on the start page) opens a table in its own window, so you can scroll it and edit it directly.

  • Sources: DuckDB databases, MotherDuck (md:), and Parquet, CSV and JSON files. Your MotherDuck token is kept in the system keychain.
  • Any size. Only the rows on screen are read, so a table of millions of rows scrolls, jumps with Ctrl+End and goes to a row with Ctrl+G at once.
  • Edit like a sheet. Type to replace a value, F2 to edit, Delete to clear, Ctrl++ and Ctrl+− to add and delete rows, and Ctrl+Z to undo. Keys work as in Excel.
  • Formula columns. Type = after the last column to add a column such as =IF([@notional]>1000000,"Large","Small"), or rewrite a column with =TRIM(PROPER([@counterparty])). Formulas use Excel's table syntax and the same functions as the sheet, run over the whole table. Saving writes the values.
  • Safe saves. Edits wait until you save, then go to the database in one transaction: all of them or none. If the database refuses a save, for example over a duplicate key, nothing changes and you see its message. A row someone else changed since you opened it is never overwritten. A save over 10,000 cells, or one that changes a column's type, asks first.
  • For agents. MCP tools read tables, make edits, apply formulas and save, limited to sources you have opened yourself.

Also new

  • 3D references such as SUM(Jan:Mar!B2) calculate, and survive moving and deleting sheets.
  • Recalculating after an edit is much faster when an edit reaches many single-cell formulas: a table of 132 SUMPRODUCTs went from about 1.7 s to a fraction of a second.
  • Fewer #UNSUPPORTED results for very long formulas, such as SUMPRODUCT comparisons across many columns and long chains of COUNTIF. Where one remains, Evaluate Formula says why.
  • Dropdown lists filter as you type, and scroll with the mouse wheel.
  • On a Mac keyboard, the delete key clears the whole selection, as in Excel for Mac.
  • For agents: a rejected apply_transaction says which operation failed and why, dry_run: true checks a batch without writing anything, and a call without a task no longer ends the agent's open task.
  • Formats on part of a column are kept when saving to XLSX.

Known gaps

  • Area, stock, radar and surface charts, and Excel 2016 types such as sunburst, treemap, waterfall and histogram, are kept when you open and save a file, but JSheets doesn't draw them yet.
  • Pivot charts and slicers come in 0.5.0.
  • Results can differ from Excel in the last of 15 significant digits.

Check results that matter against Excel until these are fixed.