| Constructor and Description |
|---|
CellIndex(int column,
boolean columnAbsolute,
int row,
boolean rowAbsolute)
Initializes a new instance of the
CellIndex class. |
CellIndex(int column,
int row)
Initializes a new instance of the
CellIndex class. |
CellIndex(java.lang.String reference)
Initializes a new instance of the
CellIndex class. |
| Modifier and Type | Method and Description |
|---|---|
boolean |
equals(java.lang.Object obj) |
int |
getColumn()
Gets zero-based index of the reference column.
|
boolean |
getColumnAbsolute()
Gets a value indicating whether the reference column is absolute.
|
static int |
getColumnIndex(java.lang.String columnLetter)
Returns the zero-based index of the column with the specified character representation.
|
static int |
getColumnIndex(java.lang.String value,
int start,
int length) |
static java.lang.String |
getColumnLetter(int columnIndex)
Returns the character representation of the specified column.
|
boolean |
getIsValid()
Gets a value indicating whether this object represents a valid cell reference.
|
int |
getRow()
Gets the zero-based index of the reference row.
|
boolean |
getRowAbsolute()
Gets a value indicating whether the reference row is absolute.
|
int |
hashCode() |
boolean |
isEqualTo(CellIndex other) |
static boolean |
op_Equality(CellIndex a,
CellIndex b) |
static boolean |
op_Inequality(CellIndex a,
CellIndex b) |
CellIndex |
toAbsolute()
Returns an equivalent CellIndex object with absolute rows and columns.
|
java.lang.String |
toOldStringFormat()
Returns a string representing the cell reference in the old format R1C1.
|
CellIndex |
toRelative()
Returns an equivalent
CellIndex object with relative rows and columns. |
java.lang.String |
toString() |
CellIndex |
translate(int dcolumn,
int drow)
Translates this cell reference by the specified amount, possibly producing an invalid reference.
|
static java.lang.String |
translate(java.lang.String value,
int dcolumn,
int drow)
Translates the cell reference, represented by the specified string,
by the specified amount and returns a string representing the translated value.
|
public static final CellIndex Invalid
public CellIndex(java.lang.String reference)
CellIndex class.public CellIndex(int column,
int row)
CellIndex class.public CellIndex(int column,
boolean columnAbsolute,
int row,
boolean rowAbsolute)
CellIndex class.public static java.lang.String translate(java.lang.String value,
int dcolumn,
int drow)
public CellIndex translate(int dcolumn, int drow)
public CellIndex toAbsolute()
public CellIndex toRelative()
CellIndex object with relative rows and columns.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(CellIndex other)
isEqualTo in interface com.mindfusion.common.Equatable<CellIndex>public static java.lang.String getColumnLetter(int columnIndex)
columnIndex - The zero-based index of the column.public static int getColumnIndex(java.lang.String columnLetter)
columnLetter - The character representation of the column.public static int getColumnIndex(java.lang.String value,
int start,
int length)
public int getColumn()
public boolean getColumnAbsolute()
public int getRow()
public boolean getRowAbsolute()
public boolean getIsValid()