Bug 53873 - Setting wrap in a cell via POI 3.8 does not wrap when Excel 2010 reads the file. Works in POI 3.7.
Summary: Setting wrap in a cell via POI 3.8 does not wrap when Excel 2010 reads the fi...
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2012-09-15 01:49 UTC by Every Moment
Modified: 2012-09-15 15:27 UTC (History)
0 users

POI 3.8 wrap error java source code (2.38 KB, application/octet-stream)
2012-09-15 01:49 UTC, Every Moment
screenshot (94.30 KB, image/png)
2012-09-15 06:14 UTC, Yegor Kozlov

Note You need to log in before you can comment on or make changes to this bug.
Description Every Moment 2012-09-15 01:49:25 UTC
Created attachment 29377 [details]
POI 3.8 wrap error java source code

The attached sample program: (a) creates a new HSSF Workbook with one sheet and 100 cells, (b) sets cell F6 to a wrap style, (c) stores a long string into F6, and (d) saves the workbook to wraptest.xls. Excel 2010 is then used to read wraptest.xls. If the program is compiled with POI 3.7 on the CLASSPATH, Excel 2010 correctlly wraps cell F6. With POI 3.8 on the CLASSPATH instead, Excel 2010 does not wrap cell F6.
Comment 1 Yegor Kozlov 2012-09-15 06:13:22 UTC
I can't reproduce the problem with the latest build form trunk, see attached screenshot.

The links to nightly builds are on the POI web site: http://poi.apache.org/
Comment 2 Yegor Kozlov 2012-09-15 06:14:24 UTC
Created attachment 29378 [details]
Comment 3 Every Moment 2012-09-15 15:27:13 UTC
I agree: POI HSSF wrap works correctly in the nightly build called poi-3.9-beta1-20120915.jar  
Thanks, Yegor.