more cleanup and refactoring of the ooxml code:1. removed deprecated methods from xssf and interfaces

2. minimized the accessibility of internal constructors
3. more javadocs


git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@707839 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 17 insertions, 0 deletions

diff --git a/src/java/org/apache/poi/ss/util/CellRangeAddress.java b/src/java/org/apache/poi/ss/util/CellRangeAddress.java
index 41c2f63ea2..0d910c6824 100644
--- a/src/java/org/apache/poi/ss/util/CellRangeAddress.java
+++ b/src/java/org/apache/poi/ss/util/CellRangeAddress.java
@@ -50,4 +50,21 @@ public class CellRangeAddress extends CellRangeAddressBase {
 	public static int getEncodedSize(int numberOfItems) {
 		return numberOfItems * ENCODED_SIZE;
 	}
+
+    public String formatAsString() {
+        StringBuffer sb = new StringBuffer();
+        CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn());
+        CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn());
+        sb.append(cellRefFrom.formatAsString());
+        sb.append(':');
+        sb.append(cellRefTo.formatAsString());
+        return sb.toString();
+    }
+
+    public static CellRangeAddress valueOf(String ref) {
+        int sep = ref.indexOf(":");
+        CellReference cellFrom = new CellReference(ref.substring(0, sep));
+        CellReference cellTo = new CellReference(ref.substring(sep + 1));
+        return new CellRangeAddress(cellFrom.getRow(), cellTo.getRow(), cellFrom.getCol(), cellTo.getCol());
+    }
 }