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/08/10 14:22:25 UTC
svn commit: r1892179 -
/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java
Author: fanningpj
Date: Tue Aug 10 14:22:25 2021
New Revision: 1892179
URL: http://svn.apache.org/viewvc?rev=1892179&view=rev
Log:
add test
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java
Modified: poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java?rev=1892179&r1=1892178&r2=1892179&view=diff
==============================================================================
--- poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java (original)
+++ poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java Tue Aug 10 14:22:25 2021
@@ -396,44 +396,84 @@ public final class TestXSSFHyperlink ext
@Test
void testChangeReference() throws IOException {
- try (XSSFWorkbook wb = new XSSFWorkbook()) {
- XSSFHyperlink hyperlink = new XSSFHyperlink(HyperlinkType.URL);
- hyperlink.setCellReference("B2");
- assertEquals(1, hyperlink.getFirstRow());
- assertEquals(1, hyperlink.getLastRow());
- assertEquals(1, hyperlink.getFirstColumn());
- assertEquals(1, hyperlink.getLastColumn());
- hyperlink.setFirstRow(0);
- assertEquals("B1:B2", hyperlink.getCellRef());
- assertEquals(0, hyperlink.getFirstRow());
- assertEquals(1, hyperlink.getLastRow());
- assertEquals(1, hyperlink.getFirstColumn());
- assertEquals(1, hyperlink.getLastColumn());
- hyperlink.setLastRow(2);
- assertEquals("B1:B3", hyperlink.getCellRef());
- assertEquals(0, hyperlink.getFirstRow());
- assertEquals(2, hyperlink.getLastRow());
- assertEquals(1, hyperlink.getFirstColumn());
- assertEquals(1, hyperlink.getLastColumn());
- hyperlink.setFirstColumn(0);
- assertEquals("A1:B3", hyperlink.getCellRef());
- assertEquals(0, hyperlink.getFirstRow());
- assertEquals(2, hyperlink.getLastRow());
- assertEquals(0, hyperlink.getFirstColumn());
- assertEquals(1, hyperlink.getLastColumn());
- hyperlink.setLastColumn(2);
- assertEquals("A1:C3", hyperlink.getCellRef());
- assertEquals(0, hyperlink.getFirstRow());
- assertEquals(2, hyperlink.getLastRow());
- assertEquals(0, hyperlink.getFirstColumn());
- assertEquals(2, hyperlink.getLastColumn());
- hyperlink.setFirstColumn(2);
- hyperlink.setFirstRow(2);
- assertEquals("C3", hyperlink.getCellRef());
- assertEquals(2, hyperlink.getFirstRow());
- assertEquals(2, hyperlink.getLastRow());
- assertEquals(2, hyperlink.getFirstColumn());
- assertEquals(2, hyperlink.getLastColumn());
- }
+ XSSFHyperlink hyperlink = new XSSFHyperlink(HyperlinkType.URL);
+ hyperlink.setCellReference("B2");
+ assertEquals(1, hyperlink.getFirstRow());
+ assertEquals(1, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setFirstRow(0);
+ assertEquals("B1:B2", hyperlink.getCellRef());
+ assertEquals(0, hyperlink.getFirstRow());
+ assertEquals(1, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setLastRow(2);
+ assertEquals("B1:B3", hyperlink.getCellRef());
+ assertEquals(0, hyperlink.getFirstRow());
+ assertEquals(2, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setFirstColumn(0);
+ assertEquals("A1:B3", hyperlink.getCellRef());
+ assertEquals(0, hyperlink.getFirstRow());
+ assertEquals(2, hyperlink.getLastRow());
+ assertEquals(0, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setLastColumn(2);
+ assertEquals("A1:C3", hyperlink.getCellRef());
+ assertEquals(0, hyperlink.getFirstRow());
+ assertEquals(2, hyperlink.getLastRow());
+ assertEquals(0, hyperlink.getFirstColumn());
+ assertEquals(2, hyperlink.getLastColumn());
+ hyperlink.setFirstColumn(2);
+ hyperlink.setFirstRow(2);
+ assertEquals("C3", hyperlink.getCellRef());
+ assertEquals(2, hyperlink.getFirstRow());
+ assertEquals(2, hyperlink.getLastRow());
+ assertEquals(2, hyperlink.getFirstColumn());
+ assertEquals(2, hyperlink.getLastColumn());
+ }
+
+ @Test
+ void testChangeRowsAndColumns() throws IOException {
+ XSSFHyperlink hyperlink = new XSSFHyperlink(HyperlinkType.URL);
+ hyperlink.setCellReference("B2");
+ hyperlink.setLastRow(0);
+ assertEquals("B1", hyperlink.getCellRef());
+ assertEquals(0, hyperlink.getFirstRow());
+ assertEquals(0, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setLastColumn(0);
+ assertEquals("A1", hyperlink.getCellRef());
+ assertEquals(0, hyperlink.getFirstRow());
+ assertEquals(0, hyperlink.getLastRow());
+ assertEquals(0, hyperlink.getFirstColumn());
+ assertEquals(0, hyperlink.getLastColumn());
+ hyperlink.setFirstRow(1);
+ assertEquals("A2", hyperlink.getCellRef());
+ assertEquals(1, hyperlink.getFirstRow());
+ assertEquals(1, hyperlink.getLastRow());
+ assertEquals(0, hyperlink.getFirstColumn());
+ assertEquals(0, hyperlink.getLastColumn());
+ hyperlink.setFirstColumn(1);
+ assertEquals("B2", hyperlink.getCellRef());
+ assertEquals(1, hyperlink.getFirstRow());
+ assertEquals(1, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setLastRow(2);
+ assertEquals("B2:B3", hyperlink.getCellRef());
+ assertEquals(1, hyperlink.getFirstRow());
+ assertEquals(2, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(1, hyperlink.getLastColumn());
+ hyperlink.setLastColumn(2);
+ assertEquals("B2:C3", hyperlink.getCellRef());
+ assertEquals(1, hyperlink.getFirstRow());
+ assertEquals(2, hyperlink.getLastRow());
+ assertEquals(1, hyperlink.getFirstColumn());
+ assertEquals(2, hyperlink.getLastColumn());
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org