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

Packages that use CellReference

Package	Description
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
org.apache.poi.xddf.usermodel.chart
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

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 and 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 and 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 and Description
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 and Description
protected boolean	WorkbookEvaluator.adjustRegionRelativeReference(Ptg[] ptgs, CellReference target, CellRangeAddressBase region) Adjust formula relative references by the offset between the start of the given region and the given target cell.
ValueEval	WorkbookEvaluator.evaluate(java.lang.String formula, CellReference ref) Evaluate a formula outside a cell value, e.g.
ValueEval	WorkbookEvaluator.evaluate(java.lang.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(java.lang.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
java.util.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.
java.util.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 and 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 and 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 and 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 and 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 and 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 ?

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

Constructor and 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.

Uses of CellReference in org.apache.poi.xddf.usermodel.chart

Methods in org.apache.poi.xddf.usermodel.chart that return CellReference

Modifier and Type	Method and Description
CellReference	XDDFChart.setSheetTitle(java.lang.String title, int column) set sheet title in excel file

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

Modifier and Type	Method and Description
void	XDDFChartData.Series.setTitle(java.lang.String title, CellReference titleRef)

Uses of CellReference in org.apache.poi.xssf.streaming

Methods in org.apache.poi.xssf.streaming with parameters of type CellReference

Modifier and Type	Method and Description
AreaReference	SXSSFCreationHelper.createAreaReference(CellReference topLeft, CellReference bottomRight) Creates an area ref from a pair of Cell References..

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

Methods in org.apache.poi.xssf.usermodel that return CellReference

Modifier and Type	Method and Description
CellReference	XSSFTable.getEndCellReference()
CellReference	XSSFTable.getStartCellReference()

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

Modifier and Type	Method and Description
void	XSSFSheet.addIgnoredErrors(CellReference cell, IgnoredErrorType... ignoredErrorTypes) Add ignored errors (usually to suppress them in the UI of a consuming application).
boolean	XSSFTable.contains(CellReference cell)
AreaReference	XSSFCreationHelper.createAreaReference(CellReference topLeft, CellReference bottomRight) Creates an area ref from a pair of Cell References..
XSSFPivotTable	XSSFSheet.createPivotTable(AreaReference source, CellReference position) Create a pivot table using the AreaReference range, at the given position.
XSSFPivotTable	XSSFSheet.createPivotTable(AreaReference source, CellReference position, Sheet sourceSheet) Create a pivot table using the AreaReference range on sourceSheet, at the given position.
XSSFPivotTable	XSSFSheet.createPivotTable(Name source, CellReference position) Create a pivot table using the Name range, at the given position.
XSSFPivotTable	XSSFSheet.createPivotTable(Name source, CellReference position, Sheet sourceSheet) Create a pivot table using the Name range reference on sourceSheet, at the given position.
XSSFPivotTable	XSSFSheet.createPivotTable(Table source, CellReference position) Create a pivot table using the Table, at the given position.
protected void	XSSFPivotTable.createSourceReferences(CellReference position, Sheet sourceSheet, XSSFPivotTable.PivotTableReferenceConfigurator refConfig) Creates cacheSource and workSheetSource for pivot table and sets the source reference as well assets the location of the pivot table
Ptg	BaseXSSFEvaluationWorkbook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
void	XSSFHyperlink.setCellReference(CellReference ref)