Skip to content

JSheets 0.2.4

Pre-release
Pre-release

Choose a tag to compare

View all tags
@matsonj matsonj released this 05 Nov 23:10
v0.2.4
e4b9a91

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.

Install

curl -LO https://github.com/matsonj/jsheets-releases/releases/download/v0.2.4/jsheets-0.2.4-linux-x86_64.tar.gz
curl -LO https://github.com/matsonj/jsheets-releases/releases/download/v0.2.4/jsheets-0.2.4-linux-x86_64.tar.gz.sha256
sha256sum -c jsheets-0.2.4-linux-x86_64.tar.gz.sha256
tar -xzf jsheets-0.2.4-linux-x86_64.tar.gz
./jsheets-0.2.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

  • Large workbooks open much faster. A 2.4-million-cell workbook (Microsoft's AdventureWorks sample) imports in 6 seconds instead of 49, using less memory. Workbooks with hundreds of defined names no longer recalculate once per name while opening: one with 848 names went from over 90 seconds to a few.
  • Merge and unmerge cells, with undo, and as merge_cells and unmerge_cells MCP operations.
  • The JSheets icon shows in alt-tab, docks and launchers. On first start the app adds a jsheets.desktop entry and its icon under ~/.local/share.

Fixed

  • Deleting many columns at once no longer runs out of memory. 415 single-column deletes on a 1,600-column sheet take a few seconds and undo in one step.
  • INDEX(range, 0) on a single row or column selects the whole row or column inside a function, so MATCH(TRUE, INDEX(B2:AK2<0, 0), 0) works.
  • Rounding at exact halves matches Excel: an average of exactly 90.05% shows as 90.1%, and TEXT(2.675, "0.00") gives 2.68.

Known gaps

  • 3D references such as SUM(Sheet1:Sheet3!A1) aren't supported.
  • Results can differ from Excel in the last of 15 significant digits.

Check results that matter against Excel until these are fixed.

Assets 5
Loading