java - Apache poi excel 注释换行文本

Question

如何确保评论栏足够大以显示评论？我搜索了一些属性，例如换行文本，但没有成功。

if(drawingPatriarch == null)
{
    drawingPatriarch = sh.createDrawingPatriarch();
}

HSSFClientAnchor anchor = new HSSFClientAnchor();

anchor.setCol1(cell.getColumnIndex());
anchor.setCol2(cell.getColumnIndex()+1);
anchor.setRow1(row.getRowNum());
anchor.setRow2(row.getRowNum()+3);

Comment cellComment = drawingPatriarch.createCellComment(anchor);
cellComment.setString(new HSSFRichTextString(comment));
if(author != null)
    cellComment.setAuthor(author);

cell.setCellComment(cellComment);

Answer 1

http://poi.apache.org/spreadsheet/quick-guide.html

CellStyle wrapText=workbookWrite.createCellStyle();
wrapText.setWrapText(true);
cellComment.setCellStyle(wrapText);