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