New in GemBox.Spreadsheet 3.5:
- Full support for Data Validation in XLSX
- Collections now implement generic versions of appropriate .NET interfaces
- Exporting to html supports exporting pictures
- Methods for sorting
- New methods for extracting to DataTable without needing to predefine DataTable (column type is defined by the data in appropriate column)
- Full support for sheet protection in XLSX
- Helper methods for setting Print Titles and Print Area
- Support through API for print gridlines and left/right header/footer in ODS
- Inserting/extracting pictures using absolute positioning is now more accurate
New in GemBox.Spreadsheet 3.3:
- Full support for OpenDocument spreadsheet (.ODS) file format
- XLS formula parser now supports additional 150 Excel functions
- Support for document properties
- New sample explorer (separate download)
New in GemBox.Spreadsheet 3.1:
- Generic HTML export (override any part of data export with custom method)
- Customizable ExtractToDataTable methods
- Hyperlink support in XLSX
- Native samples and DLL for Visual Studio 2008 (.NET 3.5)
New in GemBox.Spreadsheet 2.9:
- Read/write support for new XLSX files (Excel 2007 Open XML)
- Faster loading of XLS files (up to 6 times faster!)
- Mono support (GemBox.Spreadsheet.dll works on Unix/Linux machines with Mono)
New in GemBox.Spreadsheet 2.7:
- Save to stream and load from stream features (both XLS and CSV files)
- Improved ASP.NET support (works on web servers with reduced permissions)
- Delete(), InsertEmpty() and InsertCopy() methods on ExcelColumn
- Using 10 to 15 percent less memory when reading or writing XLS files
Note that with version 2.7 we have made some major changes:
a) We changed name, “ExcelLite” is now called “GemBox.Spreadsheet”
b) DLL is now called “GemBox.Spreadsheet.dll”
c) Namespace is now “GemBox.Spreadsheet”
d) Due to many issues with MS control licensing, we no longer support licensing via licenses.licx file, we only support SetLicense() method
e) ExcelLite.SetLicense() is now called SpreadsheetInfo.SetLicense()
