Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use CellReference
org.apache.poi.hssf.record.aggregates | record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.usermodel | usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.hssf.util | util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
org.apache.poi.ss.formula | This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.ptg | formula package contains binary PTG structures used in Formulas
org.apache.poi.ss.usermodel |
org.apache.poi.ss.usermodel.charts |
org.apache.poi.ss.util |
org.apache.poi.xssf.streaming |
org.apache.poi.xssf.usermodel |
org.apache.poi.xssf.usermodel.charts |

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

Methods in org.apache.poi.hssf.record.aggregates with parameters of type CellReference
`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
`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.hssf.util

Subclasses of CellReference in org.apache.poi.hssf.util
`class` | `CellReference` Common conversion functions between Excel style A1, C27 style cell references, and POI usermodel style row=0, column=0 style references.

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

Methods in org.apache.poi.ss.formula that return CellReference
`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
`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 `ConditionalFormattingRule`s 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
`DataValidationEvaluator.DataValidationContext(DataValidation dv, DataValidationEvaluator dve, CellRangeAddressBase region, CellReference target)`

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

Constructors in org.apache.poi.ss.formula.ptg with parameters of type CellReference
`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
`AreaReference` | `CreationHelper.createAreaReference(CellReference topLeft, CellReference bottomRight)` Creates an area ref from a pair of Cell References..

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

Methods in org.apache.poi.ss.usermodel.charts that return CellReference
`CellReference` | `ChartSeries.getTitleCellReference()`

Methods in org.apache.poi.ss.usermodel.charts with parameters of type CellReference
`void` | `ChartSeries.setTitle(CellReference titleReference)` Sets the title of the series as a cell reference.

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

Methods in org.apache.poi.ss.util that return CellReference
`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
`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
`AreaReference(CellReference topLeft, CellReference botRight)` Deprecated. use `AreaReference.AreaReference(CellReference, CellReference, SpreadsheetVersion)` instead
`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.xssf.streaming

Methods in org.apache.poi.xssf.streaming with parameters of type CellReference
`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
`CellReference` | `XSSFTable.getEndCellReference()`
`CellReference` | `XSSFTable.getStartCellReference()`

Methods in org.apache.poi.xssf.usermodel with parameters of type CellReference
`void` | `XSSFSheet.addIgnoredErrors(CellReference cell, IgnoredErrorType... ignoredErrorTypes)` Add ignored errors (usually to suppress them in the UI of a consuming application).
`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)`

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

Methods in org.apache.poi.xssf.usermodel.charts that return CellReference
`CellReference` | `AbstractXSSFChartSeries.getTitleCellReference()`

Methods in org.apache.poi.xssf.usermodel.charts with parameters of type CellReference
`void` | `AbstractXSSFChartSeries.setTitle(CellReference titleReference)`

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.