Round-trip losses
Apiary reads most of what is in an XLSX file. A few features are recognised but not yet carried over to the
workbook. Workbook.unsupportedFeatures names them, so an
application can tell its user before saving. Apiary itself does nothing with the list; what to show, and when, is for
the application to decide.
What the list holds
Section titled “What the list holds”Each entry is one feature of the source file that is missing from the workbook: a tag naming it, a category
saying what kind of thing is lost, and a description in plain English, ready to show to users. For the full list,
go to Unsupported features.
Categories
Section titled “Categories”| Category | Covers |
|---|---|
behaviour |
How the workbook calculates, filters data and restricts what can be entered or changed |
content |
Items the workbook holds that no calculation depends on |
appearance |
Formatting: how an item in the workbook looks, not what it holds |
view |
Settings for how a sheet is shown on screen or laid out for printing |
Checking before an export
Section titled “Checking before an export”The list is most useful right before the workbook is written back to a file, when the user can still choose to keep the original. Filter it to the categories that matter for what you are building and show the descriptions.
const lost = workbook.unsupportedFeatures .filter(feature => feature.category !== 'view') .map(feature => feature.description);if (lost.length > 0) { warn(`Saving as XLSX will drop:\n${lost.join('\n')}`);}