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

Packages that use AreaReference

Package	Description
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.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.hssf.util

Subclasses of AreaReference in org.apache.poi.hssf.util

Modifier and Type	Class and Description
class	AreaReference Deprecated. POI 3.15 beta 3. Use AreaReference instead.

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.generateContiguous(java.lang.String reference) Deprecated. use generateContiguous(SpreadsheetVersion, String) instead
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.getCellReferences()
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.
Ptg	BaseXSSFEvaluationWorkbook.get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
void	XSSFTable.setCellReferences(AreaReference refs) Updates the reference for the cells of the table (see Open Office XML Part 4: chapter 3.5.1.2, attribute ref) and synchronizes any changes