From 203358443efbc84922069549783e1a773fdfa4dc Mon Sep 17 00:00:00 2001 From: Javen O'Neal Date: Mon, 23 Nov 2015 15:45:30 +0000 Subject: [PATCH] fixed bad test case in BaseTestSheet.getCellComments git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1715854 13f79535-47bb-0310-9956-ffa450edef68 --- .../org/apache/poi/ss/usermodel/BaseTestSheet.java | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheet.java b/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheet.java index c875f03ed9..87340c9a6b 100644 --- a/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheet.java +++ b/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheet.java @@ -1036,6 +1036,7 @@ public abstract class BaseTestSheet { Workbook workbook = _testDataProvider.createWorkbook(); Sheet sheet = workbook.createSheet("TEST"); Drawing dg = sheet.createDrawingPatriarch(); + ClientAnchor anchor = workbook.getCreationHelper().createClientAnchor(); int nRows = 5; int nCols = 6; @@ -1044,11 +1045,20 @@ public abstract class BaseTestSheet { sheet.createRow(r); // Create columns in reverse order for (int c=nCols-1; c>=0; c--) { - Comment comment = dg.createCellComment(workbook.getCreationHelper().createClientAnchor()); + // When the comment box is visible, have it show in a 1x3 space + anchor.setCol1(c); + anchor.setCol2(c); + anchor.setRow1(r); + anchor.setRow2(r); + + // Create the comment and set the text-author + Comment comment = dg.createCellComment(anchor); Cell cell = sheet.getRow(r).createCell(c); comment.setAuthor("Author " + r); RichTextString text = workbook.getCreationHelper().createRichTextString("Test comment at row=" + r + ", column=" + c); comment.setString(text); + + // Assign the comment to the cell cell.setCellComment(comment); } } -- 2.39.5