Bug Fixes

On this page you can download the latest fixes for GemBox.Spreadsheet.

You can also download these versions from NuGet.

Subscribe to the Bug Fixes Subscribe to the BugFixes RSS Feeds

GemBox.Spreadsheet 4.9 Bug Fixes

Version Release notes Release date .NET Framework 3.5+ download .NET 6.0+ on Windows download .NET Standard 2.0+ download
(Linux,macOS,Android,iOS,…)
v1335
  • 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.
 2023-05-10 GBS49v1335.zip
(Full version: 49.0.35.1335) 		GBS49v1335Windows.zip
(Full version: 49.0.600.1335) 		GBS49v1335Standard.tar.gz
(Full version: 49.0.200.1335)
v1301
  • 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.
 2023-04-05 GBS49v1301.zip
(Full version: 49.0.35.1301) 		GBS49v1301Windows.zip
(Full version: 49.0.600.1301) 		GBS49v1301Standard.tar.gz
(Full version: 49.0.200.1301)
v1274
  • 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.
 2023-03-10 GBS49v1274.zip
(Full version: 49.0.35.1274) 		GBS49v1274Windows.zip
(Full version: 49.0.600.1274) 		GBS49v1274Standard.tar.gz
(Full version: 49.0.200.1274)
v1244
  • 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.
 2023-02-03 GBS49v1244.zip
(Full version: 49.0.35.1244) 		GBS49v1244Windows.zip
(Full version: 49.0.600.1244) 		GBS49v1244Standard.tar.gz
(Full version: 49.0.200.1244)
v1225
  • 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.
 2023-01-03 GBS49v1225.zip
(Full version: 49.0.35.1225) 		GBS49v1225Windows.zip
(Full version: 49.0.600.1225) 		GBS49v1225Standard.tar.gz
(Full version: 49.0.200.1225)
v1202
  • 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.
 2022-12-14 GBS49v1202.zip
(Full version: 49.0.35.1202) 		GBS49v1202Core.zip
(Full version: 49.0.310.1202) 		GBS49v1202Standard.tar.gz
(Full version: 49.0.200.1202)
v1153
  • 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.
 2022-11-09 GBS49v1153.zip
(Full version: 49.0.35.1153) 		GBS49v1153Core.zip
(Full version: 49.0.310.1153) 		GBS49v1153Standard.tar.gz
(Full version: 49.0.200.1153)
v1127
  • 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.
 2022-10-12 GBS49v1127.zip
(Full version: 49.0.35.1127) 		GBS49v1127Core.zip
(Full version: 49.0.310.1127) 		GBS49v1127Standard.tar.gz
(Full version: 49.0.200.1127)
v1103
  • 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.
 2022-09-06 GBS49v1103.zip
(Full version: 49.0.35.1103) 		GBS49v1103Core.zip
(Full version: 49.0.310.1103) 		GBS49v1103Standard.tar.gz
(Full version: 49.0.200.1103)
v1084
  • 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.
 2022-08-12 GBS49v1084.zip
(Full version: 49.0.35.1084) 		GBS49v1084Core.zip
(Full version: 49.0.310.1084) 		GBS49v1084Standard.tar.gz
(Full version: 49.0.200.1084)
v1067
  • 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.
 2022-07-21 GBS49v1067.zip
(Full version: 49.0.35.1067) 		GBS49v1067Core.zip
(Full version: 49.0.310.1067) 		GBS49v1067Standard.tar.gz
(Full version: 49.0.200.1067)
v1039
  • 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.
 2022-06-10 GBS49v1039.zip
(Full version: 49.0.35.1039) 		GBS49v1039Core.zip
(Full version: 49.0.310.1039) 		GBS49v1039Standard.tar.gz
(Full version: 49.0.200.1039)
v1017
  • 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.
 2022-05-16 GBS49v1017.zip
(Full version: 49.0.35.1017) 		GBS49v1017Core.zip
(Full version: 49.0.310.1017) 		GBS49v1017Standard.tar.gz
(Full version: 49.0.200.1017)
v1000
  • Added support for XLSB format.
  • 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.
 2022-04-21 GBS47v1000.zip
(Full version: 49.0.35.1000) 		GBS47v1000Core.zip
(Full version: 49.0.310.1000) 		GBS47v1000Standard.tar.gz
(Full version: 49.0.200.1000)

GemBox.Spreadsheet 4.7 Bug Fixes

Important

This version is no longer maintained, no new bug fixes will be released for it.
The GemBox.Spreadsheet version history is available on Version History help page.

Version Release notes Release date .NET Framework 3.5 - 4.8 download .NET Core 3.1 download
(.NET 5 & 6 for Windows)		 .NET Standard 2.0 download
(.NET 5 & 6 for Linux,macOS,…)
v1418
  • 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.
 2022-03-09 GBS47v1418.zip
(Full version: 47.0.35.1418) 		GBS47v1418Core.zip
(Full version: 47.0.310.1418) 		GBS47v1418Standard.tar.gz
(Full version: 47.0.200.1418)
v1398
  • 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.
 2022-02-01 GBS47v1398.zip
(Full version: 47.0.35.1398) 		GBS47v1398Core.zip
(Full version: 47.0.310.1398) 		GBS47v1398Standard.tar.gz
(Full version: 47.0.200.1398)
v1363
  • 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.
 2022-01-05 GBS47v1363.zip
(Full version: 47.0.35.1363) 		GBS47v1363Core.zip
(Full version: 47.0.310.1363) 		GBS47v1363Standard.tar.gz
(Full version: 47.0.200.1363)
v1345
  • 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.
 2021-12-07 GBS47v1345.zip
(Full version: 47.0.35.1345) 		GBS47v1345Core.zip
(Full version: 47.0.310.1345) 		GBS47v1345Standard.tar.gz
(Full version: 47.0.200.1345)
v1321
  • 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.
 2021-11-05 GBS47v1321.zip
(Full version: 47.0.35.1321) 		GBS47v1321Core.zip
(Full version: 47.0.310.1321) 		GBS47v1321Standard.tar.gz
(Full version: 47.0.200.1321)
v1298
  • 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.
 2021-10-01 GBS47v1298.zip
(Full version: 47.0.35.1298) 		GBS47v1298Core.zip
(Full version: 47.0.310.1298) 		GBS47v1298Standard.tar.gz
(Full version: 47.0.200.1298)
v1268
  • 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.
 2021-08-26 GBS47v1268.zip
(Full version: 47.0.35.1268) 		GBS47v1268Core.zip
(Full version: 47.0.310.1268) 		GBS47v1268Standard.tar.gz
(Full version: 47.0.200.1268)
v1248
  • 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.
 2021-07-14 GBS47v1248.zip
(Full version: 47.0.35.1248) 		GBS47v1248Core.zip
(Full version: 47.0.310.1248) 		GBS47v1248Standard.tar.gz
(Full version: 47.0.200.1248)
v1230
  • 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.
 2021-06-17 GBS47v1230.zip
(Full version: 47.0.35.1230) 		GBS47v1230Core.zip
(Full version: 47.0.310.1230) 		GBS47v1230Standard.tar.gz
(Full version: 47.0.200.1230)
v1207
  • 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.
 2021-05-14 GBS47v1207.zip
(Full version: 47.0.35.1207) 		GBS47v1207Core.zip
(Full version: 47.0.310.1207) 		GBS47v1207Standard.tar.gz
(Full version: 47.0.200.1207)
v1170
  • 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.
 2021-04-20 GBS47v1170.zip
(Full version: 47.0.35.1170) 		GBS47v1170Core.zip
(Full version: 47.0.310.1170) 		GBS47v1170Standard.tar.gz
(Full version: 47.0.200.1170)
v1129
  • 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.
 2021-03-09 GBS47v1129.zip
(Full version: 47.0.35.1129) 		GBS47v1129Core.zip
(Full version: 47.0.310.1129) 		GBS47v1129Standard.tar.gz
(Full version: 47.0.200.1129)
v1095
  • 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.
 2021-02-03 GBS47v1095.zip
(Full version: 47.0.35.1095) 		GBS47v1095Core.zip
(Full version: 47.0.310.1095) 		GBS47v1095Standard.tar.gz
(Full version: 47.0.200.1095)
v1071
  • 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.
 2021-01-12 GBS47v1071.zip
(Full version: 47.0.35.1071) 		GBS47v1071Core.zip
(Full version: 47.0.310.1071) 		GBS47v1071Standard.tar.gz
(Full version: 47.0.200.1071)
v1044
  • 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.
 2020-12-02 GBS47v1044.zip
(Full version: 47.0.35.1044) 		GBS47v1044Core.zip
(Full version: 47.0.310.1044) 		GBS47v1044Standard.tar.gz
(Full version: 47.0.200.1044)
v1029
  • 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.
 2020-11-09 GBS47v1029.zip
(Full version: 47.0.35.1029) 		GBS47v1029Core.zip
(Full version: 47.0.300.1029) 		GBS47v1029Standard.tar.gz
(Full version: 47.0.200.1029)
v1013
  • 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.
 2020-10-16 GBS47v1013.zip
(Full version: 47.0.35.1013) 		GBS47v1013Core.zip
(Full version: 47.0.300.1013) 		GBS47v1013Standard.tar.gz
(Full version: 47.0.200.1013)
v1000
  • Release version.
 2020-09-16 GBS47v1000.zip
(Full version: 47.0.35.1000) 		GBS47v1000Core.zip
(Full version: 47.0.300.1000) 		GBS47v1000Standard.tar.gz
(Full version: 47.0.200.1000)

GemBox.Spreadsheet 4.5 Bug Fixes

Important

This version is no longer maintained, no new bug fixes will be released for it.
The GemBox.Spreadsheet version history is available on Version History help page.

Version Release notes Release date .NET Framework 3.5 - 4.8 download .NET Core 3.0 download .NET Standard 2.0 download
v1225
  • 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.
 2020-09-08 GBS45v1225.zip
(Full version: 45.0.35.1225) 		GBS45v1225Core.zip
(Full version: 45.0.300.1225) 		GBS45v1225Standard.zip
(Full version: 45.0.200.1225)
v1206
  • 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.
 2020-08-06 GBS45v1206.zip
(Full version: 45.0.35.1206) 		GBS45v1206Core.zip
(Full version: 45.0.300.1206) 		GBS45v1206Standard.zip
(Full version: 45.0.200.1206)
v1187
  • 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.
 2020-06-26 GBS45v1187.zip
(Full version: 45.0.35.1187) 		GBS45v1187Core.zip
(Full version: 45.0.300.1187) 		GBS45v1187Standard.zip
(Full version: 45.0.200.1187)
v1176
  • 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.
 2020-05-22 GBS45v1176.zip
(Full version: 45.0.35.1176) 		GBS45v1176Core.zip
(Full version: 45.0.300.1176) 		GBS45v1176Standard.zip
(Full version: 45.0.200.1176)
v1148
  • 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.
 2020-04-09 GBS45v1148.zip
(Full version: 45.0.35.1148) 		GBS45v1148Core.zip
(Full version: 45.0.300.1148) 		GBS45v1148Standard.zip
(Full version: 45.0.200.1148)
v1131
  • 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.
 2020-03-16 GBS45v1131.zip
(Full version: 45.0.35.1131) 		GBS45v1131Core.zip
(Full version: 45.0.300.1131) 		GBS45v1131Standard.zip
(Full version: 45.0.200.1131)
v1094
  • 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.
 2020-02-10 GBS45v1094.zip
(Full version: 45.0.35.1094) 		GBS45v1094Core.zip
(Full version: 45.0.300.1094) 		GBS45v1094Standard.zip
(Full version: 45.0.200.1094)
v1084
  • 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.
 2020-01-08 GBS45v1084.zip
(Full version: 45.0.35.1084) 		GBS45v1084Core.zip
(Full version: 45.0.300.1084) 		GBS45v1084Standard.zip
(Full version: 45.0.200.1084)
v1069
  • Fixed issue with DATEDIF function calculation.
  • Added support for input elements in HTML reader.
  • Added support for WEEKNUM function.
  • Fixed issue with chart title styling.
  • Added support for ChartDataLabels.LabelContainsPercentage.
  • Fixed issue with invalid name for active worksheet in ODS reader.
 2019-12-03 GBS45v1069.zip
(Full version: 45.0.35.1069) 		GBS45v1069Core.zip
(Full version: 45.0.300.1069) 		GBS45v1069Standard.zip
(Full version: 45.0.200.1069)
v1061
  • Improved support for external charts.
 2019-11-06 GBS45v1061.zip
(Full version: 45.0.35.1061) 		GBS45v1061Core.zip
(Full version: 45.0.300.1061) 		GBS45v1061Standard.zip
(Full version: 45.0.200.1061)
v1060
  • Added support for .NET Core 3.0.
  • Fixed issue with parsing formula in XLS files.
  • Fixed issue with reading paper size in XLSX reader.
  • Added support for T.DIST function.
  • Added support for preserving "textlink" in shapes.
  • Added support for setting cell style with HTML content in SetValue method.
  • Added support for auto filters in pivot table.
  • Fixed issue with cell background color from fill pattern in HTML writer.
  • Added support for QUOTIENT function.
  • Added support for DateTime built-in properties in XLS files.
  • Fixed issue with chart series order in PDF writer.
  • Added support for chart data labels format.
 2019-10-30 GBS45v1060.zip
(Full version: 45.0.35.1060) 		GBS45v1060Core.zip
(Full version: 45.0.300.1060) 		GBS45v1060Standard.zip
(Full version: 45.0.200.1060)
v1043
  • Added support for right-to-left languages in PDF writer.
  • Added support for expanded/collapsed pivot items.
 2019-09-27 GBS45v1043.zip
(Full version: 45.0.35.1043) 		NA GBS45v1043Standard.zip
(Full version: 45.0.200.1043)
v1040
  • Added support for 'sup' and 'super' script position in HTML writer.
  • Fixed issue with number formats in XLS writer.
  • Fixed issue with reading custom filter value from Google Sheet.
  • Fixed issue with comparing values of different types in calculation engine.
  • Fixed issue with scatter chart X axis rendering.
  • Adding support for ExcelWorksheet.FilterMode property.
  • Added support for Center Across Selection horizontal alignment in PDF writer.
  • Fixed issue with chart series color resolution.
  • Added support for conditional formatting formula update when rows/columns are inserted/removed.
 2019-09-20 GBS45v1040.zip
(Full version: 45.0.35.1040) 		NA GBS45v1040Standard.zip
(Full version: 45.0.200.1040)
v1019
  • Fixed issue with reading shared formulas in XLS files.
  • Added support for EDATE function.
  • Added support for Table.AlternativeText.
  • Added support for chart series gap and overlap.
 2019-08-08 GBS45v1019.zip
(Full version: 45.0.35.1019) 		NA GBS45v1019Standard.zip
(Full version: 45.0.200.1019)
v1010
  • Added support for adding and removing multiple rows at once in Table.Rows.
  • Added support for automatic formula update in CellRange.CopyTo method.
  • Added support for chart labels to include category and series names in PDF writer.
  • Fixed issue with reading pivot field layout.
  • Fixed various issues with ODS reader.
 2019-07-12 GBS45v1010.zip
(Full version: 45.0.35.1010) 		NA GBS45v1010Standard.zip
(Full version: 45.0.200.1010)
v1000
  • Release version.
 2019-06-04 GBS45v1000.zip
(Full version: 45.0.35.1000) 		NA GBS45v1000Standard.zip
(Full version: 45.0.200.1000)

GemBox.Spreadsheet 4.3 Bug Fixes

Important

This version is no longer maintained, no new bug fixes will be released for it.
The GemBox.Spreadsheet version history is available on Version History help page.

Version Release notes Release date .NET Framework 3.5 - 4.8 download .NET Standard 2.0 download
v1140
  • Fixed issue with reading paper size in XLSX file.
 2020-01-14 GBS43v1140.zip
(Full version: 43.0.35.1140) 		GBS43v1140Standard.zip
(Full version: 43.0.200.1140)
v1139
  • Fixed issue with reading defined names with double quoted values.
  • Fixed issue with reading invalid cell range in sort state.
  • Fixed issue with rendering non-existing linked images in PDF writer.
  • Fixed issue with with writing XLSX files in multi-threaded environment.
  • Fixed various issues with XLS reader.
  • Added partial support for writing HTML files in .NET Standard.
  • Fixed issue with writing PDF files in medium trust environment.
 2019-09-20 NA NA
v1127
  • Fixed issue with rendering pie chart category axis in PDF writer.
  • Fixed issue with reading and writing large XLSX files.
  • Added support for SEARCH, LARGE and RANK functions.
  • Fixed issue with reading invalid zoom value in ODS file.
  • Added support for copying conditional formatting.
 2019-05-08 NA NA
v1115
  • Added support for worksheet background picture in XLSX file.
  • Added support for COUNTBLANK function.
  • Fixed issue when writing pivot field items.
 2019-04-09 NA NA
v1111
  • Added support for preserving picture effects in XLSX files.
  • Added support for SUMSQ function.
  • Fixed issue with invalid picture position in ODS files.
  • Added support for determining file format from stream.
 2019-02-26 NA NA
v1106
  • Added support for TIFF color depth and compression in ImageSaveOptions.
  • Added support for ImageSaveOptions.CropToContent.
  • Fixed various issues with XLSX reader.
  • Added support for sorting pivot tables.
  • Added support for CellRange.GetCurrentRegion.
  • Added support for PivotTable.ClassicPivotTableLayout.
  • Added support for auto-fitting merged cells.
  • Fixed issue with updating cell references in Excel formulas.
 2019-02-05 NA NA
v1095
  • Fixed issue with rendering tinted colors.
  • Fixed issue with font name from sheet's header in PDF writer.
  • Added support for preserving custom UI in XLSX files.
  • Fixed issue with rendering chart axis and grid lines.
  • Added support for discovering header cells in ExportToDataGridViewOptions.
  • Added support for workbook protection in XLSX files.
  • Added support for fraction number format.
  • Fixed issue with displaying 1/0/1900 date.
 2019-01-02 NA NA
v1084
  • Fixed issue with copying sheet containing charts.
  • Fixed issue with DateTime values in XLS writer.
  • Fixed issue with cloning conditional formatting.
  • Added support for preserving links for custom properties.
 2018-11-08 NA NA
v1076
  • Added support for built in date properties.
  • Fixed various issues with chart rendering in PDF file.
  • Fixed issue with removing Excel Table.
  • Fixed issue when preserving chart style parts in XLSX file.
 2018-09-25 NA NA
v1066
  • Fixed issue with MOD function in calculation engine.
  • Added support for updating conditional formatting and data validation when rows/columns are inserted/removed.
  • Fixed issue with reading XLS file that has zero record code.
  • Fixed various issues with Excel Tables.
  • Added support for reading embedded objects from XLSX file.
 2018-08-23 NA NA
v1049
  • Fixed issue with preserving unsupported tables.
  • Added support for ExcelFillPattern in DataGridView.
  • Fixed issue with defined name constant values that include parentheses.
  • Fixed issue with pivot cache field attributes in XLSX writer.
  • Fixed issue with time values in ODS reader.
  • Fixed issue with empty cells in calculation engine.
  • Fixed issue with calculating formulas that have non-standard references.
 2018-07-16 NA NA
v1036
  • Fixed various issues with XLSX reader and writer.
  • Improved performances of Excel Table reader.
  • Added support for custom page size in ODS files.
  • Added support for inline text formatting in ODS files.
  • Fixed various issues with calculation engine parser.
 2018-06-08 NA NA
v1020
  • Fixed various issues with Excel tables.
  • Fixed issue with preserved shared formulas in XLS file.
  • Added support for Certificate property in DigitalSignatureSaveOptions.
  • Added support for distributed horizontal alignment in ODS file.
  • Added support for linked pictures in XLSX file.
 2018-05-04 NA NA
v1005
  • Fixed issue with table reference calculations.
  • Added support for basic structured table references.
  • Fixed various issues with XLSX reader and writer.
 2018-04-04 NA NA
v1000
  • Release version.
 2018-03-27 NA NA

GemBox.Spreadsheet 4.1 Bug Fixes

Important

This version is no longer maintained, no new bug fixes will be released for it.
The GemBox.Spreadsheet version history is available on Version History help page.

Version Release notes Release date .NET Framework 2.0 download .NET Framework 3.0 - 4.7 download
v1183
  • Fixed issue with allocating empty cells in ODS file.
  • Fixed issue with number format in XLS reader.
 2019-07-02 GBS41v1183ForNET20.zip
(Full version: 41.3.0.1183) 		GBS41v1183.zip
(Full version: 41.3.30.1183)
v1181
  • Added support for preserving picture effects in XLSX file.
  • Added support for SUMSQ function.
 2019-05-06 NA NA
v1179
  • Fixed issue with theme color in XLSX file.
  • Fixed issue with writing Excel function prefix.
 2019-02-04 NA NA
v1177
  • Added support for worksheet margins in XLS files.
  • Added support for CEILING.PRECISE function.
 2018-11-08 NA NA
v1173
  • Fixed issue with duplicated pictures in XLSX files.
  • Fixed issue with comparing null values in calculation engine.
 2018-09-25 NA NA
v1169
  • Fixed issue with running in medium trust environment.
 2018-08-23 NA NA
v1168
  • Fixed issue with auto-disabled chart title.
  • Added support for simple chart outline rendering in PDF file.
  • Fixed issue with preserving unsupported charts.
  • Fixed issue with data validation in XLSX writer.
 2018-07-16 NA NA
v1165
  • Fixed issue with pivot cache fields.
  • Fixed issue with formula calculation in merged cells.
  • Fixed issue with detecting custom date time format.
  • Added support for specifying labels interval in category axis.
  • Fixed various issues with PDF writer.
  • Fixed issue when reading XLS records with variable size.
 2018-06-08 NA NA
v1158
  • Fixed issue with clipped overflown cell content in PDF writer.
  • Fixed issue with reading encrypted XLSX file.
  • Added support for preserving DataValidation.List.
 2018-05-04 NA NA
v1154
  • Added support for retrieving the unresolved individual border of ExcelCell.
  • Added support for copying named ranges to new workbook.
  • Fixed issue with adding empty headers on even pages in XLSX writer.
  • Fixed various issues with XLS reader.
  • Fixed issue with pivot field grouping.
 2018-04-04 NA NA
v1147
  • Fixed issue with headers and footers order of rendering.
  • Fixed various issues with XLSX writer.
  • Added support for CellStyle.NumberFormatLocal.
  • Fixed issue with ODS reader in medium trust environment.
  • Fixed issue with cell indent when horizontal alignment is General in PDF and HTML writer.
  • Fixed various issues with calculation engine.
  • Added support for MEDIAN function.
 2018-02-22 NA NA
v1136
  • Added support for chart data labels and rotated horizontal (category) axis.
  • Fixed issue with page breaks on hidden rows and columns in PDF writer.
  • Added support for NORMSDIST function.
 2018-01-11 NA NA
v1132
  • Fixed issue with cell style indexed colors when copying a worksheet from XLS file.
  • Added support for N function.
  • Fixed issue with IRR function calculation.
 2017-12-08 NA NA
v1128
  • Fixed issue with pivot cache field attributes.
  • Added support for external CSS in HTML reader.
  • Fixed issue with reading invalid DateTime values in XLSX reader.
  • Fixed issue with rendering EMF, WMF or EXIF images.
 2017-11-13 NA NA
v1122
  • Fixed issue with preserving unsupported charts.
  • Added support for SheetType.Chart.
  • Fixed various issues with PDF writer.
  • Fixed issue with reading shared string item in XLSX file.
  • Fixed issue with cloning preserved charts.
 2017-10-11 NA NA
v1111
  • Added support for preserving custom UI relationships in XLSX file.
  • Added support for RATE, IRR and NPV functions.
  • Fixed various issues with XLS reader.
 2017-09-12 NA NA
v1106
  • Added support for ProtectedRanges in XLSX format.
  • Fixed issue with setting cell comment text to null.
  • Fixed issue with missing image in PDF writer.
 2017-08-16 NA NA
v1101
  • Fixed issue with print copy count.
  • Fixed various issues with XLSX reader and PDF writer.
  • Added support for TEXT function.
  • Added support for SUMPRODUCT function.
  • Added support for multiple selected ranges with ExcelWorksheet.SelectedRanges.
 2017-07-07 NA NA
v1091
  • Fixed various issues with XLSX reader and writer.
  • Added support for VALUE function.
  • Fixed issue with reading pictures from path in HTML reader.
  • Added support for EOMONTH, PMT, XIRR functions.
  • Added support for dimension element in XLSX writer.
  • Added support for YEARFRAC formula function.
 2017-06-02 NA NA
v1070
  • Added support for ordering drawings based on their Z-index.
  • Added support for caching images in PDF writer.
  • Added support for RANK.AVG formula function.
  • Fixed issue with cell format when inserting empty columns.
  • Added support for RANK.EQ formula function.
  • Fixed issue with missing pictures in HTML writer.
  • Added support for INDIRECT formula function.
 2017-03-21 NA NA
v1059
  • Added support for automatic update of picture positions when rows/columns are inserted/removed.
  • Fixed various issues with pivot table.
  • Improved performances of pivot cache creation.
  • Added support for preserving embedded objects.
  • Added support for positioning chart points on tick marks.
  • Added support for overload FindText methods.
  • Fixed various issues with formulas updating when rows/columns are inserted/removed.
 2017-02-17 NA NA
v1047
  • Fixed issue with double borders in PDF writer.
  • Added support for INDEX and MATCH formula functions.
  • Added support for COUNT, COUNTA, PRODUCT and SUBTOTAL formula functions.
  • Added support for VAR, VARA, VARP, VARPA and formula functions.
 2017-01-21 NA NA
v1038
  • Added support for internal hyperlinks in HTML writer.
  • Added support for enumerating formatted character ranges within the cell text.
 2016-12-23 NA NA
v1033
  • Added support for automatic formula update in inserted copies of rows/columns.
 2016-12-09 NA NA
v1032
  • Added support for automatic update of cell references in formulas when rows/columns are inserted/removed.
  • Added support for IFERROR formula function.
  • Added support for setting inside borders to a cell range.
  • Modified MultipleBorders.All so that it resembles MS Excel behaviour.
  • Fixed issue with XLSX reader on Mono Framework.
  • Fixed issue with pivot cache field name collision.
 2016-12-06 NA NA
v1018
  • Added support for loading HTML content as cell value.
  • Fixed issue with text attributes in ODS writer.
  • Fixed issue with parsing quoted identifiers in calculation engine.
  • Added support for reading horizontal rule in HTML reader.
  • Added support for inline text formatting in HTML reader.
  • Fixed various issues with HTML reader.
  • Added support for escaped ampersand characters in Excel headers and footers.
 2016-11-07 NA NA
v1000
  • Release version.
 2016-09-27 NA NA

GemBox.Spreadsheet 3.9 Bug Fixes

Important

This version is no longer maintained, no new bug fixes will be released for it.
The GemBox.Spreadsheet version history is available on Version History help page.

Version Release notes Release date .NET Framework 2.0 download .NET Framework 3.0 - 4.6 download
v1215
  • Updated help pages.
 2018-03-26 GBS39v1215ForNET20.zip
(Full version: 39.3.0.1215) 		GBS39v1215.zip
(Full version: 39.3.30.1215)
v1214
  • Fixed issue with reading defined names.
 2017-12-08 NA NA
v1213
  • Fixed issue with pivot table's field properties.
 2017-11-13 NA NA
v1212
  • Fixed issue with missing print title which contained only a picture.
 2017-08-16 NA NA
v1211
  • Fixed various issues with XLS and XLSX readers.
  • Added support for setting NumberStyles for parsing numbers.
  • Fixed issue with printing LineStyle.Hair borders.
 2017-06-02 NA NA
v1207
  • Added support for automatic update of picture positions when rows/columns are inserted/removed.
  • Fixed issue with reading multiple merged ranges in XLS file.
 2017-02-17 NA NA
v1205
  • Fixed issue with reading custom date format in XLS file.
  • Fixed issue with column width in PDF writer.
 2017-01-20 NA NA
v1202
  • Fixed issue with rendering picture that is anchored on hidden Excel row/column in PDF writer.
  • Fixed issue when writing pivot table conditional format rules.
  • Fixed the issue with calculating text width.
 2016-11-07 NA NA
v1198
  • Added support for ignoring quote characters when loading CSV file.
  • Added support for replacing in-line formatted cell text.
  • Fixed various issues with XLS reader.
  • Added support for adjusting AutoFit to AutoFilter drop-down button.
 2016-09-26 NA NA
v1189
  • Added support for reading pictures based on URI in HTML.
  • Fixed various issue with XLS and XLSX readers.
  • Added support for reading and writing large numbers in XLS.
  • Fixed issue with named ranges reference in cell formulas.
  • Fixed issue with FillPatternStyle.None cell's background color.
  • Added support for specifying destination range's sheet in CellRange.CopyTo(string topLeftCell), e.g. "Sheet2!D5".
 2016-08-18 NA NA
v1171
  • Fixed issue with reading XLSX file that has duplicate drawing ID.
  • Added support for changing the source data for a PivotCache.
  • Fixed issue with formulas that have string result value.
 2016-06-14 NA NA
v1163
  • Fixed various issues with XLSX reader and writer.
  • Fixed various issues with XLS reader.
  • Fixed issue with inserting copied column.
  • Added support for referencing cell range through A1 notation.
 2016-05-11 NA NA
v1153
  • Added rudimentary support for rendering RTL languages (Hebrew).
  • Added support for images in PDF in Partially Trusted applications.
  • Fixed issue with rendering East Asian characters in PDF.
  • Added support for 'bgcolor' and 'align' attributes in HTML reader.
 2016-04-04 NA NA
v1140
  • Added support to check if row height is automatically fitted.
  • Added support for formatting text inside comments.
  • Added support for shared formulas in XLS reader.
 2016-02-25 NA NA
v1132
  • Added support for inline text formatting in HTML writer.
 2016-02-15 NA NA
v1130
  • Fixed issue with reading files from Azure Blob.
 2016-02-01 NA NA
v1129
  • Added support for creating digitally signed PDF files.
 2016-01-19 NA NA
v1128
  • Fixed issue with internal hyperlinks in PDF.
 2016-01-17 NA NA
v1125
  • Added support for CellStyle.Indent in HTML reader/writer.
  • Fixing issue with paper sizes.
  • Added support for A2 paper size and printer settings.
  • Added support for ExcelDrawing.Metadata.
 2015-12-10 NA NA
v1119
  • Added support for custom DataGridView's cell values in ImportFromDataGridView, ToString method is called on custom types.
  • Fixed issue with reading hyperlink's url that contains fragment.
 2015-11-25 NA NA
v1106
  • Fixed issue with color when creating a chart with a single series.
  • Added Application build in property.
  • Fixed issue when copying workbook-scoped defined names.
  • Added support for 'valign' attribute in HTML reader.
 2015-10-06 NA NA
v1095
  • Added support for DPI settings when saving to image formats.
  • Added support for document name in the print queue.
  • Fixed issues with reading conditional formatting and pivot tables.
  • Added support for ignored errors in XLS and XLSX format.
  • Added support for conditions in number format.
  • Fixed various issues with XLS reader and writer.
 2015-09-01 NA NA
v1077
  • Fixed issue with reading pivot table worksheet source.
  • Fixed issue with custom number format ("mmm").
  • Fixed issue with formatting large number of cells.
  • Fixed issue with copying worksheet that has large range of merged cells.
  • Fixed issue with exporting DataGridViewImageCell that has ImageLayout set to Normal.
  • Improved CellRange.Clear() method's performance.
  • Fixed issue when writing cell value of type Int64/UInt64 to XLSX file.
  • Fixed issue when setting cell value of float type.
  • Added reading of hyperlink's default formatting in HTML.
 2015-07-03 NA NA
v1063
  • Added support for Conditional Formatting and Pivot Tables.
 2015-05-28 NA NA
v1048
  • Added support for AutoFilter, Sorting and In-line Text Formatting.
  • Added support for embedded fonts (FontSettings.FontsBaseResourceLocation).
 2015-04-21 NA NA
v1037
  • Fixed issue with picture's scaling in XLSX files.
  • Added ExcelChart.ShowEmptyCellsAs property.
  • Fixed issue with parsing custom number formats.
 2015-03-17 NA NA
v1024
  • Added support for reading picture's scaling in XLSX files.
  • Fixed issue with calculating column's AutoFit on cells with rotated text.
  • Fixed issue with setting sheet's default row height in XLSX.
  • Fixed issue with a sheets default tab color in HTML writer.
  • Fixed issue with missing few sheet's PrintOptions properties when copying the sheet.
 2015-02-17 NA NA
v1007
  • Fixed issue with cleared merged cell ranges when moving sheets.
  • Fixed issue with SetPrintTitles for sheets that contain non alphanumeric characters.
  • Added support for saving pages to multi-frame TIFF image.
 2015-01-14 NA NA
v1000
  • Release version.
 2014-12-23 NA NA

GemBox.Spreadsheet 3.7 Bug Fixes

Important

This version is no longer maintained, no new bug fixes will be released for it.
The GemBox.Spreadsheet version history is available on Version History help page.

Version Release notes Release date .NET Framework 2.0 download .NET Framework 3.0 - 4.5 download
v1189
  • Fixed issue with reading header image size in XLSX.
 2016-09-26 GBS37v1189ForNET20.zip
(Full version: 37.3.0.1189) 		GBS37v1189.zip
(Full version: 37.3.30.1189)
v1188
  • Fixed issue with reading defined names.
 2016-08-18 NA NA
v1185
  • Added support for preserving array formulas in XLSX.
 2016-04-04 NA NA
v1183
  • Fixed issue with TIFF images in XLSX files.
 2016-02-01 NA NA
v1182
  • Fixed issue with reading XLSX file's custom properties of bool type.
 2015-11-25 NA NA
v1179
  • Fixed issue with reading VerticalBreaks that exceed spreadsheet's limitation.
 2015-10-06 NA NA
v1176
  • Added ExcelChart.ShowEmptyCellsAs property.
  • Fixed issue when saving defined name on worksheet with space character in sheet's name.
  • Fixed issue with undeleted hyperlink on cell's deletion.
 2015-03-16 NA NA
v1165
  • Added support for '-' char in sheet's protection password.
  • Improved XLSX read/write performance when reading/writing XLSX files with many merged cells.
  • Fixed issue with Print_Titles when copying or renaming worksheets.
 2014-12-05 NA NA
v1160
  • Fixed issue with cells exceeding the MS Excel limit of 32767 characters.
  • Fixed issue with sheet's header/footer rendering.
  • Fixed issue with rendering merged cells.
  • Added support for cell reference which includes sheet index.
  • Added support for System.Net.Http.HttpResponseMessage in Save methods of ExcelFile and FormattedExcelDrawing.
  • Added support for SaveOptions.ContentType.
  • Fixed issues when reading some XLSX files (invalid zoom values are now skipped, sheet name is correctly encoded/decoded as XML escaped string).
  • Fixed issue with cell indent when rendering.
  • Fixed issue with formulas not being calculated when XLSX is opened in LibreOffice Calc.
  • Added support for reading and writing line breaks in HTML cells.
 2014-10-14 NA NA
v1146
  • Added preserving of Composite charts.
  • Added Parent property for ExcelWorksheet.
  • Fixed issue with loading encrypted file without password.
  • Fixed issue with copying worksheet that contain comments.
  • Fixed issue with multiple styles of same name.
  • Added preserving of worksheet protected ranges in XLSX.
  • Added support for embedded (Base64) HTML images.
  • Added support for Marker in Line chart.
 2014-09-04 NA NA
v1128
  • Added support for Charts.
  • Fixed issue with preserved embedded controls in MS Excel 2007.
  • Fixed issue with default cell borders in HTML.
  • Fixed issue with default column width in XLS.
  • Fixes and improvements in XLSX writer, PDF writer.
 2014-06-12 NA NA
v1120
  • Fixes and performance improvements on XLSX writer.
  • Improved printing.
  • Fixed issue with barcode font.
  • Added silent trimming of sheet names to 31 characters for XLS files only.
 2014-04-30 NA NA
v1110
  • 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 system regional date and time settings.
  • Various fixes and enhancements in GemBox.Spreadsheet model and PDF and XLSX readers / writers.
 2014-02-12 NA NA
v1099
  • Added support for HttpResponseBase in ExcelFile.Save methods so they can be used in ASP.NET MVC applications.
  • Various fixes and enhancements in GemBox.Spreadsheet model and PDF, ODS and XLSX readers / writers.
 2013-11-26 NA NA
v1088
  • Fixed XLSX reading issue when using ExcelFile.LoadFromDirectory() method.
  • Fixed XLSX reading issue with reading files that exceed ExcelFile.GroupMethodsAffectedCellsLimit.
  • Fixed XLSX writing issue with writing SlantDashDot line style.
  • Fixed issue with measuring text size.
  • Fixed XLSX reading issue with reading cell value.
  • Several internal zip components are replaced with DotNetZip library.
  • Added HTML writing support for writing data-cell attribute with cell address.
  • Fixed XLSX writing issue with writing very large number of similar columns.
  • Fixed issue with auto-fitting rows which contain merged cells.
  • Fixed issue with inserting pictures.
  • Fixed issue with deleting pictures.
  • This build is included with fourth setup release.
 2013-09-09 NA NA
v1069
  • Added support for view type (supported only for XLSX file format).
  • Fixed issue with copying header/footer.
  • This build is included with third setup release.
 2013-06-13 NA NA
v1067
  • Added support for reading HTML files.
  • Added support for reading/writing Fixed-Width files.
  • Fixed rendering issue when cell content height is larger than cell.
  • Fixed PDF writing issue with JPEG image encoding.
 2013-05-10 NA NA
v1053
  • Fixed issue when rendering worksheet in which last cells in a row have content which overflows.
  • Added support for rendering double border.
  • Fixed performance issues when writing XLSX file which contains a large number of images.
  • Header/Footer API is changed. Now it's easier to set left/center/right sections.
  • Added support for header/footer images.
  • Added helper methods for specifying header/footer content (like page number, current date and time, etc.).
  • Fixed issue with setting hyperlink on ExcelPicture.
  • Fixed issues with ExcelColumn.AutoFit() method.
  • Fixed HTML writing issue with file's content type.
  • Fixed MHTML writing issue with page encoding.
  • Fixed HTML writing issue with writing column width.
  • Added support for Named styles (supported only for XLSX file format).
 2013-04-16 NA NA
v1030
  • Fixed performance issues with ExcelPicture.
  • Fixed issues with font fallback strategy.
  • PDF/XPS/print renderer is completely reimplemented. Added support for fit to page, page scaling, fixed issues with rendering merged cells, etc.
  • Added support for exporting and importing ExcelWorksheet to System.Windows.Forms.DataGridView.
  • Fixed XLSX reading issue with reading column groupings.
  • Fixed XLSX issue with preserving shape hyperlinks.
  • Export to HTML file format is completely reimplemented.
  • Added support for exporting all sheets to HTML file format.
  • Fixed several issues with exporting to HTML file format.
  • Added support for writing files in MHTML file format.
  • Fixed several issues with XLS formula parser.
  • Fixed XLSX reading issue with reading theme colors.
  • Added support for table styles through preservation in XLSX file format.
  • Fixed XLSX and XLS issue with dates between 1899-12-31 and 1900-29-2.
  • This build is included with second setup release.
 2013-03-13 NA NA
v1000
  • Release version.
 2013-02-01 NA NA

How to install a bug fix

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, for the GemBox.Spreadsheet version that you have, 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 a newer version of: