What the editor does with each part of a workbook, and what it gives the app it’s in. For how a saved file compares with the one opened, see Excel fidelity .
Find a feature
Edit Shown, and people can change it as in Excel.
Show Shown, kept in the file, and changed only in part, as the note says.
Keep Not shown, but kept in the file as it was.
No Not supported: the note says what happens instead. Files Excel workbooks (.xlsx, .xlsm) Edit Saved back with every part the editor didn’t change as it was. CSV, TSV and text files Edit Open as a workbook of one sheet and save as .xlsx; any sheet downloads as CSV. Macros (VBA, Excel 4.0 macro sheets) Keep Kept by default; the macros option can remove them when saving, or refuse such files. ActiveX controls and embedded objects Keep Or refused, with the activeContent option. Links to other workbooks Keep Their last values are shown and kept. .xls, .xlsb and .ods files No Refused, saying so. Password-protected and sensitivity-labelled files No Refused, saying so.
Cells and formatting Text, numbers and dates, typed in the user’s locale Edit Number formats, built in and custom Edit Fonts, colours, fills, borders, alignment, wrapping and indents Edit Several fonts within one cell Show Drawn in one font; all of them are kept. Merged cells Edit Column widths, row heights and AutoFit Edit Hidden, grouped and frozen rows and columns Edit Conditional formatting Edit Cell rules, top and bottom, averages, duplicates, colour scales, data bars and icon sets. Data validation Edit Lists and rules, as Excel’s Data Validation dialog sets them. Excel 365 checkboxes Edit Hyperlinks Edit Notes and threaded comments Edit Protected sheets Show Their locked cells can’t be changed; the protection itself isn’t changed here.
Formulas 477 of Excel’s 518 worksheet functions, calculated live Edit The others keep Excel’s saved results. Dynamic arrays and their spills Edit LET, LAMBDA, MAP, REDUCE, SCAN and names defined as LAMBDAs Edit Defined names Edit With Excel’s Name Manager. Tables and structured references Edit Used and kept; new tables aren’t made here. Circular references and iterative calculation Edit Names belonging to one sheet, written with it (Prices!Rate) Keep Excel’s saved value is kept until Excel recalculates. What-if data tables Keep Excel’s saved values are kept.
Working with data Sort Edit By several levels, by a custom list, with case, or left to right. Filters Edit By values and by condition; filters by colour, icon or date period are kept. Find and replace Edit Fill handle, Fill Series, custom lists and AutoComplete Edit Inserting and deleting rows, columns and cells, and moving cells Edit References everywhere follow them, as in Excel. Adding, renaming, moving, hiding and deleting sheets Edit
Charts and pictures Column, bar, line, area, pie, doughnut and scatter charts Edit Inserted from a selection, moved, resized, and their type, title, legend and data changed. Radar, bubble, stock, 3-D and pie-of-pie charts Show Drawn from the cells (3-D drawn flat), moved, resized and retitled. Surface, waterfall, treemap, histogram, funnel and other newer charts Keep Shown as a placeholder with the chart’s title. Data labels, trendlines, error bars and gradient fills on charts Keep Pictures and shapes Show Shown as placeholders where they sit, and moved, resized and deleted. Sparklines Keep
Pivot tables Pivot tables Edit Worked out live as their source changes, with the PivotTable Fields pane, filters and Show Values As. Inserting a pivot table Edit Over a range, a table or a name, on a new sheet or at a cell. Pivot tables with grouped or calculated fields Show As Excel saved them; Excel refreshes them on opening. Slicers and timelines Keep
Working together Undo, redo and the history of who changed what Edit Reviewing every changed cell before saving Edit With a schema’s reviewBeforeSave. Several people editing at once No Your app can refuse a save that conflicts, with SaveConflictError. Printing and PDF No Print settings are kept in the file.
For your app React, web component, Angular and plain HTML Yes A component and hook, a custom element, or a mount function. Schemas Yes Sheets, tables and cells described as data: types, bounds, patterns, lists, uniqueness and rules across records. Async checks Yes Checks that call your services as people type, with cancellation, timeouts and saving that waits for them. Business logic Yes onChange fills cells from your systems in the same undo step; beforeSave has the last word. Schema designer Yes Generate a schema from a workbook, edit it, and export or import it as JSON. Saving to your app Yes The .xlsx, the values in your schema’s shape, every change and the history. Drafts Yes Unsaved edits are kept in the browser and offered back. Theming and icons Yes Design tokens for every colour, font, size and corner, and replacement icons. Languages and locales Yes English and German built in, your own added, dates and numbers in the user’s locale. Turning parts off Yes Hide opening, saving, the designer, the report, charts or the format bar. Events and logging Yes What the editor does and how long it took, and when it stops working. Accessibility Yes Excel’s keys, screen reader support, forced colours and touch.
Nothing matches. Try a broader word, or see Excel fidelity .
