java.lang.String |
formatAsString()
Example return values:
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
AreaReference
public AreaReference(java.lang.String reference)
- Create an area ref from a string representation. Sheet names containing special characters should be
delimited and escaped as per normal syntax rules for formulas.
The area reference must be contiguous (i.e. represent a single rectangle, not a union of rectangles)
AreaReference
public AreaReference(CellReference topLeft,
CellReference botRight)
- Creates an area ref from a pair of Cell References.
isContiguous
public static boolean isContiguous(java.lang.String reference)
- Is the reference for a contiguous (i.e.
unbroken) area, or is it made up of
several different parts?
(If it is, you will need to call
generateContiguous(String) )
getWholeRow
public static AreaReference getWholeRow(java.lang.String start,
java.lang.String end)
getWholeColumn
public static AreaReference getWholeColumn(java.lang.String start,
java.lang.String end)
isWholeColumnReference
public static boolean isWholeColumnReference(CellReference topLeft,
CellReference botRight)
- Is the reference for a whole-column reference,
such as C:C or D:G ?
isWholeColumnReference
public boolean isWholeColumnReference()
generateContiguous
public static AreaReference[] generateContiguous(java.lang.String reference)
- Takes a non-contiguous area reference, and
returns an array of contiguous area references.
isSingleCell
public boolean isSingleCell()
- Returns:
false if this area reference involves more than one cell
getFirstCell
public CellReference getFirstCell()
- Returns:
- the first cell reference which defines this area. Usually this cell is in the upper
left corner of the area (but this is not a requirement).
getLastCell
public CellReference getLastCell()
- Note - if this area reference refers to a single cell, the return value of this method will
be identical to that of getFirstCell()
- Returns:
- the second cell reference which defines this area. For multi-cell areas, this is
cell diagonally opposite the 'first cell'. Usually this cell is in the lower right corner
of the area (but this is not a requirement).
getAllReferencedCells
public CellReference[] getAllReferencedCells()
- Returns a reference to every cell covered by this area
formatAsString
public java.lang.String formatAsString()
- Example return values:
Result | Comment |
A1:A1 | Single cell area reference without sheet |
A1:$C$1 | Multi-cell area reference without sheet |
Sheet1!A$1:B4 | Standard sheet name |
'O''Brien''s Sales'!B5:C6' | Sheet name with special characters |
- Returns:
- the text representation of this area reference as it would appear in a formula.
toString
public java.lang.String toString()
- Overrides:
toString in class java.lang.Object
Copyright 2012 The Apache Software Foundation or
its licensors, as applicable.
|