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 3D charts and equations through its API.

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

• XlsxLoadOptions.PreserveUnsupportedFeatures,
• XlsLoadOptions.PreserveUnsupportedFeatures,
• XlsbLoadOptions.PreserveUnsupportedFeatures,
• OdsLoadOptions.PreserveUnsupportedFeatures

properties when loading a workbook with ExcelFile.Load(String, LoadOptions) static methods.

By default, preservation is activated.

Note

Default load options returned from XlsxDefault, XlsDefault, XlsbDefault and OdsDefault static properties have preservation activated.

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

• C#
• VB.NET

// 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 });