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/3.5 download .NET Framework 4.0 download
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 GBS35v1052FreeForNET20.zip
(Full version: 35.1.0.1052)
GBS35v1052FreeForNET30.zip
(Full version: 35.1.30.1052)
GBS35v1052FreeForNET40.zip
(Full version: 35.1.40.1052)
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 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 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 NA
v1025 - Fixed XLSX writing issue with writing enums.
- This build is included with second setup release.
2011-10-13 NA 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 NA
v1007 - Fixed XLS reading issue with document properties. 2011-8-29 NA NA NA
v1006 - Fixed CSV writing issue with rounding numbers. 2011-8-3 NA NA NA
v1005 - Improved time performaces. 2011-8-1 NA NA NA
v1000 - Release version. 2011-7-27 NA 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'.

GAC for .NET 4.0 assemblies is different than GAC for assemblies from older version of .NET framework. Default path for GAC for .NET 4.0 assemblies is 'c:\Windows\Microsoft.NET\assembly' folder.

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.