Unsupported features
These are the features of an XLSX file that can be missing from a workbook loaded from it.
Workbook.unsupportedFeatures lists the ones that
were in the file a workbook was loaded from. See Round-trip losses for what
the list means.
Behaviour (13)
Section titled “Behaviour (13)”How the workbook calculates, filters data and restricts what can be entered or changed.
| Tag | Description |
|---|---|
asset-pq |
Power Query queries that import and reshape data from other sources. |
asset-py |
Python in Excel: cells whose formulas run Python code (the PY function). |
asset-vba |
A VBA macro project, including any VBA functions that cells call. |
calc-precision |
A workbook setting that rounds stored numbers to the precision their cells show. |
cell-hide |
A cell format that hides the formula when the sheet is protected. |
cell-lock |
A cell format that leaves cells editable when the sheet is protected. |
cell-mdx |
MDX metadata on cells whose values come from an OLAP cube through CUBE functions. |
data-validation |
Rules that limit what can be typed into cells, including dropdown lists. |
sheet-autofilter |
Filter buttons on a sheet range and the filter criteria set with them. |
sheet-lock |
Sheet protection: what users may and may not change on a sheet. |
table-slicer |
Slicers: buttons that filter a table or pivot table. |
time-slicer |
Timelines: slicers that filter a pivot table by date. |
workbook-lock |
Workbook protection: prevents sheets from being added, removed, renamed, moved or hidden. |
Content (16)
Section titled “Content (16)”Items the workbook holds that no calculation depends on.
| Tag | Description |
|---|---|
asset-3d |
A 3D model placed on a sheet. |
asset-ext |
Custom XML data that another program or an add-in stored in the file. |
asset-oo |
An object from another program, embedded in or linked from a sheet (OLE object). |
asset-vml |
A legacy VML drawing on a sheet: the boxes that show cell notes, and form or ActiveX controls. |
chart |
A chart drawn from cell data. |
chart-chartex |
A chart of one of the types Excel stores separately from classic charts. |
chart-pivot |
A chart linked to a pivot table. |
col-group |
Grouped columns (outline) that can be collapsed and expanded. |
row-group |
Grouped rows (outline) that can be collapsed and expanded. |
scenario |
What-if scenarios: saved sets of input values that can replace the values in chosen cells. |
shape-diagram |
A SmartArt diagram: text laid out in connected shapes. |
shape-math |
A mathematical equation in a text box or shape. |
sparkline |
Tiny charts, each drawn inside one cell. |
table-sortstate |
The sort order remembered on a table. |
workbook-meta |
The Company, Manager and Hyperlink base document properties (the base address for relative hyperlinks). |
workbook-meta-custom |
Custom document properties: named values stored with the file beyond the standard ones. |
Appearance (12)
Section titled “Appearance (12)”Formatting: how an item in the workbook looks, not what it holds.
| Tag | Description |
|---|---|
asset-svg |
The SVG vector version of a picture, stored next to its PNG copy. |
border-diagonal |
A diagonal line drawn across a cell as part of its border. |
cell-checkbox |
A checkbox shown inside a cell in place of its TRUE or FALSE value. |
cell-indent |
Indentation of cell text from the cell edge. |
cell-rtf |
Mixed text formatting within one cell. |
dynamic-style |
Conditional formatting: colours, data bars and icons that change with cell values. |
note-rtf |
Mixed text formatting within a cell note. |
shape-effect |
Shadow, reflection, glow, soft edges and 3D effects on shapes. |
shape-texteffect |
Shadow, reflection and glow on text inside shapes. |
sheet-background |
A background picture tiled behind a sheet. |
sheet-tabcolor |
The colour of a sheet tab. |
table-style-custom |
A table style the author defined, instead of a built-in one. |
View (14)
Section titled “View (14)”Settings for how a sheet is shown on screen or laid out for printing.
| Tag | Description |
|---|---|
print-gridlines |
The option to print gridlines. |
print-headings |
The option to print row numbers and column letters. |
print-setup |
Page setup for printing: paper, orientation, scaling, centring and the other print options. |
sheet-rtl |
A sheet laid out right to left, with column A on the right. |
table-filter-button |
Filter buttons hidden on some columns of a table. |
table-insertrow |
An empty row shown at the bottom of a table for adding new entries. |
view-custom |
Custom views: named sets of display and print settings saved in the workbook. |
view-formulas |
A sheet set to show formulas instead of their results. |
view-gridlines-color |
A gridline colour set on a sheet. |
view-headings |
Hidden row numbers and column letters. |
view-outline-symbols |
Hidden outline (grouping) buttons. |
view-pane-split |
A sheet split into separately scrolling panes (not frozen panes). |
view-tabselected |
More than one sheet tab selected at once (grouped sheets). |
view-zeros |
A sheet set to show zero values as blank cells. |