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

protected java.lang.String	cellRangeSeparator
protected static java.lang.String	leftReplacementMarker
protected static java.lang.String	regexCellCharPart
protected static java.lang.String	regexCellDigitPart
protected static java.lang.String	regexReplacementMarker
protected static java.lang.String	rightReplacementMarker

Constructor Summary

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

Method Summary

java.lang.Integer	getCellIndex()
short	getColNum()
int	getRowNum()
java.lang.String	getSheetName()
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

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)

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