Read engine has been improved: Now NativeExcel preserves existing listboxes. (Thanks to David Eison)
Some minor fixes for compatibility with third-party components.
Version 2.7.5 25-May-2008
Some fixes to avoid MS Excel bug with date 29-Feb-1900. (Thanks to Alexander Buzaev)
Version 2.7.4 17-May-2008
Calculation engine has been improved. Functions ROUND, TRUNC, ROUNDUP, ROUNDDOWN, FLOOR, CEILING now have identical behavior to MS Excel. (Thanks to Neo Yang)
Version 2.7.3 14-Apr-2008
Calculation engine has been improved. Support of VALUE function has been added. (Thanks to Jeff Laing)
Fixed a bug in VLOOKUP function. (Thanks to John N Cox)
Version 2.7.2 08-Apr-2008
IXLSRange.Delete method has been fixed to avoid loss of merged cells. (Thanks to Alexei Sergeev)
Some minor fixes in the Read Engine. (Thanks to Cedric Swaelens)
Version 2.7.1 31-Mar-2008
Calculation engine has been improved. Support of DATE function has been added. (Thanks to John N Cox)
Calculation engine has been improved. Support of IF function with two arguments has been added. (Thanks to Steve Maughan)
Some minor fixes in the Read Engine. (Thanks to Steve Maughan)
Version 2.7.0 25-Mar-2008
Read engine has been improved. NativeExcel now can open password protected (encrypted) excel workbooks.
Added new overloaded IXLSWorkbook.Open methods that take a Password as a parameter.
Version 2.6.8 10-Mar-2008
Fixed a bug in the read engine that would cause the excel file with chart to be corrupted. (Thanks to Thijs Janssen)
Version 2.6.7 29-Feb-2008
Fixed a bug introduced in 2.6.4 that would cause the excel file to be corrupted. (Thanks to Marshall Hayashi)
Version 2.6.6 17-Feb-2008
Some minor fixes for compatibility with third-party components. (Thanks to Raymond Schappe)
Version 2.6.5 06-Feb-2008
Some memory leaks fixed which may occur when an excel file with chart is opened. (Thanks to Steve Maughan)
Version 2.6.4 05-Feb-2008
Bug fixed: In some cases Cell is still locked even after unlocking (Thanks to Steve Maughan)
Version 2.6.3 04-Feb-2008
Bug fixed: Hyperlink.Address property in some cases may return an incorrect value (Thanks to Tien Hanh Pham)
Version 2.6.2 21-Jan-2008
Significant speed optimization for borders formatting (Thanks to Maria Ogarkova)
Version 2.6.1 14-Jan-2008
Some improvements were made to reduce size of excel files (Thanks to Vincent Blanc)
Bug fixed: Workbook with textbox may cause an exception. (Thanks to Robert Smith)
Read engine fix for excel files with incorrect style table. (Thanks to Sandy MacPherson)
Version 2.4.2 25-Nov-2006
Export engine has been improved. Added the code to convert the time format from Delphi to Excel syntax in TDBGrid2Excel and TDataset2Excel. (Thanks to Jordi Giro)
Bug fixed: Workbook protection may cause corruption of cell comments. (Thanks to Audreyn Justus)
Version 2.4.1 31-Oct-2006
Export engine has been improved. Changed the code to get the DisplayFormat from the Field in TDBGrid2Excel and TDataset2Excel. (Thanks to Jordi Giro)
Fixed a minor bug in the formula engine that may result in an unexpected dialog (in MS Office) prompting to save the changes. (Thanks to Robin Barker)
Fixed a bug in SUMIF, COUNTIF functions. (Thanks to Brad Wheeler)
IXLSRange.SaveAsCSV method has been added. » (Thanks to Richard Moore)
IXLSWorksheet.SaveAsCSV method has been added. » (Thanks to Richard Moore)
Bug fixed. In some cases NativeExcel may lost text values when excel file contains Asian phonetic information inside a Unicode string. (Thanks to Kogata Satoru)
Version 2.3.21 25-Jul-2006
Bug fixed. Charts with invalid linked data may cause an exception. (Thanks to Kogata Satoru)
Version 2.3.20 21-Jul-2006
IXLSRange.ShrinkToFit property has been added. » (Thanks to Kogata Satoru)
Bug fixed. In some cases (after Add operation), IXLSWorksheet.Index may contains an incorrect value. (Thanks to Kogata Satoru)
Version 2.3.19 18-Jul-2006
IXLSWorkbook.ReferenceStyle property has been added. » (Thanks to Kogata Satoru)
Bug fixed. In some cases TRUNC function may return an incorrect value.(Thanks to Joungsub Ju)
Calculation engine bug fixed. Incorrect behavior during comparision with Null values. (Thanks to Kogata Satoru)
Bug fixed. Read engine, in some cases, may cause EAccessViolation exception. (Thanks to Martin Dambach)
Version 2.3.18 07-Jul-2006
Bug fixed. In some cases TRUNC function may return an incorrect value.(Thanks to Joungsub Ju)
Version 2.3.17 06-Jul-2006
Now NativeExcel can preserve existing charts.
TDataset2Excel.VisibleFieldsOnly property has been added. » (Thanks to Anton Zibrov)
Version 2.3.16 01-Jul-2006
Fixed problem with OpenOffice 2.0.2.
(Sometimes OpenOffice 2.0.2 can't load the worksheet contents from excel file which produced by NativeExcel) (Thanks to Michael Vernersen, Thomas Doehler, John Bannister)
TDataset2Excel improved: Aligns detail cells according to the TField.Alignment property (Thanks to Anton Zibrov)
TDataset2Excel.HeaderSource property has been added. » (Thanks to Anton Zibrov)
Bug fixed: In some cases NativeExcel would load the wrong numeric value. (Thanks to Mauricio Harry Kan)
Version 2.3.15 23-Jun-2006
Calculation engine improved. Support of ROUND function has been added. (Thanks to Joungsub Ju)
Bug fixed: Duplication of VBA objects. (Thanks to Kogata Satoru)
Version 2.3.14 21-Jun-2006
Calculation engine improved. Support of TRUNC function has been added (Thanks to Joungsub Ju)
Calculation engine improved. Support of CONCATENATE function has been added (Thanks to Petr Filipi)
Bug fixed: worksheet doesn't load correctly if it contains charts. (Thanks to Kogata Satoru)
Version 2.3.13 19-Jun-2006
IXLSWorksheet.DisplayZeros property added » (Thanks to Kogata Satoru)
IXLSWorksheet.SaveAsHTML method now returns the code which indicates the result of operation. »
IXLSWorkbook.SaveAsHTML method now returns the code which indicates the result of operation. »
TDataset2Excel.SaveAs method now returns the code which indicates the result of operation. »
TDataset2Excel.SaveDatasetAs method now returns the code which indicates the result of operation. »
TDBGrid2Excel.SaveAs method now returns the code which indicates the result of operation. »
TDBGrid2Excel.SaveDBGridAs method now returns the code which indicates the result of operation. »
Version 2.3.12 17-May-2006
Bug fixed: Using PageSetup property in some cases caused an Access Violation error (Thanks to Bob Garth)
Fixed a memory allocation bug that could cause a crash. (Thanks to David Taylor)
Save and SaveAs methods now return the code which indicates the result of operation. (Thanks to Glenn Alcott)
inet40 package dependency has been removed from NativeExcel for Delphi4 (Thanks to Timothy Jones)
Version 2.3.11 19-Apr-2006
Bug fixed: NativeExcel would sometimes save the wrong numeric value (Thanks to KYUNG HWA LEE)
Version 2.3.10 13-Apr-2006
Bug fixed: In some cases ParseFormat return an incorrect string (Thanks to Maicon Gabriel Schmitz)
Bug fixed: NativeExcel causes ERangeError exception if it was compiled with "Range checking" option (Thanks to Warren Knauer)
Version 2.3.9 09-Apr-2006
Bug fixed: Opening files in the Excel 2003 occasionally results an unexpected "Name Conflict" dialog box (such as "Name cannot be the same as a built-in name...") (Thanks to Duilio Foschi)
Version 2.3.8 05-Apr-2006
Calculation engine improved. Support of TEXT, LEFT, RIGHT, COUNTA functions has been added (Thanks to Andreas Friedrich)
Formula compiler improved. Support for range with entire rows/columns has been added (examples: SUM($A:$A), COUNT(3:4))
Version 2.3.7 30-Mar-2006
Bug fixed: In some cases Read engine didn't load text values correctly. (Thanks to Tony Jinks)
Version 2.3.6 28-Mar-2006
Bug fixed: In some cases, Excel may not be able to change font settings. (Thanks to Jacek Choloniewski)
Version 2.3.5 26-Mar-2006
Calculation engine improved. Support of asterisk (*) wildcard characters in SUMIF, COUNTIF functions has been added. (Thanks to Todd J. Hanson)
Bug fixed: IXLSRange.Delete method didn't always work properly (Thanks to Robin Barker)
Some improvements were made to reduce size of excel files (Thanks to Robin Barker)
Version 2.3.4 13-Mar-2006
Read engine improved. Support of PrintArea, PrintTitleRows, PrintTitleColumns has been added (Thanks to Dirk Keulerz)
Version 2.3.3 09-Mar-2006
Read engine improved. Support of Font record with incorrect length has been added (Thanks to Andreas Friedrich)
Version 2.3.2 03-Mar-2006
Bug fixed: Using Cells property in some cases caused an Access Violation error (Thanks to Chris Russell)
Bug fixed: Empty pages in the print preview mode (Thanks to Robin Barker)
Bug fixed: Picture size is calculated with more accuracy
IXLSRange.Locked property added » (Thanks to Greg Buhlmann)
Optional Bitmap to PNG compression has been added.
To be able to convert and compress BMP to PNG image,
you have to install TPNGImage from
http://pngdelphi.sourceforge.net/
and recompile NativeExcel using {$DEFINE USEPNGLIB} option in xlsdef.inc file (Thanks to Gamma Computer)
Version 2.3.1 19-Feb-2006
Calculation engine improved. Support of COUNTIF, SUMIF functions has been added (Thanks to H.J. Fettelaar)
TXLSShapes.AddPicture method improved. EMF, VMF files support has been added. (Great thanks to the guys at Gamma Computer)
TXLSShapes.AddPicture overloaded methods added. Now you can use TBitmap as a picture source (Thanks to the guys at Gamma Computer)
Version 2.3.0 12-Feb-2006
Support for Delphi 2006 Win 32 Edition has been added
