GemBox.Spreadsheet

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with rendering duplicate EMF image in PDF writer. Fixed issue with LINEST function. Added support for CORREL function. Added support for font fallback alias resolution on Linux. Fixed issue with font resolution for cell text. […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with invalid chart series reference in XLSX writer. Fixed issue with ISTEXT formula function in XLS writer. Fixed issue with CodeName and VBA module when cloning worksheet. Added support for PdfSaveOptions.UseAdvancedTextFormatting. Fixed issue with calculating […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Improved performance of criteria functions calculation. Fixed issue with missing cell style in SpreadsheetML reader. Fixed issue with SheetVisibility.VeryHidden in XLS reader. Fixed issue with weekday names for dates before 1 March 1900. Added support for calculating […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with relative reference in conditional formatting and rule order in XLS reader. Improved WPF rendering implementation. Added support for multiple ‘frame’ sheets from ‘frameset’ in HTML reader. Fixed issue with one cell references in XLS […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with ExcelCell.FormulaR1C1 value for single cell range. Fixed issue with ExcelWorksheet.FormControls with macros in XLSM reader. Fixed issue with axis tick labels position in XLSX reader. Fixed issue with preserving ActiveX control. Fixed issue with […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Added support for tabs and linebreaks in ODS reader. Fixed issue with relationship preservation when cloning ExcelFile. Fixed issue with inconsistent ‘=’ handling in Excel formulas. Fixed issue with preserving ActiveX alternative content. Fixed issue with ignored […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with ignored below milliseconds precision in DateTime values. Fixed issue with setting frozen panes with freezed rows. Fixed issue with array formula calculation with divide by zero error. You can download the latest version from […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with data validations from extension list overriding existing ones in XLSX reader. Added support for CalculationOptions.CalculationMode in XLSB files. Improved performance of rendering images. Fixed issue with chart axes positioning and automatic scale calculation. Fixed […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with combo chart that has only single series type in PDF writer. Added support for array formulas in XLS files. Fixed issue with unavailable metadata on streaming mode in XLSX reader. Added support for XlsxLoadOptions.CellCountLimit. […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Added support for ExcelWorksheet.CustomProperties. Fixed issue with auto-fitting emoji characters. Added cross-platform support for rendering SVG images. Added SkiaSharp.NativeAssets.Linux and HarfBuzzSharp.NativeAssets.Linux dependencies. Fixed issue with preserved chart in XLSX reader. Fixed issue with embedded “.bin” file that’s […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with ignored ImageSaveOptions.CropToContent in EMF writer. Fixed issue with printer specific paper size in PDF writer. Fixed issue with axis scaling for stacked charts. Fixed issue with invalid chart data labels cache in XLSX writer. […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with preserving defined name reference in charts. Fixed issue with overlapped chart axis labels in PDF writer. Fixed issue with duplicated form control hidden shapes in XLSX reader. Added support for ExcelCell.RichValue. Fixed issue with […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with theme color in XLSX reader. Fixed issue with shared items in pivot cache records. Added support for PaginatorOptions.UpdatePageBreaks. Fixed issue with ChartSeries.IsLegendEntryVisible. Fixed issue with alternate content in XLSX files. Fixed issue with ActiveX […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with default column formatting in XLSX reader. Added support for time number formats in ODS files. Fixed issue with culture dependant number values in XLSB writer. Added support for ExcelChart.RefreshCache method. Fixed issue with relative […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with missing chart markers in PDF writer. Fixed issue with array formulas in XLSB writer. Added support for ExcelWorksheet.TabColor in XLS files. Added support for PivotItems.Clear() method. Fixed issue with loading HarfBuzzSharp native assets on […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with auto fitting formatted DateTime value. Fixed issue with emoji characters in TableColumn.Name. Added support for PaperType.Tabloid. Added support for removing “XMP Toolkit” information in PDF writer. Fixed issue with AND evaluation if cell is […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Increased the SixLabors.ImageSharp version dependency. Added support for InvariantGlobalization in PDF writer. Fixed issue with cloned sheet in XLS writer. Fixed issue with changed font color in XLS files. Fixed issue with reading commnets from Strict Open […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with cache items on PivotCache.Refresh call. Fixed issue with comparing percentage value in calculation engine. Fixed issue with background color of preserved styles in XLS reader. Fixed issue with comparing mismatched types in calculation engine. […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with wrongly recognised date time format in XLS reader. Fixed issue with signed VBA in XLSM files. Fixed issue with buffer overrun in XLS reader. Fixed issue with print orientation being ignored. Fixed issue with […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Added support for ExcelPicture.Fill and ExcelPicture.Outline. Fixed issue with PdfSaveOptions.ImageDpi property. Fixed issue with using defined name as range for list data validation. Fixed issue with chart label overlap in PDF writer. Fixed issue with column width […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Improved performance of rendering process. Added support for FontSettings.FontSelection event. Fixed issue with calculating default column width with custom fonts. Added support for code name in XLS files. Fixed issue with chart interoperability. Fixed issue with missing […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Added support for DataValidation.GetListValues method. Added support for ExcelWorksheet.CalculateFormula method. Fixed issue with duplicate drawing ID in XLSX reader. Fixed issue with wrong chart axis positioning. Fixed issue with WPF Dispatcher multithreading resource (atom) leak. Added support […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Added support for ExcelGroupShape. Fixed issue with default font in ODS writer. Fixed issue with preserved embedded objects in XLSB files. Fixed issue with invalid defined name reference in XLSX writer. Fixed issue with incorrectly recognized shared […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with WPS Office showing warning on XLSX roundtrip. Fixed issue with merged cells that have rotated text in PDF writer. Fixed issue with VBA encoding. Added support for range result in logical functions. Added support […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with missing macros on Linux. Fixed issue with loading fonts on MAUI. Fixed issues with chart rendering in PDF writer: The wrong scatter chart marker shapes and thickness. The legend entry was missing. The wrong […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed issue with comparing string and double in calculation engine. Added support for cloning macros. Fixed issue with conditional formatting evaluation that has relative reference in a formula. Added support for PdfSaveOptions.Version. Fixed issue with checkbox position […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Added support for LineChartSeries.SmoothLine and ScatterChartSeries.SmoothLine. Fixed issue with calculating FILTER function. Fixed issue with cropped file name on external reference in XLSX files. Fixed issue with handling conditional formatting rule differential format in XLSX reader. Fixed […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed the issue with handling TextBox elements that contain links in XLSX writer. Fixed the issue with calculating the AND function with error values. Fixed the issue with updating formulas when sorting. Fixed the issue with calculating […]

We have released a new version of GemBox.Spreadsheet with the following list of features, improvements, and fixes included: Fixed the issue with missing items in XSeriesCollection when saving a combo chart to a JPEG image. Fixed the issue of changing a newline character as a data label separator during the XLSX roundtrip process. Fixed the […]

We have recently released new bug fixes for GemBox.Document, GemBox.Spreadsheet, and GemBox.Presentation components with support for export to images on non-Windows platforms. Here are some of the details of this feature. When using the GemBox component on a Windows operating system, the WPF is used for text layout, rasterizing content to a bitmap, and bitmap […]

We have updated all our APIs by adding support for nullable reference types. This is a C# feature that helps you minimize NullReferenceException occurrence in runtime by performing a null-state analysis. The feature is disabled by default for existing projects, but it is enabled for new .NET 6 projects. To enable it manually, just add […]

We have just released new bug fixes for GemBox components with lesser dependency on System.Drawing (GDI+). Over the last several months, we managed to isolate and restrict dependency on System.Drawing from our code for functionalities such as image handling, text measuring, printing, etc. Although GemBox components still reference System.Drawing (for backward compatibility), at runtime, we […]

We have released a new version of our spreadsheet component for easy and efficient spreadsheet automation in .NET without Microsoft Excel – GemBox.Spreadsheet 4.9. The following features were added: Reading and writing XLSB file format Pivot table evaluation Date axis support in Charts when saving to PDF, XPS, and image file formats Support for Excel […]

We tested all our office components (GemBox.Spreadsheet, GemBox.Document, GemBox.Presentation), and we can confirm that they work correctly on files generated by MS Office 2021. We also added new features that were introduced in MS Office 2021. We mainly extended our calculation engine by adding support for spilled array behavior, and the following functions: XLOOKUP XMATCH […]

With the recent release of .NET 5.0, we would like to inform you that GemBox components have been tested on the .NET 5.0 runtime. The behavior of GemBox components on the .NET 5.0 runtime should remain unchanged, however, .NET 5.0 introduced several breaking changes and we observed that the usage of ICU libraries on Windows […]

We have just released a new setup, help, and example for the GemBox.Spreadsheet 4.7 which supports the creation, editing and saving of SVG (Scalable Vector Graphics) images to XLSX, HTML, PDF, XPS, or image file formats. Images in SVG format are rendered in PDF files as vector graphics, resulting in a smaller file size and […]

We have released a new version of our spreadsheet component for easy and efficient spreadsheet automation in .NET without Microsoft Excel – GemBox.Spreadsheet 4.7. The biggest addition in this version is a support for PDF/A, the ISO-standardized version of the Portable Document Format (PDF) specialized for long-term archiving of electronic documents. For more details, go […]

We have just released a new setup, help, and examples for the GemBox.Spreadsheet 4.5 with the following features added: Text Boxes – you can now edit or render the textual content of a shape. Enhanced feature support when reading and writing to XLS file format. Following features are now fully or partially supported: Pictures In-line […]

We have just released a new setup, help, and examples for GemBox.Document 3.1, GemBox.Spreadsheet 4.5, GemBox.Presentation 2.3, and GemBox.Pdf 1.3 with the support for creating PDF files and paginating document content on Linux, macOS and other platforms that implement .NET Standard 2.0. Over the last several months we managed to remove dependency on WPF from […]

We have just released a new setup, help, and examples for the GemBox.Spreadsheet 4.5 with the following features added: Number format builder – You can use this class to create the most common number format strings. Progress reporting and cancellation – It is now possible to see the progress or cancel an operation when saving […]

Following Microsoft’s announcement of .NET Core 3.0, we have released new versions of GemBox .NET components compatible with .NET Core 3.0. With the release of .NET Core 3.0 support for Windows desktop applications (Windows only), GemBox.Document, GemBox.Spreadsheet, GemBox.Presentation and GemBox.Pdf .NET Core 3.0 components provide support for printing and writing to Adobe Portable Document Format […]

We have just released a new setup, help, and examples for the GemBox.Spreadsheet 4.5 with support for bidirectional texts when saving to PDF, XPS, or image file formats. This includes support for languages that use a right-to-left script such as Arabic, Persian, Urdu, Hebrew, or Yiddish. We also added support for customizing the direction of […]

We have just released a new setup, help, and examples for the GemBox.Spreadsheet 4.5, with the following features added or updated: Combo chart support – Added support for combination charts. Chart formatting – You can now set chart series color, plot area background fill, title font and format other chart components. Shapes – Work with […]

We have just released a new setup, help, and examples for the GemBox.Spreadsheet 4.3 with the following features added: Workbook protection – As well as protecting the content of a worksheet, it is now possible to protect the whole workbook structure, disabling to delete or rename a worksheet. Color depth and compression – It is […]

We have released a new version of our spreadsheet component for easy and efficient spreadsheet automation in .NET without Microsoft Excel – GemBox.Spreadsheet 4.3. New in GemBox.Spreadsheet 4.3: Added support for inserting and removing cells. Added support for Tables. Added support for .NET Standard 2.0 or higher. With support for .NET Standard 2.0, GemBox.Spreadsheet now […]

We have just released a new setup, help, and examples for GemBox.Spreadsheet 4.1 with a new HTML engine. This new engine has the following advantages: Full CSS style resolution. External CSS support. Support for CSS style selectors. Better HTML parsing. We hope that you like the new feature. If you have any questions, complaints, or […]

We have released a new version of our spreadsheet component for easy and efficient spreadsheet automation in .NET without Microsoft Excel – GemBox.Spreadsheet 4.1. New in GemBox.Spreadsheet 4.1: Added Calculation Engine. GemBox.Spreadsheet now supports cell formula calculation. You don’t need to reopen your files in Microsoft Excel to calculate cell values, just call ExcelCell.Calculate, ExcelWorksheet.Calculate […]

We have just released a new setup, help, and examples for GemBox.Document 2.5 and GemBox.Spreadsheet 3.9 with support for digital signatures in PDFs. For more information, see the digital signature in GemBox.Document and digital signature in GemBox.Spreadsheet examples. Other notable GemBox.Document improvements: Major refactoring of lists (numbered / bulleted). The internal implementation now supports all […]

We have just released a new setup, help and examples for GemBox.Spreadsheet 3.9 with following improvements: Added support for Conditional Formatting.Conditional Formatting is loaded from and saved to XLSX file format only.Conditional Formatting calculation is currently not supported. Added support for Pivot Tables.Pivot Tables are loaded from and saved to XLSX file format only.Pivot Table […]

We have just released a new setup, help and examples for GemBox.Spreadsheet 3.9 with following improvements: Added support for AutoFilter.Filtering can be applied regardless of input and output file format. Filtering settings is loaded from and saved to XLSX format only. Added support for In-line Text Formatting. Added support for sorting equal to that of […]

We have released a new version of our spreadsheet component for easy and efficient spreadsheet automation in .NET without Microsoft Excel – GemBox.Spreadsheet 3.9. New in GemBox.Spreadsheet 3.9: 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 […]

From December 24, 2014 we are discontinuing Site Wide License. There are few reasons for that: Lots of our users are distributed teams. Site Wide License which is tied to physical location doesn’t work for them. There were many situations where company has several locations so we had to make custom offer which includes several […]

We have just released a new setup, help, and examples for GemBox.Spreadsheet 3.7 with a support for Charts (graphs). Following charts are supported: Clustered Column, Stacked Column, 100% Stacked Column, Clustered Bar, Stacked Bar, 100% Stacked Bar, Line, Stacked Line, 100% Stacked Line, Area, Stacked Area, 100% Stacked Area, Pie. Charts are supported in XLSX, […]

For some time now we have been working on improving our support service and we have released a new GemBox Support Center. We have taken this initiative in order to improve our customer support, to simplify the process of feature requesting, to increase the available GemBox components resources and to enable our users to see […]

We have just released a new bug-fix, help and examples for GemBox.Spreadsheet 3.7 and GemBox.Document 2.3. GemBox.Spreadsheet 3.7 improvements: Added support for XLSX encryption. Improved print options: added support for PrintTicket stream. Improved quality of rendering metafiles (EMF, WMF) in PDF, XPS, image formats and printing. Fixed issues with DateTime formats which depend on operating […]

We have just released a new setup and help for GemBox.Spreadsheet 3.7 with the following improvements: Added support for reading HTML files. Added support for reading / writing Fixed Columns Width Text files. Improved Header / Footer API. Now it is easier to set left / center / right sections with various fields like page […]

We have just released a new setup and help for GemBox.Spreadsheet 3.7 and as promised before, this release includes major improvements of our PDF/XPS rendering engine. We have added support for fit to page and page scaling features, fixed issues with rendering merged cells, improved performance of font fallback strategy and fixed other minor issues. […]

We have released a new version of our spreadsheet component for easy and efficient spreadsheet automation in .NET without Microsoft Excel – GemBox.Spreadsheet 3.7. New in GemBox.Spreadsheet 3.7: Write support for the: Adobe Portable Document Format (PDF), Microsoft XML Paper Specification (XPS), Image formats (BMP, GIF, JPEG, PNG, TIFF, WMP). For more info, see GemBox.Spreadsheet […]

We have just released a new setup and help for GemBox.Spreadsheet 3.5 with the following new features: Support for getting formatted cell value based on a number format applied to the cell. Improved column auto-fitting and HTML export which now use formatted cell value. Added ASP.NET utility method which enables you to stream Excel file […]

From July 10, 2012 we are discontinuing 4 Developer License. There are few reasons for that: We hoped that more people will purchase multiple license packs if we give a big discount on additional licenses. This proved to be false, as majority of companies still purchases 1 Developer License although we had a big discount […]

We have refactored GemBox.Spreadsheet 3.5, so it no longer uses constructs that do not work in a medium trust environment. As a result, you can now use GemBox.Spreadsheet 3.5 in medium trust security level that is typical for applications hosted in cloud or shared-hosting servers. We have fully tested support for medium trust, but since […]

We’ve just released a new version of our spreadsheet component: GemBox.Spreadsheet 3.5. 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 […]

GemBox.Spreadsheet 3.3 now fully supports .NET Framework 4.0 and preservation of new Excel 2010 features. If using Free version, download the latest Free build. If using Professional version open SupportProfessional.htm in your Start Menu or GemBox install folder.