Bug 52626

Summary: Cannot Set Default Row Height of Sheet with sheet.defaultRowHeight()
Product: POI Reporter: fitrah.pro
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.7-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description fitrah.pro 2012-02-08 19:05:23 UTC
I'm using Apache POI 3.7 with Spring MVC 3.1.

I've tried sheet.setDefaultRowHeight((short) 100) and sheet.setDefaultRowHeightInPoints(100)

but that doesn't work.

What exactly are those methods used for?

Thank you.
Comment 1 Yegor Kozlov 2012-02-12 11:18:41 UTC
It was a bug. POI wrote the value of default row height but did not set a special flag that tells Excel to use it: without this flag Excel ignores the overridden height and uses the default. 

The problem should be fixed in r1243240

Yegor