Bug 54422

Summary: HSSFCellStyle::setWrapText seems to be broken in 3.8
Product: POI Reporter: littlenoodles <ryampolsky>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.8-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: produced with poi-3.6
produced with poi-3.8

Description littlenoodles 2013-01-15 18:20:22 UTC
Created attachment 29854 [details]
produced with poi-3.6

I recently went from using poi-3.2 to poi-3.8, and the behavior of HSSFCellSTyle::setWrapText seems to have changed.  Excel used to auto-size the height of the row in order to display all the wrapping text the first time you opened the xls.  Now it doesn't.  If you manually resize the row height, the wrapping text shows up.

I tried backing off to poi-3.6, and setWrapText seems to work there like it used to in 3.2.

I'm attaching 2 documents - both generated with the same code, but one using poi-3.6 and one using poi-3.8.  The column headers (light gray row 8) wrap in the 3.6 version, but don't wrap in the 3.8 version.
Comment 1 littlenoodles 2013-01-15 18:21:28 UTC
Created attachment 29855 [details]
produced with poi-3.8
Comment 2 littlenoodles 2013-01-15 18:26:38 UTC
I just tried it with poi-3.9, and the wrapping column headers seem to work again.