## 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.hssf.util | The 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 | The 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.xddf.usermodel.chart |
  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
    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.hssf.util

    Subclasses of CellReference in org.apache.poi.hssf.util
    Modifier and Type | Class and Description
    --- | ---
    `class` | `CellReference` Deprecated. POI 4.0.0-SNAPSHOT. Use `CellReference` instead. Actually the replacement CellReference was added earlier, but the deprecation notice was added only in 4.0.0-SNAPSHOT.

  - ### 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 `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
    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.usermodel.charts

    Methods in org.apache.poi.ss.usermodel.charts that return CellReference
    Modifier and Type | Method and Description
    --- | ---
    `CellReference` | ChartSeries.`getTitleCellReference()` Deprecated.

    Methods in org.apache.poi.ss.usermodel.charts with parameters of type CellReference
    Modifier and Type | Method and Description
    --- | ---
    `void` | ChartSeries.`setTitle(CellReference titleReference)` Deprecated. 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
    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)`

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

    Methods in org.apache.poi.xssf.usermodel.charts that return CellReference
    Modifier and Type | Method and Description
    --- | ---
    `CellReference` | AbstractXSSFChartSeries.`getTitleCellReference()` Deprecated.

    Methods in org.apache.poi.xssf.usermodel.charts with parameters of type CellReference
    Modifier and Type | Method and Description
    --- | ---
    `void` | AbstractXSSFChartSeries.`setTitle(CellReference titleReference)` Deprecated.

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