Fixed a bug with Save method for OpenXML spreadsheets. (Thanks to Ireneusz Cieśluk)
Fixed a bug where defined name with dot would fail.
Fixed a minor bug which might cause a memory leak in some cases. (Dariusz Młyński)
Version 3.0.25 15-Nov-2011
Support for functions from external workbook has been added. (Thanks to Grant Tregay)
Version 3.0.24 03-Oct-2011
Fixed a bug which caused formulas with Add-on functions not to load. (Thanks to Gerald Koeder)
Version 3.0.23 27-Sep-2011
Calculation engine has been improved.
Support for YIELD, PRICE, COUPDAYS, COUPDAYSNC, COUPDAYBS, COUPPDC, COUPNDC, COUPNUM
functions has been added.
Version 3.0.22 18-Sep-2011
Calculation engine now uses stored formula values for xlsx files without recalculation until the workbook is not modified. (Thanks to Grant Tregay)
Version 3.0.21 31-Aug-2011
Fixed a bug with long passwords (more than 15 symbols). (Thanks to Mauricio Macedo)
Version 3.0.20 11-Aug-2011
Fixed a bug with PageSetup.PrintGridlines property for XLSX file format.(Thanks to Grant Tregay)
Fixed a bug which caused unexpected output to console.(Thanks to Grant Tregay)
Fixed a bug with PageSetup.FitToPagesTall and PageSetup.FitToPagesWide properties for XLSX file format.(Thanks to Grant Tregay)
Version 3.0.19 19-Jul-2011
Some minor fixes for Autofit method. (Thanks to Grant Tregay)
IXLSWorkbook.VBAProject property has been added (access to VBA project content). (Thanks to Gerald Koeder)
Version 3.0.18 10-Jun-2011
Non-printing ASCII-15 characters removed from source code. (Thanks to Grant Tregay)
Some fixes related to scientific number formats and number formats which contain '*' and '_' characters. . (Thanks to Grant Tregay)
Delphi XE and 2007 binaries added to the installation module.
Version 3.0.17 26-May-2011
The maximum value for RowsPerSheet property in Dataset2Excel and DBGrid2Excel was increased (from 65535 to 1048575). (Thanks to Lenildo Barboza)
IXLSWorksheet.View property has been added.(Thanks to Grant Tregay)
Version 3.0.16 20-May-2011
Fixed a bug with border formatting (setting border weight to xlThin doesn't create border). (Thanks to Colin Briede)
Some important changes to improve Autofit methods. (Thanks to Grant Tregay)
Calculation engine now uses the stored value in the formula without recalculation until the workbook is not modified. (Thanks to Martin Aignesberger, Steve Maughan)
Version 3.0.15 12-May-2011
Fixed a bug which might cause EIntOverflow exception (Thanks to Norm Bernstein)
Formula compiler now supports numbers in scientific (exponential) notation (e.g. 1.2e+3) (Thanks to Mikhail Merkuryev)
Fixed a bug with xlSlantDashDot line style for borders (Thanks to Grant Tregay)
Some minor changes to avoid compiler warnings. (Thanks to Grant Tregay)
Version 3.0.14 26-Apr-2011
Fixed an exception during debugging in Delphi IDE (Thanks to Norm Bernstein)
Version 3.0.13 24-Apr-2011
Formula engine has been improved. Support for the functions from Analysis ToolPak add-in has been added.
Code that caused an exception during debugging in Delphi IDE has been rewritten.
Demo version now can be used outside of Delphi IDE.
Version 3.0.12 04-Apr-2011
Compiler Warnings fixed in Delphi XE (Thanks to Grant Tregay)
Fixed a bug which might cause wrong row height in third party excel viewers. (Thanks to Michael Perrier)
Version 3.0.11 14-Mar-2011
Some minor fixes for TDBGrid2Excel and TDataset2Excel (Thanks to Sandi Sorsak)
Version 3.0.10 13-Mar-2011
XLSX reading speed has been improved (in our tests up to 10 times faster).
XLSX writing speed has been improved (in our tests up to 6 times faster).
Fixed a bug in version 3.0.9 which might cause XLSX file reading failure.
Version 3.0.9 01-Mar-2011
TDBGrid2Excel and TDataset2Excel have been improved. Support for ftTimeStamp fields has been added. (Thanks to Sandi Sorsak)
Fixed a bug in IXLSRange.Insert function which might cause workbook corruption. (Thanks to Radovan Antloga)
Version 3.0.8 10-Feb-2011
Fixed a bug: IRange.Value returns Double instead of TDateTime. (Thanks to Robert Smith)
Fixed a bug which might cause in some cases wrong formattig or workbook corruption. (Thanks to Steve Maughan)
Version 3.0.7 12-Jan-2011
Fixed a bug in the package for Delphi XE. (NativeExcelD2011.dpk) (Thanks to Claudio Piffer, Werner Frinder)
Version 3.0.6 02-Jan-2011
Fixed a bug in the RTF export which might cause an I/O error 5. (Thanks to Sandi Sorsak)
Version 3.0.5 27-Dec-2010
Fixed a bug in the formula loader which might cause a problem with CHOOSE function.
Bug fixed: Delete and Insert methods don't affect hyperlinks position. (Thanks to Vladimir Aksenov)
Bug fixed: Command buttons lose attached macro. (Thanks to Vladimir Aksenov)
Fixed a bug which might cause in some cases wrong text encoding. (Thanks to Konstantin Makarenkov)
Version 3.0.4 beta 07-Nov-2010
Some fixes for IXLSRange.Merge method (Thanks to Rich Alderton)
Version 3.0.3 beta 02-Oct-2010
Support of Delphi XE has been added.
IXLSRange.Delete method has been fixed. (Thanks to Michael Tang)
Some minor fixes for LineStyle, Weight, ColorIndex and Color
properties in IXLSBorder and IXLSBorders interfaces. (Thanks to Rael Bauer)
IXLSRange.Delete method was completely rewritten.
IXLSRange.Insert method was completely rewritten.
Fixed LineStyle, Weight, ColorIndex and Color
properties for IXLSBorder and IXLSBorders interfaces.
Now they return an exact value only when all
borders in the specified range have the same property value,
otherwise they return undefined value:
xlLineStyleUndefined, xlBorderWeightUndefined, 0 and $000000
respectively. (Thanks to Rael Bauer)
Fixed a bug in IXLSRange.Delete method.
Export to RTF file format has been improved (support of images added).(Thanks to Iouri Elkine)
Calculation engine has been improved. Support of EXP function added.(Thanks to Malte Rathke)
IXLSRange.Delete method has been completely rewritten.(Thanks to Rael Bauer, Grefte M.M.)
Some minor fixes for IXLSRange.Autofit method. (Thanks to Ceyhun Mamedov)
IXLSRange.Width property has been added. (Thanks to Rael Bauer)
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
