Version History
The following page contains information about GemBox.Spreadsheet version history with links to the release blog post, stand-alone help file in CHM format, and on-line help, and it shows the release and end support dates.
GemBox.Spreadsheet 4.9
Release date: 2022-04-21 (blog post)
- Support for cross-platform export to images.
- Support for writing SVG.
- Support for custom shapes.
- Support for reading XML Spreadsheet 2003.
- Support for XLSB.
- Support for Pivot table calculation.
- Support for Excel 2021 formula functions.
Previous Versions
Note
Previous versions for which support has ended are no longer maintained. You can download the last bug fix for them from the bug-fixes page. You can continue to use the previous version indefinitely (the licenses are perpetual), but if support has ended, no additional bug fixes will be released.
GemBox.Spreadsheet 4.7
Release date: 2020-09-16 (blog post)
Support ended on: 2022-04-21
GemBox.Spreadsheet on-line help: separate window
- Support for Form Controls.
- Support for .NET 5 and .NET 6.
- Support for SVG pictures.
- Support for XLSX Digital Signature.
- Support for PDF/A.
GemBox.Spreadsheet 4.5
Release date: 2019-06-04 (blog post)
Support ended on: 2020-09-16
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- Support for PDF on Linux and macOS.
- Support for TextBoxes.
- Support for Progress Reporting and Cancellation.
- Support for .NET Core 3.0.
- Support for Right-to-Left languages.
- Support for Combo chart.
- Support for Chart formatting.
- Support for Shapes.
- Various calculation engine improvements and fixes.
GemBox.Spreadsheet 4.3
Release date: 2018-03-27 (blog post)
Support ended on: 2020-09-04
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- Support for Workbook protection.
- Support for Pivot table sorting.
- Support for Fraction number format.
- Support for inserting and removing cells.
- Support for Tables.
- Support for .NET Standard 2.0 or higher.
GemBox.Spreadsheet 4.1
Release date: 2016-09-27 (blog post)
Support ended on: 2019-06-28
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- Support for Excel cells formula calculation.
- Improved HTML engine with a support for external CSS.
- Improved help documentation.
- Fixed various other small issues and nuisances.
GemBox.Spreadsheet 3.9
Release date: 2014-12-23 (blog post)
Support ended on: 2017-12-26
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- Support for Pivot Tables.
- Support for AutoFilter.
- Support for In-line Text Formatting.
- Support for Conditional Formatting.
- Major overhaul of internal implementation and public API. As a result, memory consumption is lowered almost by half which means that you can load twice larger files than with previous versions.
- Complete rewrite of cell formatting code. Cell formatting API remains unchanged, but behavior is now identical to MS Excel's. For more details, see remarks of CellStyle type.
- New features in cell formatting:
- Theme colors.
- Gradient cell fills.
- Support for all workbook styles.
- Support for PDF encryption.
- Simplified API.
- Improved help documentation.
- Fixed various other small issues and nuisances.
GemBox.Spreadsheet 3.7
Release date: 2013-02-01 (blog post)
Support ended on: 2016-09-26
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- Write support for the:
- Adobe Portable Document Format (PDF),
- Microsoft XMP Paper Specification (XPS),
- Single File Web Page (MHTML),
- Image formats (BMP, GIF, JPEG, PNG, TIFF, WMP).
- Read and write support for the:
- Web Page (HTML),
- Fixed Columns Width Text.
- Support for printing.
- Support for XLSX encryption.
- Support for Charts (graphs).
- Included utility GemBox.Spreadsheet.WinFormsUtilities.dll for importing and exporting ExcelWorksheet to System.Windows.Forms.DataGridView control.
- Convert a spreadsheet to the XpsDocument and ImageSource (providing a means to embed a spreadsheet in WPF application with DocumentViewer and Image controls).
- Unification of Free and Professional versions. Easier performance evaluation.
- Simplified API.
- Improved help documentation.
- Fixed various other small issues and nuisances.
GemBox.Spreadsheet 3.5
Release date: 2011-07-27
Support ended on: 2014-11-02
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- Support for Medium Trust.
- 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.
GemBox.Spreadsheet 3.3
Release date: 2009-07-14
Support ended on: 2013-04-27
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- 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).
GemBox.Spreadsheet 3.1
Support ended on: 2011-04-14
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- 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).
GemBox.Spreadsheet 2.9
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- 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).
GemBox.Spreadsheet 2.7
Stand-alone help file: GemBox.Spreadsheet.Help.zip
GemBox.Spreadsheet on-line help: separate window
- 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:
- We changed name, “ExcelLite” is now called “GemBox.Spreadsheet”,
- DLL is now called “GemBox.Spreadsheet.dll”,
- Namespace is now “GemBox.Spreadsheet”,
- Due to many issues with MS control licensing, we no longer support licensing via licenses.licx file, we only support SetLicense() method,
- ExcelLite.SetLicense() is now called SpreadsheetInfo.SetLicense().