| Constructor and Description |
|---|
CellRef(CellIndex cellIndex)
Initializes a new instance of the
CellRef class. |
CellRef(CellIndex topLeft,
CellIndex bottomRight)
Initializes a new instance of the
CellRef class. |
CellRef(CellIndex topLeft,
CellIndex bottomRight,
java.lang.String sheetRef)
Initializes a new instance of the
CellRef class. |
CellRef(CellIndex topLeft,
CellIndex bottomRight,
java.lang.String sheetRef,
CellRefType refType)
Initializes a new instance of the CellRef class with a specified reference type.
|
CellRef(CellIndex cellIndex,
java.lang.String sheetRef)
Initializes a new instance of the
CellRef class. |
CellRef(int column,
int row)
Initializes a new instance of the
CellRef class. |
CellRef(int topLeftColumn,
int topLeftRow,
int bottomRightColumn,
int bottomRightRow)
Initializes a new instance of the
CellRef class. |
CellRef(int topLeftColumn,
int topLeftRow,
int bottomRightColumn,
int bottomRightRow,
java.lang.String sheetRef)
Initializes a new instance of the
CellRef class. |
CellRef(int column,
int row,
java.lang.String sheetRef)
Initializes a new instance of the
CellRef class. |
CellRef(java.lang.String reference)
Initializes a new instance of the
CellRef class. |
| Modifier and Type | Method and Description |
|---|---|
boolean |
contains(CellIndex cellIndex) |
boolean |
contains(CellRef cellRef) |
boolean |
contains(int column,
int row) |
boolean |
contains(java.lang.String sheetName,
int column,
int row) |
boolean |
equals(java.lang.Object obj) |
static CellRef |
fromRange(java.lang.String start,
java.lang.String end)
Initializes a new instance of the CellRef class from range endpoints.
|
static CellRef |
fromRange(java.lang.String start,
java.lang.String end,
java.lang.String sheetRef)
Initializes a new instance of the CellRef class from range endpoints.
|
int |
getBottom()
Gets the bottom side of the range.
|
CellIndex |
getBottomRight()
Gets the bottom-right side of the range.
|
int |
getHeight()
Gets the height of the range.
|
int |
getLeft()
Gets the left side of the range.
|
CellRefType |
getRefType()
Gets the reference type.
|
int |
getRight()
Gets the right side of the range.
|
java.lang.String |
getSheetRef()
Gets the name of the reference sheet (if available).
|
int |
getTop()
Gets the top side of the range.
|
CellIndex |
getTopLeft()
Gets the top-left cell of the range.
|
int |
getWidth()
Gets the width of the range.
|
int |
hashCode() |
CellRef |
intersect(CellRef cellRef) |
CellRef |
intersect(int column,
int row) |
boolean |
intersectsWith(CellRef cellRef) |
boolean |
isColumnVector()
Gets a value indicating whether the range is a column vector, that is, it has exactly one column.
|
boolean |
isEqualTo(CellRef other) |
boolean |
isMatrix()
Gets a value indicating whether the range is an actual matrix, that is, it has at least 2 rows and 2 columns.
|
boolean |
isPoint()
Gets a value indicating whether the range represents a single cell.
|
boolean |
isRowVector()
Gets a value indicating whether the range is a row vector, that is, it has exactly one row.
|
boolean |
isValid()
Gets a value indicating whether the range is a valid reference.
|
static boolean |
isValidRef(java.lang.String value)
Checks whether the specified value represents a valid cell reference.
|
boolean |
isWholeColumn()
Gets a value indicating whether the range represents an entire column or columns.
|
boolean |
isWholeRow()
Gets a value indicating whether the range represents an entire row or rows.
|
static CellRef |
makeAbsolute(int topLeftColumn,
int topLeftRow,
int bottomRightColumn,
int bottomRightRow,
java.lang.String sheetRef) |
static CellRef |
makeAbsolute(int topLeftColumn,
int topLeftRow,
int bottomRightColumn,
int bottomRightRow,
java.lang.String sheetRef,
CellRefType refType) |
CellRef |
normalize(java.lang.String sheetRef)
|
static boolean |
op_Equality(CellRef a,
CellRef b) |
static boolean |
op_Inequality(CellRef a,
CellRef b) |
CellRef |
refactorSheet(java.lang.String oldName,
java.lang.String newName) |
CellRef |
renameSheet(java.lang.String sheetName)
|
CellRef |
toAbsolute()
Returns an equivalent
CellRef object with absolute rows and columns. |
java.lang.String |
toOldStringFormat()
Returns a string representing the cell range in the old format R1C1.
|
CellRef |
toRelativeAndLocal()
Returns an equivalent
CellRef object with relative rows and columns, and no sheet reference. |
java.lang.String |
toString() |
CellRef |
translate(int dcolumn,
int drow)
Translates the cell reference, by the specified amount and returns a string representing the translated value.
|
public static final CellRef Invalid
public CellRef(java.lang.String reference)
CellRef class.public CellRef(int column,
int row)
CellRef class.public CellRef(int column,
int row,
java.lang.String sheetRef)
CellRef class.public CellRef(CellIndex cellIndex, java.lang.String sheetRef)
CellRef class.public CellRef(CellIndex topLeft, CellIndex bottomRight)
CellRef class.public CellRef(CellIndex topLeft, CellIndex bottomRight, java.lang.String sheetRef)
CellRef class.public CellRef(CellIndex topLeft, CellIndex bottomRight, java.lang.String sheetRef, CellRefType refType)
public CellRef(int topLeftColumn,
int topLeftRow,
int bottomRightColumn,
int bottomRightRow)
CellRef class.public CellRef(int topLeftColumn,
int topLeftRow,
int bottomRightColumn,
int bottomRightRow,
java.lang.String sheetRef)
CellRef class.public static CellRef fromRange(java.lang.String start, java.lang.String end)
public static CellRef fromRange(java.lang.String start, java.lang.String end, java.lang.String sheetRef)
public static CellRef makeAbsolute(int topLeftColumn, int topLeftRow, int bottomRightColumn, int bottomRightRow, java.lang.String sheetRef)
public static CellRef makeAbsolute(int topLeftColumn, int topLeftRow, int bottomRightColumn, int bottomRightRow, java.lang.String sheetRef, CellRefType refType)
public java.lang.String toString()
toString in class java.lang.Objectpublic java.lang.String toOldStringFormat()
public int hashCode()
hashCode in class java.lang.Objectpublic boolean equals(java.lang.Object obj)
equals in class java.lang.Objectpublic boolean isEqualTo(CellRef other)
isEqualTo in interface com.mindfusion.common.Equatable<CellRef>public static boolean isValidRef(java.lang.String value)
public CellRef toAbsolute()
CellRef object with absolute rows and columns.public CellRef toRelativeAndLocal()
CellRef object with relative rows and columns, and no sheet reference.public CellRef normalize(java.lang.String sheetRef)
public CellRef translate(int dcolumn, int drow)
public CellRef renameSheet(java.lang.String sheetName)
public CellRef refactorSheet(java.lang.String oldName, java.lang.String newName)
public boolean contains(CellIndex cellIndex)
public boolean contains(CellRef cellRef)
public boolean contains(java.lang.String sheetName,
int column,
int row)
public boolean contains(int column,
int row)
public CellRef intersect(int column, int row)
public boolean intersectsWith(CellRef cellRef)
public boolean isMatrix()
public boolean isRowVector()
public boolean isColumnVector()
public boolean isPoint()
public boolean isValid()
public int getLeft()
public int getRight()
public int getTop()
public int getBottom()
public int getWidth()
public int getHeight()
public CellIndex getTopLeft()
public CellIndex getBottomRight()
public java.lang.String getSheetRef()
public CellRefType getRefType()
public boolean isWholeColumn()
public boolean isWholeRow()