poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 44510] New: Reading and writing file with Dropdown doesn't work in 3.0 .2 anymore
Date Fri, 29 Feb 2008 13:47:00 GMT

           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: dev@poi.apache.org
        ReportedBy: michael.hunziker@trivadis.com

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");

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

Am I doing anything wrong?


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message