Bug 59852

Summary: Comments resized when Row.setZeroHeight() hides row
Product: POI Reporter: David Ross <davidr>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: 3.15-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description David Ross 2016-07-13 17:44:15 UTC
If a cell comment is added which spans several rows or columns, and one of those rows or columns is then hidden, the comment's size is reduced.  The same scenario within Excel does not result in the comment shrinking.

The calls I am using:

Spreadsheet.makeComment(row, c, comment, h, w, f);
sheet.getRow(i).setZeroHeight(true);