public class CellReference
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
static class |
CellReference.NameType
Used to classify identifiers found in formulas as cell references or not.
|
Constructor and Description |
---|
CellReference(Cell cell) |
CellReference(int pRow,
int pCol) |
CellReference(int pRow,
int pCol,
boolean pAbsRow,
boolean pAbsCol) |
CellReference(int pRow,
short pCol) |
CellReference(java.lang.String cellRef)
Create an cell ref from a string representation.
|
CellReference(java.lang.String pSheetName,
int pRow,
int pCol,
boolean pAbsRow,
boolean pAbsCol) |
Modifier and Type | Method and Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
static boolean |
cellReferenceIsWithinRange(java.lang.String colStr,
java.lang.String rowStr,
SpreadsheetVersion ssVersion)
Used to decide whether a name of the form "[A-Z]*[0-9]*" that appears in a formula can be
interpreted as a cell reference.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
static CellReference.NameType |
classifyCellReference(java.lang.String str,
SpreadsheetVersion ssVersion)
Classifies an identifier as either a simple (2D) cell reference or a named range name
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
static int |
convertColStringToIndex(java.lang.String ref)
takes in a column reference portion of a CellRef and converts it from
ALPHA-26 number format to 0-based base 10.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
static java.lang.String |
convertNumToColString(int col)
Takes in a 0-based base-10 column and returns a ALPHA-26
representation.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
boolean |
equals(java.lang.Object o)
Checks whether this cell reference is equal to another object.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
java.lang.String |
formatAsString()
Example return values:
Copyright © 2005-2010 Potix Corporation. All Rights Reserved. |