What's new in XLSReadWrite 6
Apr 6, 2017
- Support for pivot tables.
- New component: TXLSGrid. This is like a simpler version of XLSSpreadSheet where you can view cells, pictures and text boxes. Based on TDrawGrid.
- You can now copy entire worksheets from other files (instances of XLSReadWriteII). Use the Assign method.
- New RTF importer and exporter where you can import entire documents to a worksheet, including tables in RTF files.
- Support for charts in XLSX files.
- Support fo encrypted XLSX files.
- And more
New in XLSReadWrite 5.20.00 (Sep 21, 2013)
- Full support for conditional formats. See new sample for more details.
- New property in CmdFormat, SetRowHeight. When True (default is False) the row height will be set to the max height of the text in the row. This is same as AutoHeightRow.
- The height will not be changed if the row height is excplicit set.
- More properties in FXLS.CmdFormat.Number for easier creating number formats:
- Decimals
- Thousands
- NegativeColor
- CurrencySymbolLCID (Currency symbol for the selected country)
- Percentage
- Fractions
- Scientific
- DirectWrite can now use format cells. See sample for details.
- Converting Excel 97 files to Excel 2007 could result in error message (invalid styles) when opened in excel.
- Excel 97 files with merged cells could cause problems when converted to Excel 2007.
- Some files with charts created with Excel 2010 could not b read.
- Files could not be read when opened with ADO, "External table is not in the expected format".
New in XLSReadWrite 5.10.29 (Sep 21, 2013)
- Unknown Attributes exxception.
- Some small numbers where not correct stored.
- Number formats where not shown correct.
New in XLSReadWrite 5.10.28 (Sep 21, 2013)
- Optimized reading and writing of hyperlinks.
- Optimized CmdFormat.ApplyCols.
- Worksheets could not be added to Excel 97 files.
New in XLSReadWrite 5.10.27 (Sep 21, 2013)
- CmdFormat.ApplyCols and CmdFormat.ApplyRows didn't update existing cells.
- Calling CmdFormat.ApplyCols twice could result in corrupt files.
- Vertical page breaks didn't work in Excel 97 files.
New in XLSReadWrite 5.10.26 (Sep 21, 2013)
- Some non-excel apps could show wrong formatting on numbers in Excel 97 files.
New in XLSReadWrite 5.10.25 (Sep 21, 2013)
- If rows or columns where deleted, merged cells where not adjusted correct.
- If columns where deleted, cells in rows after row 255 where not deleted.
- CmdFormat can now be used to format columns and rows. Use CmdFormat.ApplyCols(Col1,Col2) or CmdFormat.ApplyRows(Row1,Row2)
New in XLSReadWrite 5.10.24 (Sep 21, 2013)
- Excel 97 files that are auto emcrypted with the password "VelvetSweatshop" are auto decrypted.
- Some rare Excel 97 could cause an exception on Free.
New in XLSReadWrite 5.10.23 (Sep 21, 2013)
- Reading files with charts could result in an "unknown attribute Val" exception.
- Setting print orientation didn't work in Excel 97 files.