Fixed a bug in the formula loader which might cause a problem with CHOOSE and RANK functions.
Fixed a bug which might cause in some cases incorrect text encoding.
Version 1.6.16 24-Nov-2010
Read engine has been improved: Now NativeExcel preserves existing radiobuttons, polygons, autoshapes and groupboxes. (Thanks Victor de Assis Rodrigues)
Version 1.6.15 04-Nov-2010
Fixed a bug which may cause workbook corruption in Excel 2007 and higher. (Thanks to Victor de Assis Rodrigues)
Fixed a bug which may cause workbook corruption after worksheet deletion. (Thanks to Michael Evenson)
Version 1.6.14 26-Sep-2010
Range.Delete method has been completely rewritten.
Range.Insert method has been completely rewritten.
Version 1.6.13 03-Aug-2010
Fixed a bug: Hidden rows shrink to standard row height when unhiding. (Thanks to Steffen Weiss)
Version 1.6.12 08-Jun-2010
Fixed a bug in IRange.Delete method. (Thanks to Swethadhry S.G.)
Version 1.6.11 07-Jun-2010
Fixed a bug in IRange.Delete method. (Thanks to Swethadhry S.G.)
Version 1.6.10 16-Feb-2010
Fixed a bug in the Shared String Table which may causes an exception "Item has already been added". (Thanks to Detmar Skalbania, Kristof Baumann)
Version 1.6.9 11-Jan-2010
Fixed a bug in PrintTitleRows and PrintTitleColumns which may causes an error message in Excel 2007. (Thanks to Michael Gold)
Version 1.6.8 30-Dec-2009
Calculation engine has been improved. Support of IPMT,PPMT,PMT,FV,ISNA,NA,ISERROR,REPT functions added.
Version 1.6.7 23-Nov-2009
Calculation engine has been improved. Support of PROPER function added.
IRange.Copy method now properly copies the formats from one workbook to another. (Thanks to Daniel J Mckeen)
Fixed a minor bug in the document writer which may causes an exception. (Thanks to Rajiv Gupta)
Version 1.6.6 10-Sep-2009
Fixed a bug in the calculation engine (IF function). (Thanks to Kristof Baumann)
Version 1.6.5 9-Sep-2009
Fixed a bug with spreadsheets in 1904 date system. (Thanks to Dries Samyn)
Minor formatting bug fixed
Version 1.6.4 2-Sep-2009
Fixed a bug in the Read engine. (Thanks to Thomas Kabelmann)
Fixed a bug in the calculation engine (MAX function). (Thanks to Thomas Kabelmann)
Read engine has been improved: Now NativeExcel preserves existing command buttons. (Thanks to Luc Gilbert, Jonathan Bianki)
Bug fixed: OpenWorkbook method throws an exception when the worksheet contains the group of shapes with another group of shapes. (Thanks to Stefan Oei)
Version 1.4.7 09-Sep-2008
Fixed a bug in the SUMPRODUCT function. (Thanks to Robert Howard)
Version 1.4.6 08-Sep-2008
Bug fixed: DisplayValue property for the cell with LCID in NumberFormat now returns the correct result. (Thanks to Roel van der Steen)
Read engine has been improved: Now NativeExcel reads the saved values of the cells with formula. (Thanks to Roel van der Steen)
Version 1.4.5 07-Aug-2008
Calculation engine has been improved. Support of MID, FIND, TRIM functions added. (Thanks to Michael Gay)
Version 1.4.4 30-Jul-2008
Read engine has been improved: Now NativeExcel preserves existing textboxes. (Thanks to Giuliano Gro)
Version 1.4.3 25-Jul-2008
Bug fixed: OpenWorkbook method throws an exception when the workbook contains grouped images. (Thanks to Giuliano Gro)
Version 1.4.2 04-Jul-2008
Bug fixed: In some cases, opening a workbook with graphics objects may cause NullReferenceException exception. (Thanks to Maximilian Risch)
Formula Compiler has been improved. Support of
HYPERLINK, PHONETIC, AVERAGEA, MAXA, MINA,
STDEVPA, VARPA, STDEVA, VARA functions added.
Version 1.4.1 03-Jul-2008
Significant speed optimization for Read Engine. In this version the loading speed is at least ten time faster.
fixed some resource leaks in the Rows.Autofit method. (Thanks to John V. Barone)
Bug fixed in the IWorkbook.SaveAs method with xlNormal file format. (Thanks to James Cowan)
Version 1.4.0 01-Jul-2008
Support of images has been added
Support of cell comments has been added
NativeExcel now preserves existing charts for the modified workbook.
Some minor fixes in the Read engine. (Thanks to Paul Schneider)
Calculation engine has been improved. Support of DATE function has been added.
Version 1.2.5 13-Mar-2008
Fixed a bug that caused IRange.Value to return Double instead of DateTime. (Thanks to Jim Larsen)
Version 1.2.4 08-Mar-2008
A bug in the read engine has been fixed which could cause workbook corruption in some cases. (Thanks to Jean-Francois Boulliat)
Version 1.2.3 17-Feb-2008
Calculation engine has been improved.
Support of SUBTOTAL, DSUM, PRODUCT, SUMPRODUCT, VAR, VARP, STDEV, STDEVP functions has been added. (Thanks to Ken Handzik)
Version 1.2.2 29-Jan-2008
Bug fixed: DisplayValue property for the cell with % in NumberFormat now returns the correct value.
Formula compiler has been fixed. Added support for sheet names with ' character. (Thanks to Robert Howard)
Formula property now returns a correct value with reference to external workbook. (Thanks to Robert Howard)
Version 1.1.13 25-Oct-2007
Calculation engine has been improved.
Support of ROUNDUP, ROUNDDOWN, ROUND, CONCATENATE, LOOKUP functions has been added. (Thanks to Henrik Benon)
NativeExcel assembly is now strong named.
Version 1.1.12 18-Oct-2007
Calculation engine has been improved.
Support of SUMSQ function and missing parameters added. (Thanks to Henrik Benon)
Version 1.1.11 14-Oct-2007
Calculation engine has been improved.
Support of MATCH, INDEX functions added. (Thanks to Henrik Benon)
Version 1.1.10 30-Sep-2007
Calculation engine has been improved.
Support of RADIANS, DEGREES, TRUNC, CEILING, FLOOR, ASIN, ACOS functions added.
Support of range search mode for VLOOKUP and HLOOKUP functions added.
Bug fixed: Read engine incorrectly loads formula which contains PI(). (Thanks to Henrik Benon)
Version 1.1.9 05-Sep-2007
Calculation engine has been improved. Formula "=+'text'" now returns 'text' instead of error value.
Autofit method has been improved to achieve more accurate results.
Bug with Rows.Group has been fixed.
Bug fixed: Duplication of VBA objects in modified excel file.
Bug fixed: ColumnWidth property now returns the correct value.
Bug fixed: Read engine incorrectly loads NumberFormat from Excel 5/95 workbooks.(Thanks to Detmar Skalbania)
Version 1.1.8 08-Jul-2007
Fixed a bug in the IRange.GetDataTable method. (Thanks to Jason Nesbitt)
Version 1.1.7 22-Jun-2007
Fixed a bug in the calculation engine. (Thanks to Mauro Cucchi)
Version 1.1.6 12-Jun-2007
Fixed compatibility issue with the Microsoft Jet 4.0 OLE DB Provider. (Thanks to Don Tian)
Added assembly information (Thanks to Janez Cas)
Version 1.1.5 09-May-2007
Bug fixed: In some cases Autofit method may cause an exception. (Thanks to Jose Luis Ramos Martinez)
Some minor bugs have been fixed in GetDataTable method (Thanks to Jean Francois)
"maximum number of fonts was exceeded" bug fixed in Demo version (caused by obfuscator) (Thanks to Martin van Nassou)