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 2015/03/22 22:45:57 UTC
svn commit: r1668481 - in /poi/trunk:
src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java
test-data/spreadsheet/49423.xls
Author: centic
Date: Sun Mar 22 21:45:56 2015
New Revision: 1668481
URL: http://svn.apache.org/r1668481
Log:
Add test from bug 49423 to verify that the problem was fixed in the meantime
Added:
poi/trunk/test-data/spreadsheet/49423.xls
Modified:
poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java
Modified: poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java?rev=1668481&r1=1668480&r2=1668481&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java (original)
+++ poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java Sun Mar 22 21:45:56 2015
@@ -28,6 +28,7 @@ import static org.apache.poi.POITestCase
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
+import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
@@ -1106,4 +1107,36 @@ public final class TestHSSFWorkbook exte
private void expectName(HSSFWorkbook wb, String name, String expect) {
assertEquals(expect, wb.getName(name).getRefersToFormula());
}
+
+ @Test
+ public void test49423() throws Exception
+ {
+ HSSFWorkbook workbook = HSSFTestDataSamples.openSampleWorkbook("49423.xls");
+
+ boolean found = false;
+ int numSheets = workbook.getNumberOfSheets();
+ for (int i = 0; i < numSheets; i++) {
+ HSSFSheet sheet = workbook.getSheetAt(i);
+ List<HSSFShape> shapes = sheet.getDrawingPatriarch().getChildren();
+ for(HSSFShape shape : shapes){
+ HSSFAnchor anchor = shape.getAnchor();
+
+ if(anchor instanceof HSSFClientAnchor){
+ // absolute coordinates
+ HSSFClientAnchor clientAnchor = (HSSFClientAnchor)anchor;
+ assertNotNull(clientAnchor);
+ //System.out.println(clientAnchor.getRow1() + "," + clientAnchor.getRow2());
+ found = true;
+ } else if (anchor instanceof HSSFChildAnchor){
+ // shape is grouped and the anchor is expressed in the coordinate system of the group
+ HSSFChildAnchor childAnchor = (HSSFChildAnchor)anchor;
+ assertNotNull(childAnchor);
+ //System.out.println(childAnchor.getDy1() + "," + childAnchor.getDy2());
+ found = true;
+ }
+ }
+ }
+
+ assertTrue("Should find some images via Client or Child anchors, but did not find any at all", found);
+ }
}
Added: poi/trunk/test-data/spreadsheet/49423.xls
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/49423.xls?rev=1668481&view=auto
==============================================================================
Binary files poi/trunk/test-data/spreadsheet/49423.xls (added) and poi/trunk/test-data/spreadsheet/49423.xls Sun Mar 22 21:45:56 2015 differ
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org