The attached file has been created with Aspose Excel. The cell A1 to A3
contains the values “alt1”, “alt2” and “alt3”. The cell A4 contains a
data validation list with the formula =$A$1:$A$3. When opening the file
in Excel it is not possible to select any of the values from the list
in cell A4. Nothing happens when I click the drop down icon. However,
if I select the cell, select Data -> Validations… and simply click
ok in the opened dialog the list starts to work.
We will fix this problem soon.