acoliver 02/04/29 17:14:54
Modified: src/testcases/org/apache/poi/hssf/util
TestReferenceUtil.java
Log:
must have missed a commit yesterday...oops
Revision Changes Path
1.2 +66 -0
jakarta-poi/src/testcases/org/apache/poi/hssf/util/TestReferenceUtil.java
Index: TestReferenceUtil.java
===================================================================
RCS file:
/home/cvs/jakarta-poi/src/testcases/org/apache/poi/hssf/util/TestReferenceUtil.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- TestReferenceUtil.java 28 Apr 2002 19:09:09 -0000 1.1
+++ TestReferenceUtil.java 30 Apr 2002 00:14:54 -0000 1.2
@@ -147,6 +147,72 @@
}
+ /**
+ * checks that area reference conversion works
+ */
+ public void testGetXYXYFromAreaRef(){
+ String ref = null;
+
+ ref = "A1:B1";
+
+ assertEquals("fromRef A1 row = 0",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[0],
+ 0);
+
+ assertEquals("fromRef A1 col = 0",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[1],
+ 0);
+
+ assertEquals("fromRef A1 col = 0",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[2],
+ 0);
+
+
+ assertEquals("fromRef A1 col = 0",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[3],
+ 1);
+
+
+ ref = "A1:Z11";
+
+ assertEquals("fromRef A1 row = 0",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[0],
+ 0);
+
+ assertEquals("fromRef A1 col = 0",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[1],
+ 0);
+
+
+ assertEquals("fromRef Z11 row = 10",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[2],
+ 10);
+
+ assertEquals("fromRef Z11 col = 25",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[3],
+ 25);
+
+ ref = "Z11:IV256";
+
+ assertEquals("fromRef Z11 row = 10",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[0],
+ 10);
+
+ assertEquals("fromRef Z11 col = 25",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[1],
+ 25);
+
+
+ assertEquals("fromRef IV256 row = 255",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[2],
+ 255);
+
+ assertEquals("fromRef IV256 col = 255",
+ ReferenceUtil.getXYXYFromAreaRef(ref)[3],
+ 255);
+
+ }
+
public static void main(String [] args) {
System.out
.println("Testing org.apache.poi.hssf.util.ReferenceUtil");
