Bug 53518

Summary: Method to autosize cell comments
Product: POI Reporter: Ralf Rublack <info>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: enhancement    
Priority: P2    
Version: 3.7-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Ralf Rublack 2012-07-07 12:21:52 UTC
Please add some functionality to auto-size cell comment on comment length.

Because comments size depends on column and row size, sometimes comments are not 
readable. Especial if Clientanchor is not given position and size, it's set to row 0 and column 0 with the size of it.
Comment 1 Javen O'Neal 2015-11-23 06:10:58 UTC
I'm having a difficult time understanding what you want POI to do here. Could you include some code to demonstrate the problem you're experiencing?

As you pointed out, Comment [1] and ClientAnchor [2] don't have an autosize method. What are you doing right now to determine the ideal size of your Comment?

[1] https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Comment.html#getClientAnchor%28%29
[2] https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/ClientAnchor.html