GemBox.Spreadsheet
  • Overview
  • Examples
  • Free version
  • Support
  • Pricelist

    Show / Hide Table of Contents

    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 });
    
    ' Preserve unsupported features while loading.
    Dim workbookPreserved = ExcelFile.Load("Workbook.xlsx", LoadOptions.XlsxDefault)
    
    ' Do not preserve unsupported features while loading.
    Dim workbookUnpreserved = ExcelFile.Load("Workbook.xlsx", New XlsxLoadOptions() With {.PreserveUnsupportedFeatures = False})
    
    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.