Click or drag to resize
Preservation

GemBox.Spreadsheet supports most of the Microsoft Excel and Open Office features through its API, but not all.

For example, GemBox.Spreadsheet doesn't support certain charts through its API.

Note Note

Unsupported features will be incrementally added to the future versions of GemBox.Spreadsheet, based on customer feedback.

Although not supporting all Microsoft Excel and Open Office features through its API, GemBox.Spreadsheet allows you to preserve the unsupported features, so you don't lose any relevant workbook information when loading and saving to the same file format.

Activate / deactivate preservation

Preservation of the unsupported features is managed through

properties when loading a workbook with ExcelFileLoad static methods.

By default, preservation is activated.

The following example shows how to load an XLSX workbook with and without activated preservation:

// Preserve unsupported features while loading.
var workbookPreserved = ExcelFile.Load("Workbook.xlsx", LoadOptions.XlsxDefault);

// Do not preserve unsupported features while loading.
var workbookUnpreserved = ExcelFile.Load("Workbook.xlsx", new XlsxLoadOptions() { PreserveUnsupportedFeatures = false });