I'm using the HSSFDataValidation to add dropdown to the cells of two columns.
The values of the Dropdown in the first column come from a cell range of an other sheet, the values of the dropDown in the second column are declared fix using an array.
The excel file (xls) will be exported without errors.
If I open the generated file using Excel 2010 the Dropdowns are present.
If I save the file, Excel has a problem with the campatibility of some features.
If I open this saved file (xls too) the dropdowns with the static values are present,
but the dropdowns which depends on the second sheet are gone.