Uses of Class
org.apache.poi.ss.util.CellReference

Packages that use CellReference

Package	Description
io.keikai.model.impl	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.sys.formula	Keikai Spreadsheet Internal Book Model Implementation classes.
org.apache.poi.hssf.record.aggregates	The record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.usermodel	The usermodel package maps HSSF low level structures to familiar workbook/sheet model
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.ptg	The formula package contains binary PTG structures used in Formulas
org.apache.poi.ss.usermodel
org.apache.poi.ss.util

Uses of CellReference in io.keikai.model.impl

Methods in io.keikai.model.impl with parameters of type CellReference

Modifier and Type	Method	Description
boolean	TableImpl.contains(CellReference cell)
boolean	TableImpl.DummyTable.contains(CellReference cell)

Uses of CellReference in io.keikai.model.impl.sys.formula

Methods in io.keikai.model.impl.sys.formula with parameters of type CellReference

Modifier and Type	Method	Description
Ptg	EvalBook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
Ptg	ParsingBook.get3DReferencePtg(CellReference cr, SheetIdentifier sheet)

Uses of CellReference in org.apache.poi.hssf.record.aggregates

Methods in org.apache.poi.hssf.record.aggregates with parameters of type CellReference

Modifier and Type	Method	Description
static SharedValueManager	SharedValueManager.create(SharedFormulaRecord[] sharedFormulaRecords, CellReference[] firstCells, ArrayRecord[] arrayRecords, TableRecord[] tableRecords)
SharedFormulaRecord	SharedValueManager.linkSharedFormulaRecord(CellReference firstCell, FormulaRecordAggregate agg)

Uses of CellReference in org.apache.poi.hssf.usermodel

Methods in org.apache.poi.hssf.usermodel with parameters of type CellReference

Modifier and Type	Method	Description
AreaReference	HSSFCreationHelper.createAreaReference(CellReference topLeft, CellReference bottomRight)	Creates an area ref from a pair of Cell References..
Ptg	HSSFEvaluationWorkbook.get3DReferencePtg(CellReference cr, SheetIdentifier sheet)

Uses of CellReference in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return CellReference

Modifier and Type	Method	Description
static CellReference	OperationEvaluationContext.applyR1C1Reference(CellReference anchorReference, String relativeReference)
CellReference	Formula.getExpReference()	Gets the locator for the corresponding SharedFormulaRecord, ArrayRecord or TableRecord if this formula belongs to such a grouping.
static CellReference	ConditionalFormattingEvaluator.getRef(Cell cell)
CellReference	DataValidationEvaluator.DataValidationContext.getTarget()

Methods in org.apache.poi.ss.formula with parameters of type CellReference

Modifier and Type	Method	Description
static CellReference	OperationEvaluationContext.applyR1C1Reference(CellReference anchorReference, String relativeReference)
ValueEval	WorkbookEvaluator.evaluate(String formula, CellReference ref, int[] offset)	Evaluate a formula outside a cell value, e.g.
ValueEval	WorkbookEvaluator.evaluate(String formula, CellReference target, CellRangeAddressBase region)	Some expressions need to be evaluated in terms of an offset from the top left corner of a region, such as some data validation and conditional format expressions, when those constraints apply to contiguous cells.
ValueEval	WorkbookEvaluator.evaluateList(String formula, CellReference target, CellRangeAddressBase region)	Some expressions need to be evaluated in terms of an offset from the top left corner of a region, such as some data validation and conditional format expressions, when those constraints apply to contiguous cells.
Ptg	FormulaParsingWorkbook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet)	Produce the appropriate Ptg for a 3d cell reference
List<EvaluationConditionalFormatRule>	ConditionalFormattingEvaluator.getConditionalFormattingForCell(CellReference cellRef)	This checks all applicable ConditionalFormattingRules for the cell's sheet, in defined "priority" order, returning the matches if any.
DataValidationEvaluator.DataValidationContext	DataValidationEvaluator.getValidationContextForCell(CellReference cell)	Finds and returns the DataValidationEvaluator.DataValidationContext for the cell, if there is one.
DataValidation	DataValidationEvaluator.getValidationForCell(CellReference cell)	Finds and returns the DataValidation for the cell, if there is one.
List<ValueEval>	DataValidationEvaluator.getValidationValuesForCell(CellReference cell)	If DataValidationEvaluator.getValidationForCell(CellReference) returns an instance, and the DataValidationConstraint.ValidationType is DataValidationConstraint.ValidationType.LIST, return the valid values, whether they are from a static list or cell range.
boolean	DataValidationEvaluator.isValidCell(CellReference cellRef)	Use the validation returned by DataValidationEvaluator.getValidationForCell(CellReference) if you want the error display details.

Constructors in org.apache.poi.ss.formula with parameters of type CellReference

Constructor	Description
DataValidationContext(DataValidation dv, DataValidationEvaluator dve, CellRangeAddressBase region, CellReference target)	Populate the context with the necessary values.

Uses of CellReference in org.apache.poi.ss.formula.ptg

Constructors in org.apache.poi.ss.formula.ptg with parameters of type CellReference

Constructor	Description
Ref3DPtg(CellReference c, int externIdx)
Ref3DPxg(int externalWorkbookNumber, SheetIdentifier sheetName, CellReference c)
Ref3DPxg(SheetIdentifier sheetName, CellReference c)
RefPtg(CellReference cr)
RefPtgBase(CellReference c)

Uses of CellReference in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel with parameters of type CellReference

Modifier and Type	Method	Description
CellRangeAddressBase	TableStyleType.appliesTo(Table table, CellReference cell)	A range is returned only for the part of the table matching this enum instance and containing the given cell reference.
boolean	Table.contains(CellReference cell)	checks if the given cell is part of the table.
AreaReference	CreationHelper.createAreaReference(CellReference topLeft, CellReference bottomRight)	Creates an area ref from a pair of Cell References..
CellRangeAddressBase	TableStyleType.getRange(Table table, CellReference cell)

Uses of CellReference in org.apache.poi.ss.util

Methods in org.apache.poi.ss.util that return CellReference

Modifier and Type	Method	Description
CellReference[]	AreaReference.getAllReferencedCells()	Returns a reference to every cell covered by this area
CellReference	AreaReference.getFirstCell()
CellReference	AreaReference.getLastCell()	Note - if this area reference refers to a single cell, the return value of this method will be identical to that of getFirstCell()

Methods in org.apache.poi.ss.util with parameters of type CellReference

Modifier and Type	Method	Description
boolean	CellRangeAddressBase.isInRange(CellReference ref)	Determines if the given CellReference lies within the bounds of this range.
static boolean	AreaReference.isWholeColumnReference(SpreadsheetVersion version, CellReference topLeft, CellReference botRight)	Is the reference for a whole-column reference, such as C:C or D:G ?
static boolean	AreaReference.isWholeRowReference(SpreadsheetVersion version, CellReference topLeft, CellReference botRight)

Constructors in org.apache.poi.ss.util with parameters of type CellReference

Constructor	Description
AreaReference(CellReference topLeft, CellReference botRight, SpreadsheetVersion version)	Creates an area ref from a pair of Cell References.
CellAddress(CellReference reference)	Create a new CellAddress object.