Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 44510] New: Reading and writing file with Dropdown doesn't work
 in 3.0
 .2 anymore
Message-ID: <bug-44510-47293@https.issues.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Date: Fri, 29 Feb 2008 05:47:00 -0800 (PST)

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