net.sf.jxls.formula
Class CellRef

java.lang.Object
  net.sf.jxls.formula.CellRef

public class CellRef
extends java.lang.Object

Author:

Leonid Vysochyn

Field Summary

(package private) java.lang.String	baseCellRef
(package private) java.lang.Integer	cellIndex
protected java.lang.String	cellRangeSeparator
(package private) java.lang.String	cellRef
(package private) short	colNum
protected static java.lang.String	leftReplacementMarker
(package private) FormulaPart	parentFormula
(package private) java.util.List	rangeFormulaParts
protected static java.lang.String	regexCellCharPart
protected static java.lang.String	regexCellDigitPart
protected static java.lang.String	regexReplacementMarker
protected static java.lang.String	rightReplacementMarker
(package private) int	rowNum
(package private) java.lang.String	sheetName

Constructor Summary

CellRef(java.lang.String cellRef, FormulaPart parentFormula)

Method Summary

(package private) java.lang.String	buildCommaSeparatedListOfCells(java.lang.String refSheetName, java.util.List cells)
(package private) boolean	containsSheetRef()
(package private) java.lang.String	detectCellRange(java.lang.String refSheetName, java.util.List cells)
java.lang.Integer	getCellIndex()
short	getColNum()
(package private) java.lang.String	getRefCellName(java.lang.String refSheetName, java.lang.String cellName)
int	getRowNum()
java.lang.String	getSheetName()
(package private) boolean	isColumnRange(java.util.List cells)
(package private) boolean	isRowRange(java.util.List cells)
static java.lang.String	replaceFormulaPart(java.lang.String formulaPart, java.lang.String refCell, java.lang.String newCell) Ref cell in a formula string is replaced with result cell enclosed with replacement markers to be able not to replace already replaced cells
void	setCellIndex(java.lang.Integer cellIndex)
java.lang.String	toString()
void	update(java.util.List newCellRefs)
void	update(java.lang.String newCellRef)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

leftReplacementMarker

protected static java.lang.String leftReplacementMarker

rightReplacementMarker

protected static java.lang.String rightReplacementMarker

regexReplacementMarker

protected static java.lang.String regexReplacementMarker

regexCellCharPart

protected static final java.lang.String regexCellCharPart

See Also:

Constant Field Values

regexCellDigitPart

protected static final java.lang.String regexCellDigitPart

See Also:

Constant Field Values

cellRef

java.lang.String cellRef

baseCellRef

java.lang.String baseCellRef

parentFormula

FormulaPart parentFormula

rowNum

int rowNum

colNum

short colNum

sheetName

java.lang.String sheetName

cellIndex

java.lang.Integer cellIndex

rangeFormulaParts

java.util.List rangeFormulaParts

cellRangeSeparator

protected java.lang.String cellRangeSeparator

Constructor Detail

CellRef

public CellRef(java.lang.String cellRef,
               FormulaPart parentFormula)

Method Detail

getSheetName

public java.lang.String getSheetName()

getRowNum

public int getRowNum()

getColNum

public short getColNum()

getCellIndex

public java.lang.Integer getCellIndex()

setCellIndex

public void setCellIndex(java.lang.Integer cellIndex)

update

public void update(java.lang.String newCellRef)

update

public void update(java.util.List newCellRefs)

containsSheetRef

boolean containsSheetRef()

detectCellRange

java.lang.String detectCellRange(java.lang.String refSheetName,
                                 java.util.List cells)

buildCommaSeparatedListOfCells

java.lang.String buildCommaSeparatedListOfCells(java.lang.String refSheetName,
                                                java.util.List cells)

getRefCellName

java.lang.String getRefCellName(java.lang.String refSheetName,
                                java.lang.String cellName)

isColumnRange

boolean isColumnRange(java.util.List cells)

isRowRange

boolean isRowRange(java.util.List cells)

replaceFormulaPart

public static java.lang.String replaceFormulaPart(java.lang.String formulaPart,
                                                  java.lang.String refCell,
                                                  java.lang.String newCell)

Ref cell in a formula string is replaced with result cell enclosed with replacement markers to be able not to replace already replaced cells

Parameters:

formulaPart - - Part of the formula to replace

refCell - - Cell name to replace

newCell - - New cell name after replacement

Returns:

updated formula string

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object