added HSSF usermodel tests for array formulas, added support for array formulas in ss interfaces

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

1 files changed, 23 insertions, 0 deletions

diff --git a/src/java/org/apache/poi/ss/util/CellReference.java b/src/java/org/apache/poi/ss/util/CellReference.java
index d01cca3540..e542962cba 100644
--- a/src/java/org/apache/poi/ss/util/CellReference.java
+++ b/src/java/org/apache/poi/ss/util/CellReference.java
@@ -22,6 +22,7 @@ import java.util.regex.Pattern;
 
 import org.apache.poi.hssf.record.formula.SheetNameFormatter;
 import org.apache.poi.ss.SpreadsheetVersion;
+import org.apache.poi.ss.usermodel.Cell;
 
 /**
  *
@@ -113,6 +114,10 @@ public class CellReference {
 	public CellReference(int pRow, short pCol) {
 		this(pRow, pCol & 0xFFFF, false, false);
 	}
+    
+    public CellReference(Cell cell) {
+        this(cell.getRowIndex(), cell.getColumnIndex(), false, false);
+    }
 
 	public CellReference(int pRow, int pCol, boolean pAbsRow, boolean pAbsCol) {
 		this(null, pRow, pCol, pAbsRow, pAbsCol);
@@ -483,4 +488,22 @@ public class CellReference {
 		}
 		sb.append(_rowIndex+1);
 	}
+
+    /**
+     * Checks whether this cell reference is equal to another object.
+     * <p>
+     *  Two cells references are assumed to be equal if their string representations
+     *  ({@link #formatAsString()}  are equal.
+     * </p>
+     */
+    @Override
+    public boolean equals(Object o){
+        if(o == null || !(o instanceof CellReference)) {
+            return false;
+        }
+
+        String me = formatAsString();
+        String anotherRef = ((CellReference)o).formatAsString();
+        return me.equals(anotherRef);
+    }
 }