Free Support Forum - aspose.com

Data validation lists (JAVA)

Dear Laurence,



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.



Thanks,

Ulf




Dear Ulf,

We will fix this problem soon.