Changelog
The latest version is v0.7.0. npm currently serves v0.7.0; newer versions are published together in the next npm release.
v0.7.0 Pivot tables and charts
On npm- Pivot tables: row fields, column fields and values (sum, avg, min, max, count), with totals and grouped subtotals computed from the source rows
- Pivot side panel to build the table without code
- SVG charts with no dependencies: bar, stacked bar, line, area and pie
- Charts from a selected range through the right-click menu; they redraw when cells change
- Standalone renderChart; new API setPivot, getPivot, createChart; event pivotChange
v0.6.0 Export, import and filters panel
On npm as part of v0.7.0- Excel (.xlsx) export with number and date formats, merged group headers, a frozen header and AutoFilter
- CSV export with a BOM for Excel and protection against formula injection
- Excel and CSV import that matches headers to columns and validates values like a paste (undoable)
- Filters panel in the side bar, with "Clear all filters"
- Export items in the right-click menu
- Standalone readXlsx and writeXlsx, with no dependencies
v0.5.0 Pages and server data
On npm as part of v0.7.0- Pagination with a pager bar and a rows-per-page choice
- Server-side rows: load blocks from your API as people scroll, with placeholder rows while loading
- Infinite scroll when the total is unknown
- Server-side pages: one request per page
- Sorting, filters and quick search are sent to the server
- New API: setPage, setPageSize, getPageCount, refreshRows; events pageChange, rowsLoaded, rowsLoadFailed
v0.4.0 Grouping and trees
On npm as part of v0.7.0- Row grouping by one or more columns, with group counts and per-column aggregates (aggFunc)
- Group panel: drag a column header above the grid to group by it; reorder or remove chips
- Tree data with getParentId; filters keep the ancestors of matching rows
- Master/detail: an expandable full-width panel under a row, with its own height
- Row drag handle to reorder rows (undoable)
- New API: setGroupBy, expandAll, collapseAll, setGroupExpanded, setDetailExpanded, moveRow
v0.3.0 Spreadsheet tools
On npm as part of v0.7.0- Cell merging for consecutive equal values (merge)
- Fill handle that continues number, date and text series
- Status bar with row counts and totals of the selected cells
- Pinned top and bottom rows
- Ctrl+F find bar and find API
- Wrapping header labels
v0.2.0 Editing and clipboard
On npm as part of v0.7.0- Excel-style cell ranges, copy to and paste from Excel, right-click menu
- In-cell editors: text, number, date, select (with dependent options), textarea and custom
- Validation, change tracking, undo and redo
- Adding and removing rows, custom key bindings