1. Spreadsheet docs
  2. About

8sheets Spreadsheet changelog

What each version of 8sheets Spreadsheet added, changed and fixed. Data Grid has its own version numbers and changelog.

Every release of 8sheets Spreadsheet is listed here, newest first. 8sheets Data Grid has its own version numbers and its own changelog: 8sheets Data Grid 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 shown in the app under Help > About 8sheets and in src/version.js. The source download is named by its date and lists the Spreadsheet and Data Grid versions it holds (8sheets-source-<date>.zip); downloads up to 1.2.2 were named 8sheets-<version>.zip.

Each entry says what was added, changed and fixed. Changes that need you to update your own code are marked Breaking.

1.6.0 — 2026-11-20

Added

  • CSV and text files follow the region, as in Excel. Opening one reads numbers, percentages, amounts and dates in the region's forms (1,5, 1 234,56, 15.01.2024 and 5 zł in Polish), and a file whose lines all hold the region's list separator splits on it. Export Sheet as CSV separates fields with the list separator: ; where numbers show 1,5. Data > Get Data > From Text/CSV reads values the same way.
  • The Text Import and Text to Columns wizards have Decimal separator and Thousands separator, as Excel's Advanced Text Import Settings, and start with the region's separators and date order.
  • A CSV larger than a worksheet says it was not loaded completely, as Excel does, and keeps the first 1,048,576 rows.
  • Regions: Currency and Long Date on the ribbon and the Date and Currency types in Format Cells follow the region (1 234,50 zł and poniedziałek, 15 stycznia 2024 in Polish), Sort uses the region's alphabet (Ala, Ąkacja, Zebra, Żaba), and the fill handle continues Polish short month and day names (sty, lut; pon, wt).
  • Excel's limits on what a cell takes: text is cut at 32,767 characters, and a formula longer than 8,192 characters, nested more than 64 levels deep or holding text over 255 characters is refused with a message. Through the API such a formula throws and leaves the cell as it was.
  • Show Formulas shows every formula, left-aligned, in columns twice as wide, as Excel does.
  • A typed e-mail address becomes a mailto link.

Changed

  • References in a typed formula are upper-cased (=sum(a1:a3) becomes =SUM(A1:A3)).
  • A legacy formula from a file that Excel shows with @ (=@D1:D2) shows and calculates that way.
  • One notch of the mouse wheel with Ctrl zooms by 10%; a pinch on a trackpad zooms with the fingers.
  • Shift+F11 and Insert Sheet put the new sheet before the active one, Ctrl+drag of a tab copies the sheet, and Undo and Redo in the title bar are greyed out when there is nothing to undo or redo.
  • Increase Decimal on a whole column of numbers no longer measures every cell, so a column of a million values changes at once.

Fixed

Found by clicking through 1,140 scenarios side by side with Excel's documented behaviour:

  • Sheets: renaming a sheet kept formulas that point at it calculating (they showed #REF!), a space can be typed in a tab's name, a copied sheet gets its own tables and sheet names, inserting a row on grouped sheets inserts it on each of them, and SHEET() follows a moved sheet.
  • Selection: Right and Down leave a merged cell, Shift+arrow after a click on a column or row header extends by whole columns or rows, Ctrl+Down skips hidden rows, and Page Down, Page Up and Alt+Page Down move by whole rows and columns so the way back lands where it started.
  • Several areas selected: Sort refuses them as Excel does instead of sorting one area, Insert adds a row above each selected row, and Merge & Center merges each area.
  • Borders: a merged cell's borders are drawn, and the inner lines of All Borders are as thin as the outer ones, also in workbooks from Excel.
  • Formatting: a column format applied after a row format reaches the cell where they cross, theme colours follow a change of the theme's colours, Undo of a font size change restores the row height, and Format Painter paints a whole column picked by its header.
  • Numbers: General keeps the digits of very small numbers (1.23E-07) and switches to 1.2E+06 before ###### in a narrow column, a cell formatted as Text keeps a retyped number as text, and Increase Decimal adds one place to what General shows.
  • Fill and paste: dragging the fill handle left or up counts back (Tue gives Mon, Sun), Paste Special > Transpose transposes formula references, and merging cells keeps the one formula they hold working.
  • Wrap Text in a merged cell no longer makes its row too tall, and AutoFit of a column with wrapped text keeps the text wrapped.
  • Formulas: typing into part of a legacy array formula says it can't be changed, renaming a name in the Name Manager renames it in formulas, and SUBTOTAL with codes 1 to 11 leaves out rows a filter hides.
  • Tables: creating one without headers on data in row 1 moves the data down instead of writing the headers over it, a merged cell is unmerged when a table takes it in, and a table's header row can't be deleted on its own.
  • Data validation: a rule typed in a region with a decimal comma works (1,5), and the input message shows when its cell is selected. Text to Columns asks before it overwrites cells.
  • PivotTables: a value can't be typed over, one made from a table follows the table as it grows, and Undo of a field move moves the field back.
  • Charts: deleting a source column removes its series, dates on a category axis show as dates, Format > Fill colours the selected series, Undo works right after a chart command, and Alt-drag snaps a chart to the gridlines.
  • Notes start with their author's name, and their red triangle sits on a merged cell's corner and hides with a hidden row or column.
  • Filter: searching the value list finds hidden values too.
  • Links follow from the whole of a merged cell, and holding the mouse down on a link selects the cell without following it.
  • Ribbon: the number format box names Currency and Percentage, a double-click on a tab collapses the ribbon, and the Gridlines and Headings check boxes have tips. With the Polish interface the title bar buttons and the formula bar's Cancel and Enter are read in Polish by screen readers.
  • A date in a pasted HTML table lands as a date.
  • 1.2.3 stays text in a region that writes dates with slashes.
  • Collaboration: restoring a version keeps names that point to the restored sheet the same for everyone in the room.

1.5.0 — 2026-11-19

Added

  • Search for commands in the title bar (Option+Q, Alt+Q off a Mac), as in Excel for the web: type part of a name, in English or the interface language, and run it with Enter. It finds every control of the ribbon's tabs and the items of their menus (Custom Sort under Sort & Filter), shows where each one lives, and leaves out what can't run now or the host has hidden.
  • The file name in the title bar shows its state: a dot while changes wait to be saved, a check once they are in the file.
  • The cell menu shows the shortcuts of Cut, Copy, Paste and Format Cells.

Changed

  • A lighter look, after Excel for the web: the ribbon's B, I, U, A and fx glyphs and the formula bar's fx are sans-serif, Paste, Cut, Copy, Borders, Wrap Text, Merge, Find and Filter have colour accents, row and column headers have regular grey labels and lighter lines, gridlines are lighter, and menu rows are 32 points high.
  • Dialogs (Format Cells, Sort, Paste Special and the others in Excel's layout) have a white surface, tabs underlined in the accent colour, larger buttons and light dividers in place of grey boxes.
  • Charts: a value axis takes as many intervals as its labels fit, as Excel does (0 to 160 by 20 where 8sheets used 0 to 200 by 50), and a title without its own bold setting is bold, as Excel draws it.
  • mountWorkbook warns in the console when a mount hangs, and the installation guide says not to await it at the top level of an entry bundled by Vite 7 or earlier.

Fixed

Checked against Excel for Mac 16.115, formula by formula and file by file:

  • Formulas: the Analysis ToolPak functions refuse a range or a logical value where they take one value, Excel's argument counts and reference-only arguments are enforced when a formula is typed or read, and the trigonometric, hyperbolic and FACTDOUBLE limits match Excel. MATCH, XLOOKUP and INDEX spill over a range of lookup values; VLOOKUP and HLOOKUP search before checking the column; the error codes of XLOOKUP, INDEX, MATCH and AGGREGATE match Excel. Formulas from files made before dynamic arrays keep reading their own row of a range.
  • T, F and beta distributions keep their precision with very large parameters (1E+10 degrees of freedom).
  • Deleting a sheet turns the references to it into #REF! in formulas, names, data validation and conditional formatting, so a new sheet of the same name doesn't take them back.
  • Typed entries: error codes such as #N/A become error values, TRUE with a space and 1e309 stay text, and AM or PM needs a space before it. A single number dragged with the fill handle copies it; Ctrl-drag and Fill Series count.
  • Names: the Name Manager, the Name Box and the API accept the names Excel accepts (XFE1, a?b, Przychód) and refuse the ones it refuses (TRUE, C1048576).
  • Data validation: a list item matches in any case and with spaces around it and is stored as the list spells it; text length counts what the cell holds; a typed '5 is checked as the text 5.
  • Opening a CSV keeps fields that start with = as text and asks once whether to calculate them.
  • PivotTables size their columns with the cells' own font, bold totals included, so a grand total no longer shows ######.
  • Saving keeps every character of the shared strings, also one cut between two read chunks.

1.4.0 — 2026-11-19

Added

  • Data > Data Analysis: the Analysis ToolPak's 19 procedures (Descriptive Statistics, Histogram, Correlation, Covariance, Rank and Percentile, Moving Average, Exponential Smoothing, Sampling, Random Number Generation, the t-, z- and F-tests, the three ANOVA tools, Regression and Fourier Analysis), written as values to a range or a new sheet.
  • Background error checking for numbers stored as text: the green triangle, Convert to Number, Ignore Error (kept in the file) and Error Checking Options. Circle Invalid Data and Clear Validation Circles under Data Validation.
  • Quick Analysis (Ctrl+Q and the cell menu), with text formatting (Text Contains, Duplicate, Unique, Equal To) for a selection of text.
  • Trim references (A1:.A30, A1.:A30, A1.:.A30) and TRIMRANGE's trim_rows and trim_cols. An R1C1 reference style box in Calculation Options; R[-1] and C[1] stand for whole rows and columns.
  • Charts: Format pane bins for histogram and Pareto charts, Set as total and connector lines for waterfalls, and box and whisker options.
  • Tables: Set As Default for table styles (Insert > Table and Ctrl+T use it) and the Set as default table style box in New Table Style; Insert > Table Rows Above/Below, Table Columns to the Left/Right and Delete > Table Rows/Columns in the cell menu inside a table.
  • PivotTables: Filter Connections and Report Connections, Keep Only Selected Items, Hide Selected Items, Show Report Filter Pages, Delete PivotTable in the cell menu (Delete on a whole PivotTable removes it), sources by table name or Sheet!range, and boxes for what empty and error cells show.
  • Get Data: tables from a web page, picked as in Excel's navigator; From Text/CSV takes any one-character delimiter and Do not detect data types; Split Column by Delimiter; Load To… a cell of an existing sheet, or Only Create Connection.
  • A .txt file opens through the Text Import Wizard (delimiters or fixed widths, start row, a format per column). Text to Columns shares its steps: a format per column (General, Text, Date in six orders, Skip) and break lines set by clicking the preview.
  • Consolidate from other workbooks with Browse…, by value.
  • Printing: grouped sheets, Ignore print area, Draft quality, typed Print Titles, Ctrl+F2, Show Margins in the print preview with margin lines to drag, and View Options > Page breaks in Normal view. In Page Break Preview, breaks can be dragged and the cell menu inserts and removes them.
  • The ribbon: split Borders (with inside borders), Underline (Double Underline) and Accounting buttons; Format Cell Alignment in the Orientation menu; a collapsed ribbon opens from its tabs for one command and has a pin to keep it shown; a double-click on a tab collapses it.
  • Quick Access Toolbar: right-click a ribbon command to add it beside Undo and Redo. Customize the Ribbon… chooses which tabs show. Both are kept per browser, and a host's own wb.ribbon settings still apply.
  • Right-drag the fill handle for Excel's fill menu; Regroup for shapes; Group and Ungroup only when they can act.
  • Paste Special All using Source theme, with the options in Excel's order; File > Export Sheet as Text (Tab delimited); script shortcut keys and descriptions.
  • The Insert Options button after inserting rows or columns, negative Fixed Decimal places, and more of Excel's Windows shortcuts (Ctrl+F1, Alt+F1, F11, Alt+;, Ctrl+Shift+O, Shift+F4).
  • Screen tips on filter buttons, such as Name: Equals "Ann", and Data Validation boxes named after the kind of rule (Start date, End time, Length).

Changed

  • After a release, sheet.8sheets.com moves to the new version the next time it opens: it downloads in the background and reloads, or offers Reload when there is unsaved work or another tab. Before, the old version stayed until every tab of the app was closed. An unchanged version still opens from the cache.
  • Custom Views are refused while the workbook has a table, and Remove Duplicates refuses outlined data, as in Excel.

Fixed

  • Create Table, Sort, Filter and Ctrl+A no longer take in rows past an empty row below the block.
  • A cell formatted as Text keeps a typed entry as text (00123, long card numbers, =1+1); typed numbers keep 15 significant digits, as Excel stores them.
  • Tables: a total row turned off and on keeps its formulas; a column inserted or deleted inside a table updates its column list; tables refuse left-to-right sorts.
  • XLOOKUP with an omitted lookup value finds the first blank cell, as Excel does.
  • Waterfall connector lines, box and whisker inner points and By Category histograms from Excel files are drawn as Excel draws them, and histogram bins end at the overflow bin.
  • Remove Duplicates moves formulas with their references; Fixed Decimal shifts without rounding errors.
  • Protected sheets: Use AutoFilter, sorts over locked cells refused, Insert hyperlinks, paste without Format cells, the mouse selection options, and structure protection for the commands that add sheets.
  • 3-D references follow added, moved and deleted sheets; very hidden sheets stay very hidden; row and column sizes, Standard Width and gridlines reach grouped sheets.
  • Add to Print Area joins adjacent areas, and page breaks work with whole rows or columns selected.
  • Showing the ribbon after collapsing it no longer leaves the window's rows out of place.

1.3.0 — 2026-11-18

Added

  • The editor's title bar has a Table view button. It opens the current selection, or the table the active cell is in, in 8sheets Data Grid on top of the workbook: search, filter, group and total its records, then return to the workbook. Data Grid is released on its own; see the 8sheets Data Grid changelog.
  • Control the editor from code. Every ribbon control, menu row and shortcut has a stable command id (ribbon.home.bold, ribbon.insert.pivotTable, grid.find), runs with wb.commands.execute(id, value) and fires the new cancellable before-command and after-command events with its source. wb.commands.canExecute says whether a command applies now, 65 ui.* commands open the app's dialogs and panes, and wb.ribbon lists, hides and shows controls, groups and tabs.
  • Sheet features from code, each change one undo step: data validation (setValidation), conditional formats (addConditionalFormatRule with #RRGGBB colors), notes, hyperlinks, sparklines, row and column groups, findAll and replaceAll, and threaded comments (addComment, CommentThread).
  • Handles for charts and shapes (sheet.chart(), sheet.shape(): name, position, title, series, text, fill, layer order), PivotTables and slicers (sheet.addPivotTable, SheetPivot, SheetSlicer), password protection of sheets and of the workbook structure, custom functions with async results (wb.functions.define), the region for number and date formats (wb.region), and cell types (range.cellType, registerCellType, registerButtonAction).
  • wb.openFile takes a Blob without a name and tells xlsx from csv itself.
  • A simplified ribbon, one row of the most used commands with the rest behind More, switches to the classic ribbon with the chevron at its end (ribbonLayout option). Menus have icons, and a right click shows a mini formatting toolbar above the cell menu (miniToolbar option). Menus and panels open at once, with no animation.
  • View > Interface Size scales the ribbon, bars, menus and dialogs from 75% to 200% (uiScale option), so the editor fits a host page's own sizes.
  • More keys as in Excel on Windows and Linux: Ctrl+Shift+V pastes values, Ctrl+T opens Create Table, Ctrl+F3 the Name Manager, F4 repeats the last action, Alt+Shift+Right and Left group and ungroup, and Backspace empties the active cell into Edit mode. AltGr characters type instead of running shortcuts.
  • The Borders menu has bottom double, thick bottom, and top and bottom borders; Format Painter repeats the source cells' formats, merges and conditional formats, and a double-click keeps it on until Esc; sorting part of a block asks to expand the selection (Sort Warning).

Changed

  • 8sheets Data Grid is now a product of its own, with its own version numbers, changelog and npm packages (@8sheets/data-grid, @8sheets/data-grid-react, @8sheets/data-grid-vue, @8sheets/data-grid-angular). @8sheets/core and 8sheets stay the Spreadsheet's packages; everything 1.2.2 offered works as before, and the additions above are new. Both products come in the one source download and under the one licence.
  • The source download is named by its date (8sheets-source-<date>.zip) and holds the latest Spreadsheet and Data Grid versions, with both changelogs.

Fixed

  • sheet.protect(options) reads true as allowed and false as not allowed, in the app and in the saved file alike. Before, both locked the action in the app while the file told Excel false meant allowed. The file format's '0' and '1' keep their meaning.
  • Cell types survive a round trip through toJSON and .8sh as working cells, and a workbook saved to xlsx without a page keeps its cell types, files and backgrounds.
  • A conditional format's color scale or data bar given as #RRGGBB applies its colors.
  • Merging cells keeps the first value and that cell's format, alignment included, as Excel does; the toolbar shows what is drawn, and the merged cell becomes the active one.
  • Typed entries follow Excel's rules: currency, accounting negatives (5), fractions, scientific numbers, dates with two-digit years, times past 24 hours, and dates and times together, each with Excel's format. The fill handle counts up from a lone number or time, as Excel for the web does.
  • Formula and number format results that differed from Excel for the web now match it, among them TEXT past the last date, MOD of huge numbers, real roots of negative numbers, text order in sorts and comparisons, RATE and CELL("address").
  • Formatting the whole sheet reaches every cell, and borders on whole columns and rows run to the end of the sheet. Clear Formats unmerges and removes conditional formats, Clear All also validation, notes and links, each as one undo step, and clearing whole columns clears their own formats.
  • Data validation checks a custom rule with the typed value in the cell, a typed formula by its result, and dates and numbers in a list by value; the list shows its cells as formatted.
  • Delete, Clear, Ctrl+Enter and formatting leave the rows a filter hides alone; Find in values skips hidden cells; Replace leaves formulas it would break and spilled cells, says what it skipped, and is one undo step across the workbook.
  • Sort and Filter pick the data block as Excel does, a table without filter buttons sorts its body only, Ctrl+Shift+L in a table toggles its buttons, and a header row is guessed only when it differs from the row under it.
  • AutoSum sums a selected block at once and, for one cell, proposes the sum in the editor; it never writes over data.
  • Undo after deleting a sheet keeps the steps on other sheets, Duplicate Sheet copies conditional formats, validation, notes, links, filters, page setup and protection, and the Name Box never redefines an existing name and accepts names in any script.
  • Rows grown for a bigger font or wrapped text fit again after undo or a column width change; AutoFit leaves hidden rows hidden; a new sheet goes after the active one.
  • Pasting from Excel keeps text cells as text; once copy mode ends, Paste does nothing instead of pasting a copy without formulas; rows pasted or filled under a table join it.

1.2.2 — 2026-11-18

Fixed

  • Each open document now has its own crash recovery copy. Saving one workbook preserves recovery copies from other tabs. Opening a file from the recent list or by dropping it on the editor asks before replacing unsaved work.
  • Changes made as an XLSX save finishes stay pending for the next save. If the workbook changes while its cells are still being written, the save stops and asks you to save again.
  • CSV import detects separators outside quoted fields and handles CRLF split across stream chunks. An unsuccessful import reports the error and keeps the previous workbook open.
  • CSV export skips unallocated cell blocks in sparse sheets. CSV parsing and output encoding now run in a Worker.

1.2.1 — 2026-11-18

Changed

  • The editor and embedded workbooks now hide unsupported ribbon commands and their empty groups by default. Commands that become available for a different selection or view stay visible. Set unavailableCommands to "show" to display unsupported commands with an explanation.

1.2.0 — 2026-11-17

Added

  • The onlineFeatures option of mountWorkbook and wb.setOptions turns off, for the whole page, every feature that reaches another site: the AI assistant, AI Settings and AI functions, Get Data From Web, data sheets bound to a web address, WEBSERVICE, pictures from IMAGE and SPARK_IMAGE, and a collaboration server on another site. Their commands leave the ribbon and the Get Data menu, and the features refuse to run (#BLOCKED! in cells) and follow no redirect, so cell data never leaves for another site. Turning it off during a session to a server elsewhere ends that session, and the workbook calculates again. Addresses on the page's own site keep working, and so does an AI handler set with setAiRequestHandler, which is the host's own code. Sharing between tabs of one browser still works. It suits a host that embeds the spreadsheet next to business data.
  • The scripts option leaves out the Automate tab, View > Macros and Record Actions, and refuses to open scripts from a shortcut. Scripts run in the page with its rights, which a host holding other data may not want.
  • The unavailableCommands option: hide leaves out the commands Excel has that this app can't run, which otherwise stay on the ribbon, disabled, with the reason in their tip; a group left with nothing usable goes too.

1.1.0 — 2026-11-17

Added

  • The collaboration server comes with the source: tools/collab-server.mjs, a Node server with no dependencies that you run yourself, so File > Share works between people without collab.8sheets.com. README.md says how to set it up for others (COLLAB_BIND, COLLAB_DATA, COLLAB_ORIGINS, TLS through a reverse proxy) and what it does not protect. tools/check-all.mjs in the download no longer fails on the collaboration check, which needs this server.
  • The collabServer option of mountWorkbook and wb.setOptions sets the server File > Share offers, as a ws: or wss: URL; another kind of address throws a RangeError. Before, the default was fixed in the source, so an npm install could not change it.

Fixed

  • Recalculation no longer freezes the page for long: a change that needs more than one time slice (10 ms) of work goes on in the background, however few formulas it touches. Before, up to 4,000 formulas were calculated at once, so a sheet of 1,000 SUMIFS over 100,000 rows blocked typing for about a second after each edit. Slices also end on time when formulas are slow: the clock is read after at most 16 formulas, not 128.
  • Calculate Now (F9, wb.calculate()) recalculates data tables also when the book calculates them only on demand ("Automatic except data tables") and the calculation takes longer than one time slice. Before, a long one left them stale.

1.0.0 — 2026-11-17

The first release offered with a source licence.

Added

  • Published on npm as @8sheets/core (also as 8sheets, the same package), with @8sheets/react, @8sheets/vue (Vue 3.4 or later) and @8sheets/angular: minified ES modules with their TypeScript declarations and every file they load at run time (Workers, icons, dictionaries, map data). npm i @8sheets/react @8sheets/core replaces copying the source and adjusting an import path. The npm package is free to evaluate; using it in a product needs a licence, as before, and there is no licence key. tools/build-npm.mjs builds the packages.
  • Opens, edits and saves Excel workbooks (.xlsx, .xlsm, .xltx) and CSV entirely in the browser. Files are read as a stream in a background thread; tested with 1,000,000 rows by 20 columns.
  • 502 Excel functions, including dynamic arrays, LET, LAMBDA, XLOOKUP, GROUPBY and PIVOTBY, checked against real Excel results. Function names in many languages.
  • Tables, sorting and filtering, conditional formatting, data validation, sparklines, PivotTables and PivotCharts, slicers and timelines.
  • Every chart type, including 3D, combo, treemap, sunburst, waterfall, funnel and filled maps; 187 shapes; pictures; notes and threaded comments.
  • Page layout, print preview and PDF export.
  • Unknown parts of a file, such as VBA projects, Power Query and custom XML, are kept unchanged when it is saved.
  • Automation with JavaScript scripts; spell checking and a thesaurus for English and Polish; accessibility checker, screen reader support, keyboard tips and a touch layout; English and Polish user interface.
  • A JavaScript API: mount the whole app or parts of it in a page, or run a workbook in Node with no page. TypeScript declarations in src/api/types.
  • Opening a sample workbook from the address: ?open=<name>.xlsx loads a file from the app's own samples/ folder.
  • sheet.addChart(type, range, rect, { title }) sets the chart title, and the source range may be on another sheet ('Data!A1:D13').
  • Four advanced samples: a sales dashboard, a five-year financial model, a project plan with a Gantt view, and a PivotTable report with slicers and a timeline.
  • VERSION is exported from the API, and the About window shows the version with a link to this changelog.
  • wb.setOptions(patch) changes the options of a mounted workbook at once, without mounting it again: chrome, theme, fileName, language, parts (show or hide each part) and every option of the options table but sheets. An option given as undefined or null goes back to its default. sheets and data throw a TypeError naming them. The whole patch is checked before any of it applies (a skin, a theme object and each option's value included), so a patch that throws changes nothing, and wb.options holds what applied. A headless workbook takes chrome and theme.
  • React, Vue and Angular components in integrations/, each with types, a README and a tested example app: options change in place through setOptions, compared by value, workbook events become the framework's events, and the workbook is destroyed with the component. An option setOptions refuses is reported once (onError, the Vue error event, the Angular sheetError output) while the other changed keys apply. In Vue, a listener added after mount subscribes at once.
  • src/api/index.d.ts and src/api/embed.d.ts, generated beside the entry files, so import { mountWorkbook } from './src/api/index.js' is typed in TypeScript with no path setting.

Changed

  • The deployed app is minified and loads rarely used code (saving, encrypted files, several dialogs) when first needed: opening a workbook downloads about 1.6 MB of compressed JavaScript instead of 2.7 MB. The source you receive stays readable.
  • The theme gallery offers 8sheets' own themes and colour sets; the default Office themes stay, and a theme stored in a file is kept as before.
  • wb.settings.set(patch) checks every value against what its option takes (its listed values, true or false, a number in range) and throws a RangeError before changing anything. It used to store any value.
  • wb.getCellRect(row, col) is relative to the mounted element, as documented and as wb.hitTest takes points. It used to be relative to the grid, so it left out the ribbon, formula bar and title bar above it.

Fixed

  • Formulas typed in the app whose ranges arrive indirectly (through LET, LAMBDA, defined names, table references, spill references such as A1#, or functions that return a reference such as OFFSET, INDEX and XLOOKUP) are now saved as dynamic-array formulas. Before, Excel reduced them to a single value when it opened the file.
  • wb.openFile(file) now rejects when the file can't be opened. Before, it resolved as if it had worked, and the failure only showed in the status bar.
  • When the background file reader fails to start, the status bar now says so instead of showing an empty reason.
  • Saving through the API (saveXlsx and documents) kept slicers, timelines and data-sheet charts out of the file. Every save path now writes the same layers.
  • PivotTables built from the same table now share one pivot cache, as in Excel, so one slicer can drive several of them.
  • A PivotTable value field with its own number format (such as 0.0%) saved it without registering the format; PivotChart axes now use the value field's number format.
  • Defined names holding LAMBDA or newer functions, set through names.set or the Name Manager, are now saved with the prefixes Excel needs to calculate them.
  • Rows now grow to fit a larger font, or wrapped text, set or written through the API (range.style, range.values, range.input), as they do in the app. A height you set is kept. range.fitRows() refits on demand.
  • SheetTable.setOption('headerRow' | 'totalsRow' | 'filterButton', …) now adds or removes the header row, the totals row and the filter buttons, as the ribbon does. Before, it only changed a flag. Unknown option names now throw a TypeError.
  • A mountWorkbook that fails part way, for example on data that isn't 8sheets JSON or a theme that doesn't exist, rejects and gives back everything it took: the element's contents, the page listeners and overlay, the app's listeners and Worker. Before, the half-made workbook stayed alive and counted as mounted.
  • theme.apply refuses a theme object that lacks a name, a font or any of the twelve colors with a RangeError, before changing anything, instead of failing part way.
  • With several workbooks on a page, a dialog or menu belongs to the workbook it was opened from: closing it gives the focus back there, also after another workbook was destroyed. Before, the first workbook mounted took every one.
  • Destroying the last mounted workbook gives back what the page held for it: the document listeners that track the workbook in use, the overlay that menus and dialogs open in, and the watch on injected styles. Before, they stayed for the life of the page.
  • A workbook destroyed while it has a menu, dialog, Find panel or data card open closes them; the other workbooks on the page keep theirs. The shared map and picture Workers end with the page's last workbook.
  • A destroyed workbook no longer keeps watching the shared overlay, which kept the whole workbook in memory and could move focus for another workbook's dialogs.
  • An open or save cut short by wb.destroy() now rejects instead of waiting forever, and a destroyed workbook starts no status bar timer.
  • wb.destroy() is safe to call twice, and mountWorkbook followed by a destroy while another mount is loading (as React StrictMode does) leaves that mount whole.
  • chrome: 'colorful' and the other skin names, or your own skin, work in mountWorkbook: the skin sits on its light or dark base. The TypeScript type of chrome lists them.
  • A part hidden with parts: { statusBar: false } stays hidden when a file's view settings show the status bar or ribbon.
  • Embedded workbooks are styled in bundled apps: the stylesheet now loads as a module generated from app.css (tools/gen-app-css.mjs) instead of a fetched .css file, which Vite's dev server answered with JavaScript and Next.js with webpack added unscoped to the whole page while shipping an empty file.
  • Bundled apps (Vite, webpack, Next.js with Turbopack or webpack) build and ship every file 8sheets loads at run time: the filled-map data, the thesaurus files and the formula-language packages are written out as literal URLs and imports, so filled maps no longer fail in a bundled app.
  • The encrypted-save spool no longer imports Node's modules in code the browser also loads, which broke webpack builds; Node gets them from process.getBuiltinModule (Node 20.16 and 22.3 on, older Node uses memory).
  • src/ui/app.js has no top-level await, so bundlers targeting browsers without it (webpack's default) accept it. The full page starts as before.