Uses of Class
net.sf.jett.formula.CellRef

Packages that use CellRef

Package	Description
net.sf.jett.formula	Provides support for JETT Formulas and CellReferences.
net.sf.jett.model	Provides value objects for JETT processing and enumerated objects for things like style values.
net.sf.jett.parser	Provides classes for scanning and parsing any text-based value in JETT.
net.sf.jett.util	Provides utility functionality for JETT.

Uses of CellRef in net.sf.jett.formula

Subclasses of CellRef in net.sf.jett.formula

Modifier and Type	Class	Description
class	CellRefRange	A CellRefRange is a CellRef, representing a range.

Methods in net.sf.jett.formula that return CellRef

Modifier and Type	Method	Description
CellRef	CellRefRange.getRangeEndCellRef()	Returns the end of the cell range.

Methods in net.sf.jett.formula that return types with arguments of type CellRef

Modifier and Type	Method	Description
java.util.List<CellRef>	Formula.getCellRefs()	Returns the List of CellRefs.

Methods in net.sf.jett.formula with parameters of type CellRef

Modifier and Type	Method	Description
int	CellRef.compareTo(CellRef other)	Compares this CellRef to another CellRef.
void	CellRefRange.setRangeEndCellRef(CellRef rangeEnd)	Sets the end of the cell range with another CellRef.

Constructor parameters in net.sf.jett.formula with type arguments of type CellRef

Constructor	Description
Formula(java.lang.String formulaText, java.util.List<CellRef> cellRefs)	Creates a Formula with the given formula text and the given List of CellRefs.

Uses of CellRef in net.sf.jett.model

Methods in net.sf.jett.model that return types with arguments of type CellRef

Modifier and Type	Method	Description
java.util.Map<java.lang.String,java.util.List<CellRef>>	WorkbookContext.getCellRefMap()	Returns the cell reference map, a Map of cell key strings to Lists of CellRefs.

Method parameters in net.sf.jett.model with type arguments of type CellRef

Modifier and Type	Method	Description
void	WorkbookContext.setCellRefMap(java.util.Map<java.lang.String,java.util.List<CellRef>> cellRefMap)	Sets the cell reference map, a Map of cell key strings to Lists of CellRefs.

Uses of CellRef in net.sf.jett.parser

Methods in net.sf.jett.parser that return types with arguments of type CellRef

Modifier and Type	Method	Description
java.util.List<CellRef>	FormulaParser.getCellReferences()	Returns a List of CellRefs that this parser found in the formula text.

Uses of CellRef in net.sf.jett.util

Methods in net.sf.jett.util that return types with arguments of type CellRef

Modifier and Type	Method	Description
static java.util.Map<java.lang.String,java.util.List<CellRef>>	FormulaUtil.createCellRefMap(java.util.Map<java.lang.String,Formula> formulaMap)	Finds unique cell references in all Formulas in the given formula map.

Methods in net.sf.jett.util with parameters of type CellRef

Modifier and Type	Method	Description
static java.lang.String	FormulaUtil.getCellKey(CellRef cellRef, java.lang.String sheetName)	Creates a "cell key" from a cell ref, with a sheet name supplied if the cell ref doesn't refer to a sheet name.

Method parameters in net.sf.jett.util with type arguments of type CellRef

Modifier and Type	Method	Description
static void	FormulaUtil.findAndReplaceCellRanges(java.util.Map<java.lang.String,java.util.List<CellRef>> cellRefMap)	Examines all CellRefs in each List.
static java.lang.String	FormulaUtil.formatSheetNames(java.lang.String formula, java.util.List<CellRef> cellReferences)	It's possible that a JETT formula was entered that wouldn't be accepted by Excel because the sheet name needs to be formatted -- enclosed in single quotes, e.g.