Axolot Data

Hi

I'm working hard to convert a lot of units of my project from version 4 to version 5 of XLSReadWriteII. I list many itens that are not listed in Changes.txt.

TXLSReadWriteII5.Font.ColorRGB
changed to
TXLSReadWriteII5.Font.Color (and we must create a object of type TXc12Color to set this color...)

TXLSRows.AddIfNone
method was eliminated, correct ? i comment it, but don't verify if new compilation works fine or not without this...

TCellType
changed to
TXLSCellType

if (Cell[Col,Row] is TFormulaCell) then
changed to
if (CellType[Col,Row] in [xctFloatFormula,xctStringFormula,xctBooleanFormula,xctErrorFormula]) then

TXLSColumn
property HorizAlignment
changed to Style.Alignment.HorizAlignment

TXLSRange
property FormatOptions := [foWrapText]
changed to TXLSRange.WrapText := True;

TXLSReadWrite.Workbook.Options
changed to
TXLSReadWrite.WorkbookData.Options

TXLSProgressEvent have new assign:
procedure (AProgressType: TXLSProgressType; AProgressState: TXLSProgressState; AValue: double) of object

TXLSReadWrite.Sheet[s].Autofilters
changed to
TXLSReadWrite.BIFF.Sheet[s].Autofilters (i'm affraid if it works...)

TXLSReadWrite.PreserveMacros
changed to
TXLSReadWrite.BIFF5.PreserveMacros (i'm affraid if it works...)

TXLSReadWrite.MSOPictures
changed to
TXLSReadWrite.BIFF5.MSOPictures (i'm affraid if it works...)

with TXLSReadWrite.Items[s].ConditionalFormats.Add do
changed to
with TConditionalFormat(FXLSReadWrite.Items[s].ConditionalFormats.Add)

Alignments:
TCellHorizAlignment changed to TXc12HorizAlignment
TCellVertAlignment changed to TXc12VertAlignment

Validation types:
vopEqual changed to x12dvoEqual
vsStop changed to x12dvesStop
vtInteger changed to x12dvtDecimal

Lars, can u please analyse this list and give me a feedback if i'm correct with this approaches ?

Thanks

Hello

1. Yes, you have to assign a TXc12Color to TXLSReadWriteII5.Font.Color in order to set the color. Please note that this font object is the default font for all other formats, and possibly other things. Avoid to change it unless that's whet you really want.

2. AddifNone is not required anymore. The method is only included for compatibility. It does nothing.

Yes, on the rest of your questions.

Just be aware that the BIFF property is nil when creating an excel file from scratch, it is only created by the Load methods.
So if like us, you use XLSReadWrite to create excel files, keep in mind that only what's available in TXLSReadWriteII5 can be used safely.