GemBox.Spreadsheet for Java 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.
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.
Preservation of the unsupported features is managed through
method when loading a workbook with ExcelFile.load 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. ExcelFile workbookPreserved = ExcelFile.load("Workbook.xlsx", LoadOptions.getXlsxDefault()); // Do not preserve unsupported features while loading. XlsxLoadOptions loadOptions = new XlsxLoadOptions(); loadOptions.setPreserveUnsupportedFeatures(false); ExcelFile workbookUnpreserved = ExcelFile.load("Workbook.xlsx", loadOptions);