GemBox.Spreadsheet Downloads RSS Feed

On this page you can see GemBox.Spreadsheet release notes and download the binaries. This information is also available on NuGet NuGet .

Releases 2024

Date Notes Binaries
2024-12-05
  • 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 on Docker images without fonts.
  • Fixed issue with not updating formula reference from another worksheet.
  • Added support for ExcelFile.WriteProtectionSettings.
  • Added support for rendering SmartArt elements.
  • Added support for creating ExcelEmbeddedObject.
  • Fixed issue with line chart clipping in PDF writer.
  • Fixed issue with chart axis label wrapping in PDF writer.
 GemBox.Spreadsheet
49.0.1895.zip
2024-11-04
  • 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 digital signature in XLSX writer.
  • Fixed issue with font face in ODS reader.
  • Fixed issue with IF function.
  • Fixed issue with FormatConditionType.IconSet in XLSX writer.
  • Fixed issue with incorrect sorted values from DataValidation.GetListValues.
  • Added support for background image in chart.
 GemBox.Spreadsheet
49.0.1858.zip
2024-10-08
  • 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 for WpfHelper class.
  • Fixed issue with custom number format that uses indexed color.
  • Fixed issue with sheet deleting in XLS file.
  • Added support for exporting 'Picture in Cell' in DataGridView.
  • Fixed issue with disabled 'Insert Slicer' action in Microsoft Excel.
  • Fixed issue with preserving custom properties when copying XLSB file.
  • Added support for IMAGE function.
 GemBox.Spreadsheet
49.0.1839.zip
2024-09-05
  • 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 formula.
  • Fixed issue with form control position in PDF writer.
  • Fixed issue with circular reference in XLSB writer.
  • Fixed issue with accessing CellRange.Comment and CellRange.Hyperlink on merged range.
  • Added support for DataPoint.Value, DataPoint.NumericValue, and DataPoint.Text.
  • Added support for DataPointCollection.Count.
  • Added support for ExcelDrawingCollection.BringForward, ExcelDrawingCollection.SendBackward, and ExcelDrawingCollection.MoveZIndex.
  • Added support for ExcelDrawing.ZIndex.
 GemBox.Spreadsheet
49.0.1822.zip
2024-08-13
  • 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 for Pie and Doughnut chart plot area resizing with labels.
  • Fixed issue with rendering custom shape in PDF writer.
  • Fixed issue with invalid manifest content in ODS writer.
  • Fixed issue with drawing position in XLSX reader.
  • Fixed issue with invalid external reference in XLSX reader.
  • Fixed issue with formula functions on XLSB roundtrip.
  • Added support for resampling metafile images.
  • Added support for ExcelPicture.CameraRangeFormula and ExcelPicture.CalculateCameraRange().
 GemBox.Spreadsheet
49.0.1799.zip
2024-07-05
  • Fixed issue with missing macros on Linux.
  • Fixed issue with loading fonts on MAUI.
  • Fixed issues with chart rendering in PDF writer.
  • Fixed issue with not removing TableRow from Table.
  • Fixed issue with ZIP entries in ODS writer.
  • Fixed issue with wildcard criteria function that uses nonequal sign.
  • Added support for writing number format for number reference values in charts.
 GemBox.Spreadsheet
49.0.1767.zip
2024-06-07
  • Fixed issue with comparing string and double in calculation engine.
  • Added support for cloning macros.
  • Fixed issue with conditional formatting evaluation.
  • Added support for PdfSaveOptions.Version.
  • Fixed issue with checkbox position and size in PDF writer.
  • Added support for range and intersection expressions in formulas.
  • Fixed issue with percentage data label for NaN values in PDF writer.
  • Fixed issue with spilling formula.
  • Added support for ROWS and COLUMNS functions.
  • Fixed issue with UNIQUE function.
  • Added support for SEQUENCE function.
  • Fixed issue with missing VBA records in XLSM reader.
 GemBox.Spreadsheet
49.0.1737.zip
2024-05-07
  • 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 conditional formatting rule differential format in XLSX reader.
  • Fixed issue with defined names and external references in XLSB reader.
  • Fixed issue with copying nameless cell style.
  • Fixed issue with form control being recognized as image in XSLM files.
  • Fixed issue with missing JPEG image in sheet header.
  • Fixed issue with not updating formulas when copying cell range.
  • Added support for ChartDataLabels.LabelContainsPercentage in PDF writer.
  • Added support for Doughnut charts.
 GemBox.Spreadsheet
49.0.1697.zip
2024-04-06
  • Fixed issue with TextBox elements that contain links in XLSX writer.
  • Fixed issue with calculating AND function with errors.
  • Fixed issue with updating formulas when sorting.
  • Fixed issue with calculating ROW, COLUMN, and TEXTJOIN functions.
  • Fixed issue with encoding of VBA module names in XLSM reader.
  • Fixed issue with shared formulas that have absolute references in XLSX reader.
  • Fixed issue with clipping of shape edges in PDF writer.
  • Fixed issue with preserved volatile dependencies.
  • Improved performance of readers and writers for XLSX and ODS files.
  • Added support for custom chart positioning.
 GemBox.Spreadsheet
49.0.1655.zip
2024-03-04
  • Fixed issue with rendering combo chart.
  • Fixed issue with newline characters as data labels separator in XLSX files.
  • Fixed issue with cropped content in PNG writer.
  • Fixed issue with missing chart series values in PDF writer.
  • Fixed issue with position of secondary axis legend in PDF writer.
 GemBox.Spreadsheet
49.0.1623.zip
2024-02-13
  • Added support for automatic formula update when sorting cells.
  • Improved image DPI decoding and image options encoding.
  • Added support for preserving worksheet's custom properties in XLSX files.
  • Fixed issue with resolving deleted chart series data lables.
  • Fixed issue with missing chart series values.
  • Fixed issue with missing formula values in XLS writer.
  • Fixed issue with incorrect pivot field name in XLSX reader.
 GemBox.Spreadsheet
49.0.1612.zip
2024-01-15
  • Fixed issue with column-only shared formulas.
  • Fixed issue with not escaping sheet names that start with number.
  • Added support for ANCHORARRAY function.
  • Fixed issue with filtered series index in combo chart.
  • Added support for cropped SVG in PDF writer.
  • Fixed issue with missing space on sheet's footer in PDF writer.
  • Fixed issue with rendering raster image inside SVG with and without DPI setting.
  • Added support for chart axis label rotation.
 GemBox.Spreadsheet
49.0.1586.zip

Releases 2023

Date Notes Binaries
2023-12-08
  • Added support for PaginatorOptions.ProgressChanged event.
  • Added cross-platform support for saving to TIFF and BMP formats.
  • Fixed issue with extra spaces in formulas that have external references.
  • Fixed issue with updating named ranges when renaming worksheet.
  • Improved performance of rendering SVG images in PDF writer.
 GemBox.Spreadsheet
49.0.1562.zip
2023-11-16
  • Fixed issue with font fallback on Linux.
  • Fixed issue with invalid external reference target in XLSX reader.
  • Fixed issue with named ranges when renaming worksheet.
  • Fixed issue with invalid defined name in XLSX reader.
  • Fixed issue with removing macros in XLSX writer.
  • Added support for VbaProject.Delete method.
  • Added support for ExcelPicture.Transparency property.
  • Fixed issue with relative area reference in XLSB files.
  • Fixed issue with formulas that have external references in XLSX writer.
  • Added cross-platform support for saving to image formats.
 GemBox.Spreadsheet
49.0.1542.zip
2023-10-21
  • Fixed issues with preserving pivot table options in XLSX writer.
  • Added support for ExcelFormControl.Print property.
  • Fixed issue with automatic formula update in merged cells.
  • Fixed issue with missing datalabels on combo charts in PDF writer.
  • Fixed issue with rendering background color of merged cells.
  • Added support for XlsbLoadOptions.StreamingMode property.
  • Added support wildcard parameters in SEARCH function.
  • Fixed issue with missing merged cells borders in XML reader.
  • Fixed issue with invalid date properties in XML reader.
  • Added support for preset and custom geometries in PDF writer.
  • Fixed issue with self referencing defined names.
 GemBox.Spreadsheet
49.0.1509.zip
2023-09-05
  • Added support for saving to SVG.
  • Fixed issue with empty chart data label styles in XLSX writer.
  • Fixed issue with matching typeface on MAUI Android.
  • Fixed issue with PivotField.RepeatItemLabels being ignored.
  • Fixed issue with corrupted content in XLSB writer.
  • Fixed issue with defined names that have external references.
  • Fixed issue with cell background when text is overflowing in PDF writer.
  • Fixed issue with links to empty cells in PDF writer.
  • Fixed issue with formulas having invalid reference after column shift.
 GemBox.Spreadsheet
49.0.1454.zip
2023-08-04
  • Added support for optimized chunk size in streamlined loading.
  • Fixed issue with resolving math functions using CalculationOptions.ResolveMathFunctionsWithDecimalType.
  • Fixed issue with MAXIFS and MINIFS functions in XLSX writer.
  • Added support for DefinedName.Hidden.
  • Fixed issue with macro's encoding in XLSM reader.
  • Fixed issue with defined name formula in XLSB reader.
  • Fixed issue with chart update on worksheet's renaming.
  • Fixed issue with duplicate defined names with external references in XLSX reader.
  • Fixed issue with scatter chart series without shape data in XLSX reader.
 GemBox.Spreadsheet
49.0.1423.zip
2023-07-07
  • Fixed issue with duplicate conditional formattings in XLSX reader.
  • Added support for percent stacked charts in PDF writer.
  • Fixed issue with scatter chart in XLSX writer.
  • Added support for TEXTSPLIT function.
  • Added support for HeaderFooter fields of FileName and FilePath type in PDF writer.
  • Added support for chart update when rows or columns are inserted or removed.
  • Fixed issue with external defined names losing reference to original external file.
  • Added support for DefinedNameCollection.AddCopy.
  • Added support for CalculationOptions.CalculationMode.
  • Fixed issue with copying chart style.
 GemBox.Spreadsheet
49.0.1398.zip
2023-06-12
  • Fixed issue with metadata in XLSX writer.
  • Fixed issue with references mapping in array functions.
  • Fixed issue with VLOOKUP function calculation.
  • Fixed issue with emtpy text in NUMBERVALUE function.
  • Fixed issue with wrong chart plot area color in PDF writer.
  • Added support for preserving hidden defined names.
  • Fixed issue with INDIRECT function calculation.
  • Fixed issue with ROUNDUP and ROUNDDOWN precision.
  • Added support for ExcelFormControl.FormControlType.
  • Fixed issue with cell wrapping and column width in HTML reader.
  • Added support for ExcelDrawingMetadata.Description and ExcelDrawingMetadata.Title.
  • Added support for chart secondary axis.
  • Fixed issue with PRODUCT function calculation.
  • Added support for exteranal link in XLSB reader.
 GemBox.Spreadsheet
49.0.1379.zip
2023-05-10
  • Fixed issue with INDEX function.
  • Added support for ConditionalFormatRuleCollection.Clear method.
  • Fixed issue with whitespace on line ending in PDF writer.
  • Fixed issue with default shape style.
  • Fixed issue with VBA macros in XLSM writer.
  • Fixed issue with cloning chart's data labels.
  • Fixed issue with SUBSTITUTE function calculation.
  • Fixed issue with NUMBERVALUE function calculation.
  • Fixed issue with invalid records in XLSB reader.
  • Fixed issue with unresolved defined name in the formula.
  • Added support for ExcelCell.FormulaRange property.
  • Added support for shared formulas in XLSB reader.
 GemBox.Spreadsheet
49.0.1335.zip
2023-04-05
  • Fixed issue with calculating empty formulas.
  • Improved quality and reduced size of rendered images.
  • Fixed issue with incorrect built-in date format.
  • Fixed issue with multithreading in HTML reader.
  • Fixed issue with implied number format in XLS reader.
  • Fixed issue with formatting numbers between 0 and 1 using general format.
  • Fixed issue with double value's trim on calculation engine.
  • Added support for NumberFormatBuilder.IsDateTime method.
  • Fixed issue with binary expressions using CalculationOptions.ResolveMathFunctionsWithDecimalType.
  • Fixed issue with formatting calculated value with date format.
 GemBox.Spreadsheet
49.0.1301.zip
2023-03-10
  • Fixed issue with table cell breaking into lines in HTML writer.
  • Fixed issue with private memory fonts in Medium Trust.
  • Added support for CellRange.FindAllText methods.
  • Added support for column groups in HTML reader.
  • Fixed issue with defined names in calculation engine.
  • Fixed issue with font resolution on Blazor WASM in PDF writer.
  • Fixed issue with renaming sheets in XLS file.
  • Fixed issue with unrecognized error value in cell without formula.
  • Fixed issue with ADDRESS function calculation.
  • Fixed issue with setting total row on existing table.
 GemBox.Spreadsheet
49.0.1274.zip
2023-02-03
  • Fixed issue with array formulas in XLSX writer.
  • Fixed issue with unsupported sheet type in XLS reader.
  • Fixed issue with invalid entry names that used backslash in XLSX reader.
  • Fixed issue with WPF Dispatcher handler.
  • Fixed issue with preserving chart trendlines.
  • Fixed issue with external reference in XLS reader.
  • Fixed issue with MATCH function calculation.
  • Fixed issue with missing images in Document Viewer after Windows update from December 2022.
 GemBox.Spreadsheet
49.0.1244.zip
2023-01-03
  • Fixed issue with MROUND function calculation.
  • Added support for SINGLE function.
  • Fixed issue with XLSM reader on Linux.
  • Fixed issue with DateTime cell values on .NET 7.
  • Added support for ExcelCell.SetArrayFormula and ExcelCell.SetDynamicArrayFormula methods.
 GemBox.Spreadsheet
49.0.1225.zip

Releases 2022

Date Notes Binaries
2022-12-14
  • Added partial support for LINEST function.
  • Added support for NUMBERVALUE, UNICODE and TRANSPOSE functions.
  • Added support for FORECAST and FORECAST.LINEAR functions.
  • Fixed issue with chart titles that have newlines in XLSX reader.
  • Fixed issue with converting from A1 to R1C1 notation.
  • Fixed issue with TextField elements that have newlines in XLSX reader.
  • Added support for PEARSON and RSQ functions.
  • Added support for PivotTable.DataRange property.
  • Fixed issue with missing font record in XLS reader.
  • Fixed issue with ignored casing when validating list DataValidation.
  • Added support for macros with ExcelFile.VbaProject.
  • Fixed issue with PivotTable location in XLSX files.
  • Fixed issue with losing filter on Table when rows/columns are inserted/removed.
 GemBox.Spreadsheet
49.0.1202.zip
2022-11-09
  • Added support for TableRow.
  • Fixed issue with losing inline formatted text when merging cells.
  • Added support for DataValidation.Validate.
  • Improved performance of PivotCacheCollection.AddWorksheetSource.
  • Fixed issue with inline formatted chart titles.
 GemBox.Spreadsheet
49.0.1153.zip
2022-10-12
  • Added support for CellRange.CopyTo with CopyOptions.
  • Added support for ChartTitle.CharacterRanges.
  • Fixed issue with replacing inline formatted cell text with empty value.
  • Fixed issue with missing background color in HTML reader.
  • Fixed issue with duplicate references in XLSX writer.
  • Added support for automatic update of shape and chart positions when rows/columns are inserted/removed.
  • Improved IRR calculation with new Newton-Raphson implementation.
  • Added support for CellValueType.Error.
  • Fixed issue with invalid digital signature on Microsoft Excel 2016.
  • Fixed issue with duplicate drawing that's anchored to merged cell in PDF writer.
  • Fixed issue with date category labels in XLSX writer.
  • Improved performance of HTML reader.
  • Fixed issue with parsing multi level category labels.
 GemBox.Spreadsheet
49.0.1127.zip
2022-09-06
  • Added support for detecting encrypted XLSX files in ExcelFile.Load(Stream).
  • Fixed issue with font color in PDF writer.
  • Improved performance of conditional formatting evaluation.
  • Fixed issue with changed format when shrinking images via ImageDpi setting.
  • Fixed issue with digital signature objects in XLSX writer.
 GemBox.Spreadsheet
49.0.1103.zip
2022-08-12
  • Fixed issue with cell style performance in HTML reader.
  • Added support for DocumentProperties.ContentType collection.
  • Fixed issue with form controls in HTML writer.
  • Fixed issue with rendering user's file that has an empty sheet.
  • Fixed issue with huge metafiles when scale factor is 1 in PDF writer.
  • Added support for LengthUnit.CharacterWidth and LengthUnit.DevicePixel.
  • Removed GDI+ dependencies.
 GemBox.Spreadsheet
49.0.1084.zip
2022-07-21
  • Fixed issue with header position in PDF writer.
  • Fixed issue with default cell styles in ODS reader.
  • Added support for SWITCH function.
  • Fixed issue with reading minified HTML reading issues.
  • Added support for using formula as print area.
  • Added support for MROUND function.
  • Fixed issue with invalid external references in XLSX reader.
 GemBox.Spreadsheet
49.0.1067.zip
2022-06-10
  • Fixed issue with removing pivot table from worksheet.
  • Added support for FREQUENCY and CONFIDENCE functions.
  • Fixed issue with carriage return in header text in XLS writer.
  • Fixed issue with rendering drawings that are partially inside print area.
  • Fixed issue with rendering merged cell borders in PDF writer.
  • Fixed issue with missing cell style in HTML reader.
  • Fixed issue with default format being applied to shapes that have no style.
  • Fixed issue with encoded square brackets in table column name.
  • Added support for HtmlLoadOptions.InheritCellStyle.
 GemBox.Spreadsheet
49.0.1039.zip
2022-05-16
  • Added support for XML Spreadsheet 2003.
  • Fixed issue with Emoji characters in XLSX writer.
  • Improved performance of pivot cache refreshing.
  • Fixed issue with criteria functions in calculation engine.
  • Fixed issue with invalid worksheet panes in XLS reader.
  • Added support for preserving cell metadata information in XLSX files.
 GemBox.Spreadsheet
49.0.1017.zip
2022-04-21
  • Added support for XLSB format.
  • Added support for PivotTable calculation.
  • Fixed issue with chart's direct category labels in XLSX writer.
  • Fixed issue with borders on merged ranges in XLS reader.
  • Fixed issue with XlsxLoadOptions.IsEncrypted method.
  • Fixed issue with font handling on Microsoft Dynamics 365 in PDF writer.
  • Fixed issue with loading system fonts on Android in PDF writer.
  • Fixed issue with conditional formatting evaluation.
  • Added support for ExcelChart.ShowDataInHiddenCells.
  • Fixed issue with rendering cell content that occupies beyond the visible columns.
  • Fixed issue with PivotTable that has external data source.
  • Fixed issue with auto-fitting max DateTime value.
 GemBox.Spreadsheet
49.0.1000.zip
2022-03-09
  • Fixed issue with insufficient byte size in XLS reader.
  • Fixed issue with comparing int and double in calculation engine.
  • Fixed issue with fully linked Xamarin builds.
  • Added default CsvLoadOptions.DateTimeFormats and HtmlLoadOptions.DateTimeFormats.
  • Fixed issue with misinterpreted dates in CSV reader.
 GemBox.Spreadsheet
47.0.1418.zip
2022-02-01
  • Added support for rendering line endings.
  • Added support for ChartAxis.TextBoxFormat property.
  • Added support for page breaks when calculating PivotTable.
  • Added support for CellRange.Subtotal method.
  • Added support for optimized streamlined loading in CSV reader.
  • Added support for DateTime values in CSV and HTML readers.
  • Added support for CsvSaveOptions.QuoteMode property.
  • Fixed issue with IF function calculation.
  • Fixed issue with borders on merged cells in PDF writer.
  • Fixed issue with scatter charts in PDF writer.
  • Fixed issue with ZIP64 header in XLSX writer.
  • Merged DataGridViewConverter into GemBox.Spreadsheet library.
  • Added support for Excel 2021 functions.
  • Added support for rendering date axis.
 GemBox.Spreadsheet
47.0.1398.zip
2022-01-05
  • Added support for optimized streamlined loading in XLSX reader.
  • Fixed issue with deleting sheet that has printer settings.
  • Fixed issue with uninherited Normal style in XLS reader.
  • Fixed issue with missing prefix spaces in formulas.
  • Added support for layout page break option in pivot fields.
  • Added support for tables without headers.
  • Fixed issue with non-standard shared strings in XLSX reader.
 GemBox.Spreadsheet
47.0.1363.zip

Releases 2021

Date Notes Binaries
2021-12-07
  • Added support for PivotTable.Calculate and PivotCache.Refresh.
  • Added support for GETPIVOTDATA function.
  • Fixed issue with threaded comments in XLSX writer.
  • Fixed issue with default row height in PDF writer.
  • Fixed issue with unparsed cell numbers in HTML reader.
  • Added support for WorkbookProtection.HasPassword property.
  • Fixed issue with duplicate external references in XLSX reader.
  • Fixed issue with ActiveX control preservation.
  • Fixed issue with invalid worksheet panes in XLS reader.
  • Fixed issue with images on non-Windows platforms in PDF writer.
 GemBox.Spreadsheet
47.0.1345.zip
2021-11-05
  • Fixed issue with hiding active worksheet.
  • Added support for form controls with named range source.
  • Fixed issue with custom icons in conditional formatting.
  • Added support for NORMDIST function.
  • Fixed issue with form control ids in XLSX writer.
  • Improved quality of metafile images (EMF and WMF) rasterization.
  • Fixed issue with VML drawings missing anchor in XLSX reader.
  • Fixed issue with number data types in XLS reader.
 GemBox.Spreadsheet
47.0.1321.zip
2021-10-01
  • Added support for default language in ODS files.
  • Fixed issue with ChartDataLabels data inheritance.
  • Added support for UNIQUE function.
  • Fixed issue with invalid comments and processing instructions in HTML reader.
  • Added support for data-point level formatting.
  • Added support for form controls in PDF writer.
  • Added support for lists in HTML reader.
  • Added support for ExcelComment.ParentCell property.
  • Fixed issue with TextAutoFit.ResizeShapeToFitText in XLSX writer.
  • Added support for CategoryAxis.MultiLevelLabels property.
  • Added support for ComHelper.AddPageBreak method.
  • Fixed issue with missing data bar conditional formatting settings.
 GemBox.Spreadsheet
47.0.1298.zip
2021-08-26
  • Added support for PivotField.RepeatItemLabels property.
  • Fixed issue with file links in PDF writer.
  • Fixed issue with invalid external reference in XLSX reader.
  • Added support for cell comments in HTML format.
  • Added support for TEXTJOIN function.
  • Fixed issue with pivot field that has invalid base field in XLSX reader.
 GemBox.Spreadsheet
47.0.1268.zip
2021-07-14
  • Fixed issue with table reference whose column name starts with hashtag.
  • Fixed issue with cloning chart sheets.
  • Added support for SMALL and CONCAT functions.
  • Fixed issue with losing smooth lines when cloning chart.
  • Fixed issue with external references to local files.
 GemBox.Spreadsheet
47.0.1248.zip
2021-06-17
  • Fixed issue with naming chart style parts in XLSX writer.
  • Added support for east Asian number format codes.
  • Added support for naming print job.
  • Fixed issue with chart's crossesAt preservation.
  • Added support for number formats with fill space character in PDF writer.
  • Fixed issue with cloning shapes and pictures.
  • Fixed issue with pane's top row in XLS reader.
  • Added support for HYPERLINK function.
  • Added support for error strings inside formulas.
 GemBox.Spreadsheet
47.0.1230.zip
2021-05-14
  • Added support for Form Controls.
  • Added support for CSS 'var' function in HTML reader.
  • Fixed issue with DateTime and TimeSpan arithmetic calculation.
  • Fixed issue with rounded milliseconds in formatted date value.
  • Fixed issue with missing chart category label name.
  • Fixed issue with corrupt image in XLS reader.
  • Added support for preserving phonetic information in XLSX files.
  • Added support for RTL sheets in HTML writer.
  • Fixed issue with comments default size.
  • Improved performance of AutoFit methods.
  • Added support for SLOPE and INTERCEPT functions.
  • Fixed issue with "#VALUE!" formula in ODS reader.
 GemBox.Spreadsheet
47.0.1207.zip
2021-04-20
  • Added support for ExcelCell.FormulaR1C1 getter.
  • Added support for WorksheetProtection.HasPassword.
  • Fixed issue with lookup functions that use defined names.
  • Fixed chart data label inheritance.
  • Fixed issue with view panes in ODS reader.
  • Added support for shape styles.
  • Fixed issue with unordered page breaks.
  • Added support for IFNA and DAYS360 functions.
  • Fixed issue with duplicate styles in ODS reader.
  • Fixed issue with external references from chart series in XLSX reader.
  • Fixed issue with wrapped rotated cells in PDF writer.
  • Fixed issue with rendering hidden TextBox elements.
  • Fixed issue with external references of zero index in XLSX reader.
 GemBox.Spreadsheet
47.0.1170.zip
2021-03-09
  • Fixed issue with icon conditional formatting in XLSX reader.
  • Fixed issue with worksheet view panes in XLSX and ODS writers.
  • Fixed issue with data bar evaluation in PDF writer.
  • Fixed issue with date values in XLS reader.
  • Added support for Japanese era datetime format.
  • Added support for autofitting comments.
  • Fixed issue with tables that have incorrect filter range.
  • Added support for setting ExcelPrintOptions.PaperType to Custom.
  • Added support for reading Strict Open XML Spreadsheet format.
 GemBox.Spreadsheet
47.0.1129.zip
2021-02-03
  • Added support for .NET 5.
  • Added support for rendering shapes with rounded corners.
  • Fixed issue with paper size in XLSX reader.
  • Fixed issue with implicitly created WPF Dispatcher.
  • Fixed issue with relative reference in formula of conditional formatting.
  • Fixed issue with copying defined names.
  • Fixed issue with criteria functions comparison of different value types.
  • Added support for SVG pictures.
  • Added support for cloning workbook.
  • Fixed issue with column names when creating DataTable from sheet.
  • Added support for IPMT, PPMT, FV, and OFFSET functions.
  • Added support for calculating array formulas.
 GemBox.Spreadsheet
47.0.1095.zip
2021-01-12
  • Fixed issue with missing text when cloning shape.
  • Fixed issue with negative height of shape in HTML and PDF writer.
  • Fixed issue with regular expressions warning from Microsoft Excel in ODS writer.
  • Added support for XLS decryption with XlsLoadOptions.Password.
  • Fixed issue with creating invalid WorksheetPanes.
  • Added support for chart category labels formatting in PDF writer.
  • Fixed issue with viewing XpsDocument in DocumentViewer control on .NET Core.
  • Fixed issue with duplicate drop down control in XLSX writer.
 GemBox.Spreadsheet
47.0.1071.zip

Releases 2020

Date Notes Binaries
2020-12-02
  • Fixed issue with chart data labels in XLSX reader.
  • Added support for elapsed time formats.
  • Improved performance of lookup functions evaluation.
  • Added partial support for OFFSET function.
  • Added support for CalculationOptions.CultureInfo.
  • Added support for calculating arithmetic operations with DateTime values.
  • Added support for MAXIFS and MINIFS functions.
  • Fixed issue with reading font files on Xamarin.
  • Added support for formula and chart update when changing worksheet's name.
 GemBox.Spreadsheet
47.0.1044.zip
2020-11-09
  • Added support for digital signatures in XLSX files.
  • Fixed issue with scatter chart when X axis values are not numbers.
  • Added support for preserving pivot cache field shared items.
  • Fixed issue with table column names that have leading and trailing whitespace.
  • Improved performance of criteria functions evaluation that have whole column reference.
  • Fixed issue with invalid DPI values in XLSX reader.
  • Fixed issue with pictures opacity in PDF writer.
  • Added support for IFS function.
  • Fixed issue with reading XLSX files on iOS.
  • Added support for ExcelCell.FormulaR1C1 property.
  • Fixed issue with filters on table creation.
  • Fixed issue with digitally signing PDF files with 2 SmartCards in reader.
 GemBox.Spreadsheet
47.0.1029.zip
2020-10-16
  • Added support for XMATCH function.
  • Fixed issue with rendering text frame with hidden geometry in PDF writer.
  • Added support for DOLLAR PROPER function.
  • Added support for PROPER function.
  • Fixed issue with missing pivot cache field options in XLSX files.
  • Fixed issue with invalid row options in XLSX reader.
  • Added support for adding and removing filter on Table.
  • Fixed issue with invalid chart data point indexes.
  • Fixed issue with external references in XLSX writer.
  • Improved performance of conditional formatting formula evaluation.
 GemBox.Spreadsheet
47.0.1013.zip
2020-09-16
  • Added support for saving to PDF/A.
 GemBox.Spreadsheet
47.0.1000.zip
2020-09-08
  • Fixed issue with finding Win32 font family in PDF writer.
  • Fixed issue with conditional formatting formula evaluation.
  • Fixed issue with chart data labels resolution.
  • Added support for PivotField.ShowDataAs extension values.
  • Added support for flip and rotation of shapes.
  • Fixed issue with table removal.
  • Fixed issue with removed end quote from number format in HTML reader.
  • Fixed issue with invalid external references in XLSX reader.
  • Added support for CsvSaveOptions.UseFormattedValues.
  • Added support for CsvLoadOptions.HasFormulas.
 GemBox.Spreadsheet
45.0.1225.zip
2020-08-06
  • Fixed issue with copying data validation and conditional formatting from source cell range.
  • Added support for ExcelChart.RoundedCorners.
  • Added support for NETWORKDAYS function.
  • Fixed issue with CSS rgba() function in HTML reader.
  • Fixed issue with copying merged cell with borders.
  • Fixed issue with large sheet name in ODS reader.
  • Fixed various issues with chart writer.
  • Added support for CreateDataTableOptions.ColumnHeadersComparer.
 GemBox.Spreadsheet
45.0.1206.zip
2020-06-26
  • Added support for R1C1 references.
  • Fixed issue with saving to PDF in Medium Trust application.
  • Added support for ZIP64 extensions in XLSX writer.
  • Fixed issue with exporting TextBoxes in HTML writer.
  • Added support for chart labels with values from cells.
  • Fixed issue with copying inline formatted text from merged cell.
  • Improved performance of writing many images in Excel files.
 GemBox.Spreadsheet
45.0.1187.zip
2020-05-22
  • Fixed an issue with chart series data label value resolution.
  • Fixed issues with saving to PDF on Alpine Linux.
  • Improved performance of PDF writer by up to 60%.
  • Added support for progress reporting and cancellation in PDF and image writers.
  • Fixed issue with updating table reference indexes.
  • Added support for evaluating and exporting conditional formatting.
  • Added support for exporting image metadata as XMP metadata stream in PDF image object.
  • Fixed issue with copying inline formatted text from one cell to another.
  • Fixed issue with assembly binding by unifying DLL version numbers for different platforms.
  • Fixed issue with updating conditional formatting formula.
  • Fixed issue with running .NET Standard version on Xamarin.
  • Added support for ExcelFile.GetPaginator.
  • Fixed issue with invalid formula containing external references in XLSX reader.
  • Added support for transparent color in chart rendering.
  • Added support for saving to HTML on .NET Standard.
  • Added support for AutoFit on .NET Standard.
  • Added support for copying data validation and conditional formatting from source cell range.
  • Improved support for XLS format.
 GemBox.Spreadsheet
45.0.1176.zip
2020-04-09
  • Added support for XlsxLoadOptions.IsEncrypted.
  • Added support for XLOOKUP function.
  • Fixed issue with SystemColor on Azure Functions.
  • Fixed issue with external references in defined names.
  • Fixed issue with fill and border color that has transparency in PDF writer.
  • Fixed various issues with XLS reader.
  • Fixed issue with order of processing page directive in HTML reader.
 GemBox.Spreadsheet
45.0.1148.zip
2020-03-16
  • Added cross-platform support for saving to PDF.
  • Fixed issue with shapes that have 0 height in HTML writer.
  • Fixed issue with external references in XLSX files.
  • Improved writing of merged range borders.
  • Fixed various issues with XLS files.
  • Fixed issue with automatic horizontal X axis tick labels rotation.
  • Fixed issue with chart dot markers and category labels interval.
  • Added support for chart series data points.
  • Added support for ExcelCell.ConvertDateTimeToExcelNumber helper method.
  • Added support for 'mso-number-format' in HTML files.
 GemBox.Spreadsheet
45.0.1131.zip
2020-02-10
  • Added support for TextBox elements.
  • Fixed issue with DATEVALUE function.
  • Added support for preserving ODS common styles.
  • Fixed issue with table column names containing '\r' character.
  • Fixed issue with unquoted sheet names that can be A1 or R1C1 notation.
 GemBox.Spreadsheet
45.0.0.1094.zip
2020-01-08
  • Fixed issue with shared items reference in pivot field.
  • Added support for progress reporting and cancellation in XLSX reader and writer.
  • Added support for formula and chart update when cloning worksheet.
  • Fixed issue with table reference formula evaluation.
  • Fixed various issues with setting cell's value using HTML content.
  • Fixed issue with combo chart axis rendering in PDF writer.
  • Added basic support for number formats in ODS writer.
  • Added support for replacing cell text with Regex.
  • Added support for ExcelPicture.TransparentColor.
  • Added NumberFormatBuilder utility class.
 GemBox.Spreadsheet
45.0.0.1084.zip

Older Releases

Version Help Setup Binaries
GemBox.Spreadsheet 4.3 GemBox.Spreadsheet 4.3 Help GemBox.Spreadsheet.Setup
43.0.0.1140.msi		 GemBox.Spreadsheet
43.0.0.1140.zip
GemBox.Spreadsheet 4.1 GemBox.Spreadsheet 4.1 Help GemBox.Spreadsheet.Setup
41.3.30.1183.msi		 GemBox.Spreadsheet
41.3.30.1183.zip
GemBox.Spreadsheet 3.9 GemBox.Spreadsheet 3.9 Help GemBox.Spreadsheet.Setup
39.3.30.1215.msi		 GemBox.Spreadsheet
39.3.30.1215.zip
GemBox.Spreadsheet 3.7 GemBox.Spreadsheet 3.7 Help GemBox.Spreadsheet.Setup
37.3.30.1189.msi		 GemBox.Spreadsheet
37.3.30.1189.zip

How to install

NuGet Package

If you're using GemBox.Spreadsheet.dll as package, then run the following command in NuGet Package Manager Console:

Update-Package GemBox.Spreadsheet

Private Assembly

If you're referencing GemBox.Spreadsheet.dll from some folder, then download the latest ZIP available above, and unpack it inside that folder.

Global Assembly

If you installed GemBox.Spreadsheet Setup and you're referencing GemBox.Spreadsheet.dll from Global Assembly Cache (GAC), then download and install the latest GemBox.Spreadsheet.Setup.msi.