You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2013/08/23 20:52:19 UTC
svn commit: r1516978 -
/poi/trunk/src/testcases/org/apache/poi/hssf/util/TestCellReference.java
Author: nick
Date: Fri Aug 23 18:52:18 2013
New Revision: 1516978
URL: http://svn.apache.org/r1516978
Log:
Add some explicit tests for column letter to/from number conversion
Modified:
poi/trunk/src/testcases/org/apache/poi/hssf/util/TestCellReference.java
Modified: poi/trunk/src/testcases/org/apache/poi/hssf/util/TestCellReference.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/hssf/util/TestCellReference.java?rev=1516978&r1=1516977&r2=1516978&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/hssf/util/TestCellReference.java (original)
+++ poi/trunk/src/testcases/org/apache/poi/hssf/util/TestCellReference.java Fri Aug 23 18:52:18 2013
@@ -26,6 +26,25 @@ import org.apache.poi.ss.SpreadsheetVers
public final class TestCellReference extends TestCase {
+ public void testColNumConversion() {
+ assertEquals(0, CellReference.convertColStringToIndex("A"));
+ assertEquals(1, CellReference.convertColStringToIndex("B"));
+ assertEquals(25, CellReference.convertColStringToIndex("Z"));
+ assertEquals(26, CellReference.convertColStringToIndex("AA"));
+ assertEquals(27, CellReference.convertColStringToIndex("AB"));
+ assertEquals(51, CellReference.convertColStringToIndex("AZ"));
+ assertEquals(701, CellReference.convertColStringToIndex("ZZ"));
+ assertEquals(702, CellReference.convertColStringToIndex("AAA"));
+ assertEquals(18277, CellReference.convertColStringToIndex("ZZZ"));
+
+ assertEquals("A", CellReference.convertNumToColString(0));
+ assertEquals("B", CellReference.convertNumToColString(1));
+ assertEquals("Z", CellReference.convertNumToColString(25));
+ assertEquals("AA", CellReference.convertNumToColString(26));
+ assertEquals("ZZ", CellReference.convertNumToColString(701));
+ assertEquals("AAA", CellReference.convertNumToColString(702));
+ assertEquals("ZZZ", CellReference.convertNumToColString(18277));
+ }
public void testAbsRef1(){
CellReference cf = new CellReference("$B$5");
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org