Skip to content

GridPath 0.5.0

Choose a tag to compare

View all tags
@pixelsmasher13 pixelsmasher13 released this 27 Oct 16:23
· 2 commits to main since this release
v0.5.0
eac8801

Line charts in the grid, CSV files, and faster edits on large tables.

npm install gridpath@0.5.0

Charts

A workbook's line charts are now drawn in the grid, where Excel placed them. They update as cells recalculate, including when the source cells are off screen, and they save as native Excel charts: their data caches are refreshed and their anchors move when rows and columns are inserted or deleted. Other chart types show a placeholder and are kept in the file as before. sheet.getCharts() returns each chart's definition and current values.

CSV and other delimited text

file, open() and the File menu now take CSV, TSV and other delimited text. The file opens as a new workbook that saves as .xlsx (sales.csv becomes sales.xlsx).

  • Comma, tab, semicolon or pipe, detected from the first lines; Excel's sep= line is honoured; comma decimals in semicolon files.
  • UTF-8, UTF-16 (Excel's "Unicode Text") and Windows-1252.
  • Values are read as if typed: numbers, currency, percentages, dates, booleans and formulas.
  • ZIP codes, IDs and long account numbers keep their leading zeros and digits, where Excel would lose them.

Faster edits

Edits on large tables of per-row formulas and lookups no longer slow down as the table grows: one edit on a 125,000-formula model went from 4.1 s to 0.8 s natively, and takes 1.2 s in the browser.

Demo

The demo at gridpath.dev/demo now opens a fictional company's income statement: three linked sheets, 431 formulas and three line charts. Change the 2027 launch count and watch revenue, net income and the charts move.

Claude Desktop

Download gridpath-0.5.0.mcpb below and double-click it to install the MCP server.

Assets 3
Loading