On this page you can download the latest fixes for GemBox.Spreadsheet Free 3.5.
Subsribe to the Bug Fix RSS Subsribe to the Bug Fix RSS

History:

Version Fixed issues Release date .NET Framework 2.0 download .NET Framework 3.0 - 4.5 download
v1092 - Fixed XLS issue with parsing formulas.
- Fixed XLSX reading issue with reading shared strings.
2013-01-07 GBS35v1092FreeForNET20.zip
(Full version: 35.1.0.1092)
GBS35v1092Free.zip
(Full version: 35.1.30.1092)
v1090 - Formula objects now have smaller memory footprint.
- This build is included with fourth setup release.
2012-11-14 NA NA
v1083 - Fixed XLSX reading issue with reading empty cells.
- Fixed XLSX issue with values which are preceded with an apostrophe.
- Added utility method for streaming ExcelFile to ASP.NET Response stream.
- Versions for .NET 3.0/3.5 and for .NET 4.0/4.5 are unified into one version for .NET 3.0 - 4.5
- Added support for image hyperlinks (XLSX only).
- Fixed XLSX issues with hidden rows.
- Fixed issues with ExcelPicture positioning. Added new overloads for adding pictures.
- Added LengtUnitConverter class for converting measurement units.
- Added ExcelCell.GetFormattedValue() that combines ExcelCell.Value and CellStyle.NumberFormat. This method can be used for getting formatted ExcelCell.Value.
- HTML writer now uses ExcelCell.GetFormattedValue() for writing cell values.
- Fixed issues with ExcelColumn.AutoFit() and ExcelColumn.AutoFitAdvanced() methods.
- Fixed XLSX reading issue with cell style resolution.
2012-11-09 NA NA
v1066 - Added support for background image through preservation in XLSX file format.
- Fixed XLSX writing issue in free version with writing comments.
- Fixed XLSX reading issue with reading font's vertical align.
2012-09-20 NA NA
v1063 - Fixed XLSX writing issue with writing row height.
- Fixed XLSX reading issue with reading cell content alignment.
- Fixed Free version issue with adding multiple warning sheets.
2012-08-31 NA NA
v1060 - Fixed issue with setting CellStyle.IsTextVertical property.
- Fixed XLSX reading issue with reading shared formulas.
- Fixed XLSX issue with defined names.
- This build is included with third setup release.
2012-08-06 NA NA
v1057 - Fixed XLSX issue with preservation of sheet id.
- Fixed XLSX reading issue with reading Data Validation.
- Fixed XLSX reading issue with reading chart sheets (we now skip them).
- Fixed XLSX issue with preservation of chart's background image.
2012-06-20 NA NA
v1052 - Fixed issue with reading .vml files.
- Added WorksheetProtection.SetPassword() method for setting sheet protection password (XLSX only).
- Better validation of sheet names.
- Fixed XLSX reading issue with reading invalid images.
- Fixed issue with locking file when using ExcelFile.LoadXlsxFromDirectory().
- Fixed issue with exporting pictures to HTML file format.
- Fixed XLSX reading issue with reading default column width.
- Fixed XLS issue with preservation of named ranges.
2012-04-20 NA NA
v1042 - Fixed HTML writing issue with exporting pictures.
- Added support for ActiveX controls through preservation in XLSX file format.
- Better support for form controls in XLSX file format.
- Fixed XLS formula parser. Fixed parsing of formulas from XLS files created with Numbers for iPad and iPhone.
2012-02-23 NA NA
v1039 - Fixed XLSX reading issue with reading shared formulas.
- Fixed XLSX reading issue with reading pictures.
- CellRange.CopyTo() now copies all ExcelCell properties.
2012-02-17 NA NA
v1035 - Added support for specifying selected cells (supported only for XLSX file format).
- Fixed XLSX reading issue with reading pictures.
- Fixed XLS writing issue with document properties.
- Fixed XLSX writing issue with writing double.NaN and float.NaN cell values.
- Fixed XLSX reading issue with reading zoom scale.
- Fixed XLS writing issue with writing hidden columns.
- Fixed XLSX reading issue with reading invalid named ranges.
- Fixed compatibility issue with HTML writer and IE.
- Fixed XLSX writing issue with writing comments and hidden columns.
2012-01-10 NA NA
v1025 - Fixed XLSX writing issue with writing enums.
- This build is included with second setup release.
2011-10-13 NA NA
v1012 - Fixed XLSX writing issue in version for .NET 2.0.
- Fixed ODS reading issue with reading formula results.
- GemBox.Spreadsheet can now be executed in Medium Trust environment.
- Fixed XLSX writing issue with writing decimal values.
- Fixed XLSX writing issue with writing ExcelCell.Value property when it has value set to DBNull.Value.
2011-9-28 NA NA
v1007 - Fixed XLS reading issue with document properties. 2011-8-29 NA NA
v1006 - Fixed CSV writing issue with rounding numbers. 2011-8-3 NA NA
v1005 - Improved time performaces. 2011-8-1 NA NA
v1000 - Release version. 2011-7-27 NA NA


How to install a hotfix:
  1. Copy the files from ZIP archive over the old files in "PRODUCT_INSTALL_PATH\Bin\NETXX" folder. For example, for .NET 2.0 ZIP you need to copy files to "C:\Program Files\GemBox Software\GemBox.Spreadsheet Free 3.5\Bin\NET20" folder. ZIP archives contain fixed DLL and an updated XML file used for Visual Studio IntelliSense.
     
  2. Copy the fixed DLL to GAC (Global Assembly Cache, located in "C:\Windows\assembly").
     
  3. Remove old reference from your VS.NET project and add a reference to the new DLL (check version number).
     
  4. As you probably know, when .NET application is executed, required assemblies need to be either in GAC or in application execution folder:
     
    1. If you use GAC, no action is necessary.
       
    2. If you want component DLL to be located in application execution folder, for that reference in Visual Studio set "Copy Local" property to "True".
       
  5. Rebuild entire solution.

Troubleshooting:

Installing .NET assembly on Vista/Windows 7 OS requires Administrator permissions. On Windows XP for installing .NET assembly it is enough to drag&drop assembly to the GAC folder. On Vista/Windows 7 OS, in most cases, that wouldn't be allowed, so follow this instructions:

  1. Run command prompt (for your version of Visual Studio) as administrator:

    Run cmd as administrator image

  2. Run gacutil.exe tool with 'i' argument and path to assembly which you want to install to GAC. For example: 'gacutil /i c:\MyAssemblies\GemBox.Spreadsheet.dll'

  3. This should install assembly to GAC folder. To check if assembly is properly installed run gacutil tool with 'l' flag. For example: 'gacutil /l GemBox.Spreadsheet'.

Adding assembly to GAC doesn't mean that you would automatically see that assembly in Visual Studio's add reference dialog. If you don't see assembly that is in GAC then you need to make the following steps:

  1. Download and extract zip file that contains .reg file.

  2. Open extracted .reg file with notepad.

  3. Last line in .reg file specifies path to the folder that contains GemBox.Spreadsheet.dll. Change that path to the path on your disk.

  4. Save changed .reg file.

  5. Run .reg file (double click).

  6. Additional help is here under section 'To display an assembly in the Add Reference dialog box'.


© GemBox Software. All rights reserved.