Gembox Spreadsheet Download

Download GemBox.Spreadsheet Free - Provides easy, elegant and high performance way to create, convert, write to and read from Excel files. Spreadsheet 47.0.1013. END-USER LICENSE AGREEMENT IMPORTANT - READ CAREFULLY: This End-User SOFTWARE License Agreement ('LICENSE') is a legal agreement between Licensee (either an individual or a single entity) and GemBox d.o.o., Aleja Lipa 1/E, 10040 Zagreb, Croatia, REGISTRATION NUMBER: 080585069, VAT ID: HR4. GemBox.Spreadsheet Downloads. GemBox.Spreadsheet help file. GemBox Software License Agreement. Please note: To view.

GemBox.Spreadsheet is a.NET component which enables developers to read, write, convert and print spreadsheet files (XLSX, XLS, ODS, CSV, HTML, PDF or XPS) from.NET applications using one simple and efficient API.

Mount abu touring officers hostel knust. On this page you can download the latest fixes for GemBox.Spreadsheet.

Gembox.spreadsheet.dll Free Download

GemBox.Spreadsheet 4.7 Bug Fixes

Version	Release notes	Release date	.NET Framework 3.5 - 4.8 download	.NET Core 3.1 download	.NET Standard 2.0 download
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.zip (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.zip (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.zip (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.zip (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.

Download GemBox.Spreadsheet V4.5 Build 45.0.1131 (16 Mar 2020 ..

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

Gembox Spreadsheet Documentation

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 writings 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 hotfix

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:

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.

NuGet Package

Com.gembox.spreadsheet Jar Download

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