I load the attached excel file I put some data in the some cells, but never the ones defined as dropdowns. I write the workbook to a new file The output excel file doesn't have any dropdowns. This is a different behaviour from the earlier POI version I was using (2.0). My problem resembles 29065, and judging from 10214 I can't work around the problem programmatically. :-(
Created attachment 21969 [details] Excel-file with dropdowns
Re-tested OK in 3.1-beta1. I assume this spreadsheet has 4 'data validation' drop-downs. I could reproduce this problem in 3.0.2 (4 drop-downs go missing). This is probably the same as bug 44510 which was fixed in svn r633151. *** This bug has been marked as a duplicate of bug 44510 ***