Skip to content
Apiary

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.

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.

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.

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.

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.