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...
Status: RESOLVED WORKSFORME
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-15 01:49 UTC by Every Moment
Modified: 2012-09-15 15:27 UTC (History)
0 users


Attachments
POI 3.8 wrap error java source code (2.38 KB, application/octet-stream)
2012-09-15 01:49 UTC, Every Moment 		Details
screenshot (94.30 KB, image/png)
2012-09-15 06:14 UTC, Yegor Kozlov 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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]
screenshot
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.