Lookup lists

[stevef199]

I've got some code to implement lookup lists, but either its not complete or not correct:

My code:

Code: Select all

    dv := xlsreadwrite.Sheets[0].Validations.Add;
    with dv do
    begin
      Formula1 := '$R$275:$R$276';
      Sqref.Add(0, 0);
      ShowDropDown := True;
      Type_ := x12dvtList;

      AllowBlank := False;
    end;

This code correctly puts the settings for Data Validation in Excel for cell $A$1, but the dropdown arrow (combobox) is missing, and needs to be manually selected in Excel in the Data Validation dialog box.

If someone could help me by pointing what is required to do additionally to get this working, I'd be grateful.

TIA.

[larsa]

Hello

This is fixed in update 5.20.13