https://issues.apache.org/bugzilla/show_bug.cgi?id=44510
Summary: Reading and writing file with Dropdown doesn't work in
3.0.2 anymore
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=21602)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=21602)
Cell G6 contains a simple dropdown. Reading and writing back to a new xls
doesn't work in 3.0.2
I'd like to read a simple Excel file containing a dropdown list (data
validation) and write it back into a new one. The whole thing worked with POI
3.0.1 but not in
with the new POI revision 3.0.2:
1. Read a simple Excel-file with dropdown:
InputStream input = MyClass.class.getResourceAsStream(
"simple_dropdown.xls" );
POIFSFileSystem fs = new POIFSFileSystem( input );
HSSFWorkbook wb = new HSSFWorkbook(fs);
2. Write the Excel file into another file:
FileOutputStream out = new FileOutputStream("output.xls");
wb.write(out);
out.close();
Now, here's the thing:
- My Excel file only contains a dropdown-list, no further special formatting or
other stuff!
- If i do the steps above with POI 3.0.1, the dropdown list still exists
in the output file
- If i do the exact same thing with POI 3.0.2, the dropdown is gone in the
output-file. The cell only contains the value which was selected in the input
file. The validation rule of the cell is also gone, it is set back to "any
value".
Am I doing anything wrong?
Michael
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
