XLSReadWriteII 6.0
6.01.13
+ Improvements on HTML import.
6.01.10
! Can not find font.
6.01.09
+ User fonts for Comments. See Comments sample for details.
6.01.08
! Invalid XLSX when reading/writing files with pivot tables multiple times.
6.01.05
! Exception when reading some files.
6.01.04
! Exception when reading some files.
6.01.03
! Warning when opening files in Excel with pivot tables.
6.01.02
! Chart gridlines properties where not written.
6.01.01
+ Delete images and other graphics. Use: XLS[0].Drawing.Delete(Col1,Row1,Col2,Row2);
6.00.70
! Unexpected end of file in XML.
6.00.69
+ New property XLS[0].TabSelected Use it to select if the worksheet tab in Excel is selected or not.
6.00.68
! Hyperlinks where not adjusted whenn inserting rows.
6.00.67
! Missing autofilters in pivot tables.
6.00.66
! Text in cells with CR/LF could be double.
6.00.65
! "Empty stack" error when calculating SUBTOTAL.
6.00.62
! Wrong text in cells with multiple lines.
! Error when opening some files in Excel with pivot tables.
6.00.61
! Extremely slow reading on some files.
6.00.60
+ VBA (macros) in XLSM files can now be read. Please study the Macros sample.
6.00.58
! Creating macros didn't work.
6.00.57
! Error in Excel when reading some files with pivot tables.
! Duplicate file "nnn" in Zip.
! Copying merged cells didn't work.
6.00.55
! Cell is missing/is of wrong type exception when using Assign.
6.00.54
! (2) Excel crashed when printing some files.
6.00.53
! Exception when opening files created by G-Suite.
6.00.52
! Excel crashed when printing some files.
6.00.50
! Corrupt files when saving some charts.
6.00.48
! Hyperlinks was not adjusted correct after deleting rows.
6.00.47
! Line breaks in XLS files could be lost.
6.00.45
! Decrypt files encrypted with the component didn't work.
6.00.44
! Changing palette colors could result in invalid files.
6.00.43
! InsertColumns didn't work correct.
! Reading encrypted files didn't work.
! Setting Wrap text to false when formatting cells didn't work.
6.00.42
+ Min and max width/height can now be set with AutoWidtCol(s) and AutoHeightRow(s)
! Some formula functions in Excel 97 files didn't work.
6.00.41
! "Unknown function" error when calculating some excel 97 files.
6.00.40
! Fixes some issues with shapes.
6.00.39
! Negative numbers in arrays didn't work correct.
! Strings in some non-excel saved files didn't work correct.
6.00.38
! Exception when calculating some formulas.
6.00.37
! Text attributes in charts could be lost.
6.00.36
! Deleting sheets with defined names in XLS files could create corrupt files.
6.00.35
! Rows and columns where not scrolled correct in TXLSGrid.
! Wrong placement of pictures in Excel 97 files.
6.00.34
! Exception when reading some files with charts.
6.00.33
! Column width could be wrong after deleting columns.
6.00.32
! When deleting columns could an extra column be deleted.
6.00.31
! CR was lost in some non standard excel files.
6.00.30
! Yet another effort to fix the merged cells when deleting rows.
! Unwanted diagonal borders when using XLS.CmdFormat.Border.Preset(cbspOutlineAndInside);
6.00.29
! A new effort to fix the merged cells when deleting rows.
! Formulas where not adjusted when using CopyRows.
! Changes to the index color palette was not saved.
6.00.28
! Formulas where not adjusted when using CopyRows.
6.00.27
! Again, Merged cells where not deleted when rows or columns where deleted.
! Missing right parentheses error in formulas.
6.00.26
+ It's now possible to create 3D pie charts.
! Merged cells where not deleted when rows or columns where deleted.
! Names could be wrong adjusted when rows or columns where deleted.
! Exception when reading charts with series with cell list values.
6.00.25
! Inserting shapes did not work.
6.00.24
! Fixed some issues with charts using multiple value axis.
! Diagonal borders did not work with XLS files.
6.00.23
! TXLSCmdFormat didn't work with diagonal borders.
! Cells with empty strings where returned as CR.
6.00.22
! Import Open Office/Libre Office Calc files (ODS). This have been missing for some time.
6.00.21
! Stacked charts where not saved correct.
6.00.20
! Wrong color when importing RTF files.
6.00.19
+ New method: TXLSReadWriteII5.GetSheetNames(const AFilename: AxUCString; AList: TStrings): integer;
This method will only read the sheet names of an Excel file. This is much faster on large files than opening the file in the regular way.
The sheet names are copied to AList. Returns the number of sheets in the workbook.
6.00.18
! Exception when reading files with some unusual formulas.
6.00.17
! Deleting sheets on workbooks with print titles could result in an exception.
6.00.16
! Excel crashed when printing files generated by the component.
6.00.15
+ New feature: Text boxes in charts.
6.00.14
! RTF import: Bold and italic text where not turned off on some none MS Word files.
6.00.13
+ Method for easier setting the font of chart areas: SetChartFont (unit XLSDrawing).
! Wrong cell color when writing Excel 97 (XLS) files
! IsEmpty didn't return correct value.
6.00.12
! Warning in excel when opening some pivot files saved with the component.
! Importing RTF files created with TRichEdit component had missing formatting.
! Fixed compiler warnings and hints.
6.00.11
! Exception when calling IsDateTime on empty cells.
6.00.10
+ New property IgnoreErrorNumbersAsText. When True, it tells Excel to not mark (green mark) cells with a text value that looks like a number.
! Converting XLS files to XLSX didn't work. To do a convert, use SaveToFile(AStream: TStream; AVersion: TExcelVersion) with AVersion = xvExcel2007.
! Visibility property didn't work on XLS files.
6.00.09
! Error when copying cells.
6.00.08
! Fixed some potential issues with AnsiChar typecast.
6.00.07
! Exception on inserting rows.
6.00.06
! Sheet names with apostrophes didn't work in formulas.
! Files with signed macros was not saved correct.
6.00.05
+ New property in TXLSDbRead5, OnDbColumn. Can be used to reorder the columns on the worksheet.
6.00.04
+ New property XLS.LocalizedFormulas Use it changing the decimal and list separator characters. When True, system is used. When False, dot and comma is used.
! Pictures positions could be lost.
! Number formats with string literals didn't work correct.
6.00.03
! Again fixed error: "Unexpected end of file in XML"
6.00.02
! Formatting cells could miss to merge row or column formats.
6.00.01
! Setting print areas didn't work on sheet names with spaces.
! Fixed error: "Unexcpected end of file in XML"
6.00.00
First release