Bug 45004

Summary:	Dropdowns defined in template are thrown away
Product:	POI	Reporter:	Michael Bjerregaard-Pedersen <mbp>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	P2
Version:	3.0-FINAL
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Attachments:	Excel-file with dropdowns

Description Michael Bjerregaard-Pedersen 2008-05-15 06:18:16 UTC

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. :-(

Comment 1 Michael Bjerregaard-Pedersen 2008-05-15 06:19:12 UTC

Created attachment 21969 [details]
Excel-file with dropdowns

Comment 2 Josh Micich 2008-05-15 11:56:41 UTC

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 ***