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

- Packages that use AreaReference
  Package | Description
  --- | ---
  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.xssf.streaming |
  org.apache.poi.xssf.usermodel |

- - ### Uses of AreaReference in org.apache.poi.hssf.usermodel

    Methods in org.apache.poi.hssf.usermodel that return AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `AreaReference` | HSSFCreationHelper.`createAreaReference(CellReference topLeft, CellReference bottomRight)` Creates an area ref from a pair of Cell References..
    `AreaReference` | HSSFCreationHelper.`createAreaReference(java.lang.String reference)` Creates an AreaReference.

    Methods in org.apache.poi.hssf.usermodel with parameters of type AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `Ptg` | HSSFEvaluationWorkbook.`get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet)`

  - ### Uses of AreaReference in org.apache.poi.ss.formula

    Methods in org.apache.poi.ss.formula with parameters of type AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `Ptg` | FormulaParsingWorkbook.`get3DReferencePtg(AreaReference area, SheetIdentifier sheet)` Produce the appropriate Ptg for a 3d area reference

  - ### Uses of AreaReference in org.apache.poi.ss.formula.ptg

    Constructors in org.apache.poi.ss.formula.ptg with parameters of type AreaReference
    Constructor and Description
    `Area2DPtgBase(AreaReference ar)`
    `Area3DPtg(AreaReference arearef, int externIdx)`
    `Area3DPxg(int externalWorkbookNumber, SheetIdentifier sheetName, AreaReference arearef)`
    `Area3DPxg(SheetIdentifier sheetName, AreaReference arearef)`
    `AreaPtg(AreaReference arearef)`
    `AreaPtgBase(AreaReference ar)`

  - ### Uses of AreaReference in org.apache.poi.ss.usermodel

    Methods in org.apache.poi.ss.usermodel that return AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `AreaReference` | CreationHelper.`createAreaReference(CellReference topLeft, CellReference bottomRight)` Creates an area ref from a pair of Cell References..
    `AreaReference` | CreationHelper.`createAreaReference(java.lang.String reference)` Creates an AreaReference.

  - ### Uses of AreaReference in org.apache.poi.ss.util

    Methods in org.apache.poi.ss.util that return AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `static AreaReference[]` | AreaReference.`generateContiguous(SpreadsheetVersion version, java.lang.String reference)` Takes a non-contiguous area reference, and returns an array of contiguous area references
    `static AreaReference` | AreaReference.`getWholeColumn(SpreadsheetVersion version, java.lang.String start, java.lang.String end)`
    `static AreaReference` | AreaReference.`getWholeRow(SpreadsheetVersion version, java.lang.String start, java.lang.String end)`

  - ### Uses of AreaReference in org.apache.poi.xssf.streaming

    Methods in org.apache.poi.xssf.streaming that return AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `AreaReference` | SXSSFCreationHelper.`createAreaReference(CellReference topLeft, CellReference bottomRight)` Creates an area ref from a pair of Cell References..
    `AreaReference` | SXSSFCreationHelper.`createAreaReference(java.lang.String reference)` Creates an AreaReference.

  - ### Uses of AreaReference in org.apache.poi.xssf.usermodel

    Methods in org.apache.poi.xssf.usermodel that return AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `AreaReference` | XSSFCreationHelper.`createAreaReference(CellReference topLeft, CellReference bottomRight)` Creates an area ref from a pair of Cell References..
    `AreaReference` | XSSFCreationHelper.`createAreaReference(java.lang.String reference)` Creates an AreaReference.
    `AreaReference` | XSSFTable.`getArea()` Get the area that this table covers.
    `AreaReference` | XSSFTable.`getCellReferences()` Get the area reference for the cells which this table covers.
    `protected AreaReference` | XSSFPivotTable.`getPivotArea()`
    `AreaReference` | XSSFPivotCacheDefinition.`getPivotArea(Workbook wb)` Find the 2D base data area for the pivot table, either from its direct reference or named table/range.

    Methods in org.apache.poi.xssf.usermodel with parameters of type AreaReference
    Modifier and Type | Method and Description
    --- | ---
    `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.
    `XSSFTable` | XSSFSheet.`createTable(AreaReference tableArea)` Creates a new Table, and associates it with this Sheet.
    `Ptg` | BaseXSSFEvaluationWorkbook.`get3DReferencePtg(AreaReference area, SheetIdentifier sheet)`
    `void` | XSSFTable.`setArea(AreaReference tableArea)` Set the area reference for the cells which this table covers.
    `protected void` | XSSFTable.`setCellRef(AreaReference refs)`
    `void` | XSSFTable.`setCellReferences(AreaReference refs)` Set the area reference for the cells which this table covers.

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