Repository navigation
JSheets 0.5.4
Pre-releaseJSheets 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 (it also runs on WSL Ubuntu) and macOS on Apple Silicon. It previews a new model map that an agent helps draw, adds PivotTables over tables and calculated fields, and solves linear Solver models.
Install
Linux:
curl -LO https://github.com/matsonj/jsheets-releases/releases/download/v0.5.4/jsheets-0.5.4-linux-x86_64.tar.gz
curl -LO https://github.com/matsonj/jsheets-releases/releases/download/v0.5.4/jsheets-0.5.4-linux-x86_64.tar.gz.sha256
sha256sum -c jsheets-0.5.4-linux-x86_64.tar.gz.sha256
tar -xzf jsheets-0.5.4-linux-x86_64.tar.gz
./jsheets-0.5.4-linux-x86_64/jsheets-desktop [file.jsheets | file.xlsx] [--mcp [port]]It needs glibc 2.35 or later and a desktop with OpenGL.
macOS: download jsheets-0.5.4-macos-arm64.dmg, open it, and drag JSheets to Applications. It is signed and notarized, and needs an Apple Silicon Mac with macOS 11 or later. /Applications/JSheets.app/Contents/MacOS/jsheets-desktop takes the same arguments as on Linux.
New
-
Model map preview. The Place lens (Ctrl+Alt+P, or Place at the right of the formula bar) docks a map of the workbook under the grid; Ctrl+Alt+M or the expand button opens it full size. The map has three levels:
- Terrain shows sheets as islands, shaped by how far each block is from raw input, with the main path through the model drawn as one river and at most 12 labels.
- Blocks shows sheets as boxes in lanes, from inputs to outputs.
- Chain (Ctrl+Alt+C) follows the selected cell back to its inputs.
-
Agents can describe the map. Two new MCP tools:
apply_mapnames regions, landmarks and routes. Every claim is checked against the workbook's formulas before it is stored, and one call is one undoable step.read_mapreturns what each level shows.
JSheets computes the structure itself: blocks, repeated bands, gaps in filled columns, parallel columns, and depth. The map is JSheets-only: saving as XLSX leaves it out.
-
PivotTables over tables. A PivotTable can use a table as its source and follows it as rows are added. Edit the source inline. MCP and XLSX carry table sources.
-
Calculated fields in PivotTables, calculated as Excel does, with an editor, and kept in XLSX and MCP.
-
Linear Solver models solve with the simplex method.
-
MCP time limit. Agent calls stop after 60 s by default and change nothing. The limit can be changed or turned off in Preferences.
Fixed
- A 30,000-row model of coupled recurrences recalculated slowly. Chains that read the row below now run bottom up, and small fixed lookups run in the fast evaluator.
- Some recurrences showed
#UNSUPPORTED. They now fall back to row-by-row calculation. - Explaining a formula over many cells could exceed its budget. It now reads them as values.
- Edits in workbooks full of INDIRECT recalculated everything. They stay incremental, and a transaction recalculates once.
Known gaps
- The model map is a preview. Its look will change, and clicking a hop in Chain doesn't select it yet.
- Workbook fonts such as Aptos Narrow, the default in Excel for Mac, draw with a wider font, so text that fits in Excel can overflow, and dates show
####. Widen the column for now. - Calculated items in PivotTables open as values.
- On 500,000 source rows, a source edit under many GETPIVOTDATA formulas takes about 1.6 s.
- Results can differ from Excel in the last of 15 significant digits.
Check results that matter against Excel until these are fixed.