XLSReadWriteII.v4.0.21

XLSReadWriteII 4.0 4.00.21 ! Formats in files exported from Open Office didn't work. ! In XLSX files, the Author text was hard coded to "larsa". ! Some XLSX files casued a "list index out of bounds" exception. ! Large (+100000 rows) XLSX files could result in an "out of stack space" exception. 4.00.20 ! Excel 2007 files with the error value #N/A caused an error in written files. 4.00.19 ! Name property on drawing objects now shows the assigned name. ! Sheet name where wrong on some cell names. 4.00.18 ! "CONTINUE record is missing" exception when reading files with large notes. 4.00.17 ! Problem when using spaces in formulas. 4.00.16 ! Empty strings caused an error when opened with Excel 2003. 4.00.15 ! Entering some formulas didn't work correct. ! Read -> Write of some Excel 2007 files could cause errors in the written file. 4.00.14 ! InsertRows/InsertColumns adjusted formulas wrong in some sitiations. 4.00.12 ! Files from Excel 2007 saved in Excel 97 format could result in error message when opened in Excel ("Some formats where deleted..."). 4.00.11 ! Fixes a bug introduced in 4.00.10 that casued an exception when reading some files. 4.00.10 + Multiple print areas can now be defined. In order to define more than one area, separate the areas with the ListSeparator character. Example: with XLS.InternalNames.Add do begin BuiltInName := bnPrintArea; Definition := 'Sheet1!$A$1:$D$10' + ListSeparator + 'Sheet1!$A$12:$D$20'; end; ! Some files with metafile pictures where not correct written. ! Combo boxes didn't work. 4.00.09 + Speed optimization when grouping rows. 4.00.08 + PNGImage and ZLib are now distributed with the package. ! Fixed error "Unknown default record" when reading back files created with the component. 4.00.07 + More speed optimization when reading Excel 2007 files. + Speed optimization when writing Excel 2007 files. 4.00.06 ! Integer cells where not written correct in Excel 2007 files. 4.00.05 + Speed optimization when reading Excel 2007 files. ! Exception "Duplicate tag" on some Excel 2007 files. 4.00.04 ! It was not possible to run more than one instance of an application (with XLSReadWriteII) that read Excel 2007 file. ! Exception on reading some Excel 4.0 files. ! Some rare files with pictures could result in "Expected record missing: BLIP" exception. 4.00.03 ! Some formulas didn't work. 4.00.02 ! Defined names where the first part looked like a cell ref didn't work. ! Fixed problems when adding rows. 4.00.01 ! Fixed problems with formulas in files with chart sheets. 4.00.00 + Support for Excel 2007 XML files. 3.01.05 ! Fixes error introduced in 3.01.04, exceprtion when reading files with graphics. 3.01.04 ! Files with notes didn't work in Excel 2003 and later. 3.01.03 ! Hyperlinks pointing to disk files where not encoded correct. 3.01.02 ! Fixed problem with files that had the message "File error, some data may be lost" when opened in excel. 3.01.01 ! Some rare excel files could have corrupt string cells. 3.01.00 + The component now has a built in unzip library, and can hence read Open Office files without external zip components. ! Adding some formulas could cause errors. ! Check boxes where not read correctly (not acceciable from the interface). 3.00.07 ! Calculating formulas with unary operators could result in an exception. 3.00.06 *** These bugs was introduced in 3.00.05 *** ! Reading files could cause an exception. ! Error when adding formulas with parantheses. 3.00.05 + New property in Notes, AlwaysVisible. ! Some graphics in a file could cause an exception. ! AsHTML could result in an exception. 3.00.04 ! When setting border style in a Range, the color is now set to xcAutomatic as default. 4.00.00 + Support for Excel 2007 XML file format. 3.00.03 ! Setting row height by pixels didn't work. 3.00.02 ! Some rare metafile pictures could cause an exception. ! Some calculations that included string values gave wrong results. 3.00.01 ! Deleting a chart serie resulted in an exception. ! Adding chart series could result in an error message when the file was opened in excel. ! When reading a non existent file, there was no default worksheet, and accessing cells resulted in an exception. ! Adding formulas with percent operator resulted in an exception. ! When exporting to HTML, background colors where wrong. ! The property PrintSettings.StartingPage didn't work. ! Memory leak when deleting rows. 3.00.0 + New printer options, FitWidth and FitHeight. + Margins can be set on Text Boxes. + LineColor and FillColor properties for notes and text boxes. + Rotation property for drawing objects. + Copy print settings between sheets. + Check Boxes and Radio Buttons can be used. + AutoRowHeight and AutoRowsHeight + AutoSizeCell for single cells. + Import and Export of CSV files. + New property AsHyperlink + Format areas (Range property) + XLS.Abort method for abort file reading. Useful if a password not is know, as calling Abort not will generate an exception. + Master-detail in db-import. Formatting. + Encrypted files can be created. + Import of Open Office Calc files (This requires an unzip component, such as the free Abbrevia). + Read and write macros. + Autofilter. + Files can now be marked as recomend read only. Property XLS.RecomendReadOnly. + Same set of samples for C++ Builder as for Delphi. + Improved documentation ! Result of array formulas could not be read correct. ! Built in names bnPrintTitles and bnPrintArea could not be used both at the same time. ! Creating frozen panes didn't work. ! Files with cell validations could result in corrupt files when sheets where copied. ! Problems when using files with Word Mail Merge. ! Some expressions where not calculated correct. ! When calculating, there was an exception on some functions that had a reference as argument. ! Cells formatted with national currency symbols did not show currency symbol. ! Problems with OnProgress ! Excel 4 files with notes could not be read. ! Notes and other drawing objects could not be deleted. 2.02.35 ! Time cells formatted with milliseconds where not handled correct. ! Deleted internal names (#REF!A1) caused an exception. ! TInternalName.Definition is changed from string to WideString. This fixes some problems with unicode sheet names in formulas. ! When calculating, functions with empty argumetnts could cause an exception. 2.02.34 + New property XLS.Workbook.Date1904. This property is True if the 1904 date system is used. ! Some files with metafile (EMF) pictures could cause an exception. ! Some rare encrypted files could not be decrypted. 2.02.33 + The speed when adding internal names has improved. Both when adding names in the component, and when the file later is opened with excel. When adding many names, put the code that adds name between calls to BeginUpdate and EndUpdate. Example: InternalNames.BeginUpdate; for i:= 1 to 10000 do begin XLS.InternalNames.Name:= 'Test'+ IntToStr(i); XLS.InternalNames.Definition:= 'Sheet1!$A$' + IntToStr(i); end; XLS.InternalNames.EndUpdate; 2.02.32 ! Array entered formulas could not be read from a cell. 2.02.31 ! SheetByName did not work correctly with Delphi 5. ! Contols with macros, such as buttons, didn't work correctly after an internal name was deleted. ! XLS.Sheets[x].Charts[x].Series[x].SerieName sometimes retuned wrong value. 2.02.30 + New property XLSReadWriteII.Sheets[x].IsDateTime This property returns True if the cell is formattet as a date or time value. ! Some formulas could cause an exception (bug introduced in 2.02.29). 2.02.29 ! Writing files with array formulas could result in corrupt files. 2.02.28 ! When the localized time format was AM/PM, the AsDateTime property set wrong cell format. 2.02.27 ! Some files with pictures