Validations not working with xvExcel97

[CarstenG]

For compatibility-reasons, our application has to support xvExcel97 as well as xvExcel2007.

With xvExcel2007, validations are working properly (as far as i have tested it).
But when i try to write validations into or read validations from an xvExcel97-file using 5.20.13, the result is empty (XLS[0].validations.count = 0).
To verify this issue, simply prepare an Excel-file with a validation and then do the test as follows:

Code: Select all

procedure TForm1.btnReadClick(Sender: TObject);
begin
  FExcel.Filename := 'MyTest.xls';
  FExcel.Read;

  If (FExcel[0].Validations.Count > 0) then
    ShowMessage('Success: ' + IntToStr(FExcel[0].Validations.Count))
  else
    ShowMessage('Bad: ' + IntToStr(FExcel[0].Validations.Count));
end;

[larsa]

Hello

Validations in Excel 97 files are in the XLS.BIFF.Sheet[0].Validations property. Keeping validations in a common object is on the todo list. Hope to have this ready soon.