You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2021/11/21 12:42:04 UTC
svn commit: r1895229 - /poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFComment.java
Author: fanningpj
Date: Sun Nov 21 12:42:03 2021
New Revision: 1895229
URL: http://svn.apache.org/viewvc?rev=1895229&view=rev
Log:
add comment tests
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFComment.java
Modified: poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFComment.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFComment.java?rev=1895229&r1=1895228&r2=1895229&view=diff
==============================================================================
--- poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFComment.java (original)
+++ poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFComment.java Sun Nov 21 12:42:03 2021
@@ -27,6 +27,7 @@ import static org.junit.jupiter.api.Asse
import static org.junit.jupiter.api.Assertions.assertTrue;
import java.io.IOException;
+import java.util.UUID;
import com.microsoft.schemas.vml.CTShape;
import org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream;
@@ -46,13 +47,16 @@ import org.apache.poi.xssf.XSSFITestData
import org.apache.poi.xssf.XSSFTestDataSamples;
import org.apache.poi.xssf.model.Comments;
import org.apache.poi.xssf.model.CommentsTable;
+import org.apache.poi.xssf.streaming.SXSSFCell;
+import org.apache.poi.xssf.streaming.SXSSFRow;
+import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.xmlbeans.XmlObject;
import org.junit.jupiter.api.Test;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRPrElt;
-public final class TestXSSFComment extends BaseTestCellComment {
+public final class TestXSSFComment extends BaseTestCellComment {
private static final String TEST_RICHTEXTSTRING = "test richtextstring";
@@ -351,4 +355,65 @@ public final class TestXSSFComment exten
}
}
}
+
+ @Test
+ void testMoveComment() throws Exception {
+ CommentsTable commentsTable = new CommentsTable();
+ try (SXSSFWorkbook workbook = new SXSSFWorkbook()) {
+ CreationHelper factory = workbook.getCreationHelper();
+ SXSSFSheet sheet = workbook.createSheet();
+ SXSSFRow row = sheet.createRow(0);
+ SXSSFCell cell = row.createCell(0);
+ ClientAnchor anchor = factory.createClientAnchor();
+ anchor.setCol1(0);
+ anchor.setCol2(1);
+ anchor.setRow1(row.getRowNum());
+ anchor.setRow2(row.getRowNum());
+ XSSFComment comment = commentsTable.createNewComment(sheet, anchor);
+ String uniqueText = UUID.randomUUID().toString();
+ comment.setString(uniqueText);
+ comment.setAuthor("author" + uniqueText);
+
+ XSSFComment comment1 = commentsTable.findCellComment(new CellAddress("A1"));
+ assertEquals(comment.getString().getString(), comment1.getString().getString());
+
+ comment.setAddress(1, 1);
+ assertNull(commentsTable.findCellComment(new CellAddress("A1")),
+ "no longer a comment on cell A1?");
+
+ XSSFComment comment2 = commentsTable.findCellComment(new CellAddress("B2"));
+ assertEquals(comment.getString().getString(), comment2.getString().getString());
+ }
+ }
+
+ @Test
+ void testMoveCommentCopy() throws Exception {
+ CommentsTable commentsTable = new CommentsTable();
+ try (SXSSFWorkbook workbook = new SXSSFWorkbook()) {
+ CreationHelper factory = workbook.getCreationHelper();
+ SXSSFSheet sheet = workbook.createSheet();
+ SXSSFRow row = sheet.createRow(0);
+ SXSSFCell cell = row.createCell(0);
+ ClientAnchor anchor = factory.createClientAnchor();
+ anchor.setCol1(0);
+ anchor.setCol2(1);
+ anchor.setRow1(row.getRowNum());
+ anchor.setRow2(row.getRowNum());
+ XSSFComment comment = commentsTable.createNewComment(sheet, anchor);
+ String uniqueText = UUID.randomUUID().toString();
+ comment.setString(uniqueText);
+ comment.setAuthor("author" + uniqueText);
+
+ XSSFComment comment1 = commentsTable.findCellComment(new CellAddress("A1"));
+ assertEquals(comment.getString().getString(), comment1.getString().getString());
+
+ //like testMoveComment but moves the copy of the comment (comment1) instead
+ comment1.setAddress(1, 1);
+ assertNull(commentsTable.findCellComment(new CellAddress("A1")),
+ "no longer a comment on cell A1?");
+
+ XSSFComment comment2 = commentsTable.findCellComment(new CellAddress("B2"));
+ assertEquals(comment.getString().getString(), comment2.getString().getString());
+ }
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org