You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2017/09/16 08:20:06 UTC
svn commit: r1808500 -
/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java
Author: centic
Date: Sat Sep 16 08:20:06 2017
New Revision: 1808500
URL: http://svn.apache.org/viewvc?rev=1808500&view=rev
Log:
Add test for question on the mailing-list
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java
Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java?rev=1808500&r1=1808499&r2=1808500&view=diff
==============================================================================
--- poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java (original)
+++ poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFHyperlink.java Sat Sep 16 08:20:06 2017
@@ -17,28 +17,22 @@
package org.apache.poi.xssf.usermodel;
-import static org.junit.Assert.assertEquals;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.fail;
-
-import java.io.IOException;
-
import org.apache.poi.common.usermodel.HyperlinkType;
import org.apache.poi.hssf.usermodel.HSSFHyperlink;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.openxml4j.opc.PackageRelationship;
import org.apache.poi.openxml4j.opc.PackageRelationshipCollection;
-import org.apache.poi.ss.usermodel.BaseTestHyperlink;
-import org.apache.poi.ss.usermodel.Cell;
-import org.apache.poi.ss.usermodel.CreationHelper;
-import org.apache.poi.ss.usermodel.Hyperlink;
-import org.apache.poi.ss.usermodel.Row;
+import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellAddress;
import org.apache.poi.ss.util.CellReference;
import org.apache.poi.xssf.XSSFITestDataProvider;
import org.apache.poi.xssf.XSSFTestDataSamples;
import org.junit.Test;
+import java.io.IOException;
+
+import static org.junit.Assert.*;
+
public final class TestXSSFHyperlink extends BaseTestHyperlink {
public TestXSSFHyperlink() {
super(XSSFITestDataProvider.instance);
@@ -84,6 +78,7 @@ public final class TestXSSFHyperlink ext
for(int i = 0; i < rels.size(); i++){
PackageRelationship rel = rels.getRelationship(i);
// there should be a relationship for each URL
+ assertNotNull(rel);
assertEquals(urls[i], rel.getTargetURI().toString());
}
@@ -95,6 +90,7 @@ public final class TestXSSFHyperlink ext
for(int i = 0; i < rels.size(); i++){
PackageRelationship rel = rels.getRelationship(i);
// there should be a relationship for each URL
+ assertNotNull(rel);
assertEquals(urls[i], rel.getTargetURI().toString());
}
}
@@ -114,7 +110,7 @@ public final class TestXSSFHyperlink ext
createHelper.createHyperlink(HyperlinkType.URL).setAddress(s);
fail("expected IllegalArgumentException: " + s);
} catch (IllegalArgumentException e){
-
+ // expected here
}
}
workbook.close();
@@ -333,4 +329,47 @@ public final class TestXSSFHyperlink ext
wb.close();
}
+
+ @Test
+ public void test() throws IOException {
+ XSSFWorkbook wb = new XSSFWorkbook();
+
+ CreationHelper createHelper = wb.getCreationHelper();
+ XSSFCellStyle hlinkStyle = (XSSFCellStyle) wb.createCellStyle();
+ Font hlinkFont = wb.createFont();
+
+ Sheet sheet = wb.createSheet("test");
+
+ Row rowDet = sheet.createRow(0);
+
+ Cell cellDet = rowDet.createCell(7);
+ cellDet.setCellValue("http://www.google.at");
+ //set up style to be able to create hyperlinks
+ hlinkFont.setColor(IndexedColors.BLUE.getIndex());
+ hlinkStyle.setFont(hlinkFont);
+ Hyperlink link = createHelper.createHyperlink(HyperlinkType.URL);
+ link.setAddress("http://www.example.com");
+ cellDet.setHyperlink(link);
+ cellDet.setCellStyle(hlinkStyle);
+
+ //set up style to be able to create hyperlinks
+ hlinkFont.setColor(IndexedColors.BLUE.getIndex());
+ hlinkStyle.setFont(hlinkFont);
+ link = createHelper.createHyperlink(HyperlinkType.URL);
+
+ //string for hyperlink
+ cellDet = rowDet.createCell(13);
+ cellDet.setCellValue("http://www.other.com");
+ link.setAddress("http://www.gmx.at");
+ cellDet.setHyperlink(link);
+ cellDet.setCellStyle(hlinkStyle);
+
+ XSSFWorkbook wbBack = XSSFTestDataSamples.writeOutAndReadBack(wb);
+
+ assertNotNull(wbBack.getSheetAt(0).getRow(0).getCell(7).getHyperlink());
+ assertNotNull(wbBack.getSheetAt(0).getRow(0).getCell(13).getHyperlink());
+
+ wb.close();
+ wbBack.close();
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org