- Data Grid docs
- About
8sheets Data Grid changelog
What each version of 8sheets Data Grid added, changed and fixed. Spreadsheet has its own version numbers and changelog.
Every release of 8sheets Data Grid is listed here, newest first. 8sheets Spreadsheet has its own version numbers and its own changelog: 8sheets Spreadsheet changelog. Version numbers follow semantic versioning: a change in the first number can break code that uses the API, the second number adds features, the third fixes bugs. The version you have is VERSION, exported by @8sheets/data-grid (src/table-view/version.js in the source), and it is listed with the Spreadsheet's in the name of each source download's entry on your download page.
Each entry says what was added, changed and fixed. Changes that need you to update your own code are marked Breaking. A fix in engine code that both products ship (file reading, number formats, the XLSX writer) is listed in both changelogs.
1.1.0 — 2026-11-20
Added
- Typed editors. A field's
editorchooses its control: a list that suggests the field'soptionsand refuses other values, a list of check boxes (multiselect, stored as "A, B"), a date picker, a check box for booleans (click or Space flips it), several lines of text, or a number. The default follows the field's type and options, in cells and in the record and Add record dialogs. - Fill handle. In an editable grid, dragging the corner of the selected cells down, up or sideways continues numbers, dates, weekdays, months and numbered text as a spreadsheet does, and copies the rest, as one undo step.
- Header bands over groups of columns, from the
columnGroupsoption or a field'sgroup. They stay with pinned columns and are kept as merged cells in an export with the layout. - Context menu on the cells (right-click, the Menu key or Shift+F10): copy with or without headings, paste, fill down, show only or hide a value, sort, group, chart the selected cells, find, pin a row, details, remove and export.
contextMenu: falseturns it off and a function changes its items;openContextMenu()opens it. - Tree data:
tree: { parent, key }or{ level }in the view state shows records under their parents, with rollups of a field over each branch, Show as tree in the Group dialog,setTree(),expandTreeNode()andcollapseTreeNode(). Filters and search keep the parents of a match. A server source gets the tree in the view state. - Pinned rows above or below the scrolling records (
pinnedRows,pinRows(),unpinRows(), Pin row in the context menu), whatever the search, filters and sort. A server source opts in withpinnedRows: true. - Moving records by a grip in each row (
rowDrag), within the grid or onto another grid that takes drops (rowDrop), with the cancellablerowMoveandrowDropevents andmoveRecords(). Row numbers withrowNumbers. - Filter builder: conditions joined by "all" or "any", and groups of them, in the Filter dialog and as
{ any: [...] }and{ all: [...] }in the view state. New conditions: does not contain, ends with, not between, top and bottom N or percent, above and below average, and date periods from today to last year. Pick values has a search box. - Find (the toolbar's Find, or Ctrl+F in the records): finds and highlights cells that hold a text across every matching record without narrowing them, with next, previous and a count;
openFind(),findNext()andcloseFind(). - Sparklines in a column (
sparkline: { type, fields }): a line, columns or win/loss of the cell's own numbers or of other fields of the record. Charts of the selected cells (chartRange()), and the pivot's chart, as columns, bars, a line or a pie, with an SVG download. - Live data:
applyTransaction()andapplyTransactionAsync()apply the application's own updates, added and removed records, also to read-only records, without entering undo;flashChangesflashes the changed cells, andflashCells()does it for server data. - Exports that keep the layout (
layout: true, or the export dialog's check box): XLSX and PDF with header bands, group rows and tree levels as outline levels, the totals row, column widths, frozen headings, number formats and the conditional formatting rules as Excel's own. - Pivots with two row fields, a column field and several values, each with a summary and Show values as (% of grand, column or row total, running total, rank, index). A server source can build pivots with
pivot(remoteTableSource({ pivotUrl })). - Several detail panels open at once with
detailMode: 'multiple', andgetExpandedRecords(). - Density: compact, normal or comfortable rows (
density,setDensity(), Row height in the Columns dialog). - Rename column in the column menu edits the heading in place; the view keeps it as the column's
caption, which exports use. - Ask (
assistantoption): the user describes a view in words, and the host's function answers with a view state, for example from a language model on the host's server. The answer is checked against the fields before it applies;validateState()andgetStateSchema()give the same check and a JSON Schema of the view state. - The interface in German, French, Spanish and Japanese, loaded when first used. These texts are machine translations that a native speaker has not reviewed yet.
- Two examples:
table.html?example=tree(an organisation as a tree with typed editors) and?example=live(a price feed with flashing cells and sparklines).
Changed
setLanguage()returns a promise, since a language's texts load on first use.collapseRecord()takes an optional record ID; without one it closes every open panel.copyRange()takes{ headers: true }to copy the headings first.openPivot()takes{ rows, columns, values }besides the one-field form.
Fixed
In the number formats and the XLSX writer both products share:
- A General number keeps the digits of a very small value (1.23E-07) and switches to 1.2E+06 before ###### in a narrow column, as Excel does.
- A Polish long date reads
poniedziałek, 15 stycznia 2024, with the month in the form a day needs. - An exported XLSX whose cell styles use theme colours includes the theme they refer to, so Excel shows the same colours.
1.0.2 — 2026-11-19
Fixes in engine code the Spreadsheet shares.
Fixed
- Formulas give Excel's answers in more cases: lookup functions spill over a range of lookup values and return Excel's error codes, the Analysis ToolPak functions refuse a range where they take one value, and T, F and beta distributions keep their precision with very large parameters.
- Typed error codes such as #N/A become error values, and 1e309 stays text.
- A CSV field that starts with = opens as text.
- XLSX export keeps every character of the shared strings, also one cut between two read chunks.
- Icons draw their letters (B, I, U, A) in a sans-serif face.
1.0.1 — 2026-11-19
Fixes in engine code the Spreadsheet shares.
Changed
- After a release, grid.8sheets.com moves to the new version the next time it opens, or offers Reload when there are unsaved edits or another tab, instead of keeping the old version until every tab closes. An unchanged version still opens from the cache.
Fixed
- CSV export writes a byte order mark and makes every row as wide as the used columns.
- CSV files and typed numbers keep 15 significant digits with the rest made 0, as Excel stores them: a 16-digit ID read as a number ends in 0 instead of a floating-point rounding, and text columns keep every digit.
- XLSX files: very hidden sheets stay very hidden, tables keep their column list when columns go in or out, and ignored error checks are read and written.
1.0.0 — 2026-11-18
The first release of Data Grid as a product of its own.
Added
- Published on npm as
@8sheets/data-grid, with@8sheets/data-grid-react,@8sheets/data-grid-vueand@8sheets/data-grid-angular, each with a<DataGrid>component. The package holds only the files the grid loads (its modules, Worker, stylesheet and the engine code they use), minified, with TypeScript declarations.VERSIONgives the release. mountTable(element, options)mounts a grid into any element. Each mount has its own search, selection, history and Worker, so several grids can share a page.- A programmable API: the mounted grid has a method for everything a user can do in it (102 in all), from
sortBy,setFilters,groupBy,setColumnandsaveViewtosetCellValue,addRecords,openPivot,scrollToRecord,getRecordsanddownload. The interface takes the same paths, so the same events fire whether a user or the host acts:stateChange,change,selectionChange,rangeChange, cell and row clicks,editStart,editEnd, the cancellablebeforeEdit,beforeAdd,beforeRemoveandbeforePaste,sourceLoad,viewportChange,loadStart,loadProgress,loadEndanderror. Each event has anon…option, andon(type, handler)andoffadd and remove handlers.setOptionschanges live options and handlers without a new mount. Every data change carriessource: 'user'or'api'. The React, Vue and Angular components expose every method on their ref or component and every event as a prop, a kebab-case listener or an output. - A loading state for slow loads (opening a file, choosing another sheet, packing a large array, a server's first block, a pivot): after 150 ms a panel shows what is loading, with determinate progress for CSV (bytes read) and XLSX (cells read against the sheet's recorded size), and Cancel (or Escape) keeps the records shown before.
isLoading(),cancelLoad()and theloadStart,loadProgressandloadEndevents give a host the same. - Opens local XLSX, XLSM, XLTX, CSV and TSV files, read as a stream in a Worker, or records passed as
data: an array of objects, an array of rows, or typed-array columns (transferColumns: truehands their buffers to the Worker). Choose the table, worksheet, header row or range of a workbook with Source, and read chosen CSV columns as text. - Search, typed filters with compound conditions, sorting by several columns (Shift-click a heading), nested groups with collapsible summaries, totals (sum, average, minimum, maximum, count, distinct) and a footer with the count, sum and average of the selected cells.
- A column menu on each heading to sort, filter, group, pin or hide it. Columns sets visibility, order, pinning, width and number format; Views saves named views on the device.
- Pivot reports with a chart of their top categories, and a details view for each record that shows every permitted field, also at phone width.
- Results export as CSV, typed XLSX (one new sheet, no source connections) or PDF, holding the matching rows and the visible columns. System file sharing where the device supports it, and, with a host-supplied service (
sharing), filtered XLSX snapshot links that the author can revoke. - Opt-in editing of a private copy (
allowEditoreditable): per-field rules (readOnly,required,validator), adding and removing records, range copy and paste, fill down, undo and redo, and calculated fields such as[@Units]*[@Price]. - Server data through
dataSource, orremoteTableSource({ queryUrl, exportUrl, detailUrl, updateUrl })for HTTP: the server gets the whole view state with row and column windows, so search, filters, groups, totals and exports cover the full result. Remote edits are sent in revision-checked batches, and a stale revision is refused. renderersdraw a field's cells with your own text or DOM nodes, andonChangereports each change the user makes.- Themes:
chrometakesauto,light,dark, a named workbook skin or a custom set of colour tokens, andsetChromechanges it later. English and Polish interface (language). - Keyboard navigation with arrow keys, native table and form semantics, focusable record details and a bounded DOM, so the page stays small with a million records.
- Infinite scrolling for server data: a
dataSourceis read in cached blocks of 100 rows (the 24 most recently used are kept), the next block is prefetched, and rows not yet loaded show as placeholders while the table is markedaria-busy. A request goes out 90 ms after scrolling settles, and requests in flight are aborted when search, filters, sort, groups or columns change.count,matchesandsourceCountof aTablePageare optional: while the total is unknown, a short or empty block marks the end and the footer counts "300+ records". A page may also carrytotalsandstatsfor the totals row and for data bars and colour scales. - Columns resize by dragging a heading's edge (48 to 800 pixels), fit their content with a double-click on the edge or Autosize column, and move by dragging a heading; Columns does the same from the keyboard or a phone. The view state keeps each column's
widthand the order ofcolumns. - Row selection with
rowSelection: 'multiple' | 'single': a checkbox per record, a header box that selects every matching record ({ all: true, except }, so a large selection stores nothing per record), Space to toggle the focused record,onSelectionChange, andgetSelection(),setSelection(),selectAll(),clearSelection()andgetSelectedIds().exportResults(format, { selected: true })and the export dialog export only the selected records; a server source opts in withselectionExport. - A totals row (
state.totalsRow) pinned under the records, with a sum, average, minimum, maximum or count for each column (columns[].total), over every matching record. - Conditional formatting per column (
columns[].rules): data bars, three-colour scales and value rules (greater than, at least, less than, at most, between, equals, not equal, contains) with theme-aware styles or your own colours, from the column menu or the view state. Bars and scales measure against every matching record. - Master/detail rows:
detailRenderer(record)builds a panel under an expanded record from itsid,valuesandrawvalues. One record is open at a time, and the panel scrolls with the records, up to 360 px tall. - A filter row (
state.filterRow, or Filter row in the toolbar) with an input under each heading:>100,>=5,<0,=42,<>3,10..20(a decimal comma works), words to look for, or=wordfor an exact match. It applies 300 ms after typing stops. - In-cell editing in editable grids: F2, Enter, typing or a double-click opens the cell editor; Enter saves and moves down, Tab saves and moves sideways, Escape cancels, and Shift+Enter opens the record dialog. A value a field rule rejects keeps the editor open with the reason.
- Example pages of the standalone grid, each also in Polish with
&lang=pl:table.html?example=sales,large(a million records with the filter row),server(a simulated server over a million orders;&total=knownreports the total with each block),edit,columns,selection,detailandpivot. - In the Spreadsheet editor, Table view opens the current selection in the grid; the standalone page is
table.html.