Uses of Class
org.apache.poi.ss.util.CellReference
Packages that use CellReference
Package
Description
record aggregates are not real "records" but collections of records that act as a single record.
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
This package contains common internal POI code for manipulating formulas.
formula package contains binary PTG structures used in Formulas
-
Uses of CellReference in org.apache.poi.hssf.record.aggregates
Methods in org.apache.poi.hssf.record.aggregates with parameters of type CellReferenceModifier and TypeMethodDescriptionstatic SharedValueManager
SharedValueManager.create
(SharedFormulaRecord[] sharedFormulaRecords, CellReference[] firstCells, ArrayRecord[] arrayRecords, TableRecord[] tableRecords) 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 CellReferenceModifier and TypeMethodDescriptionHSSFCreationHelper.createAreaReference
(CellReference topLeft, CellReference bottomRight) Creates an area ref from a pair of Cell References..HSSFEvaluationWorkbook.get3DReferencePtg
(CellReference cr, SheetIdentifier sheet) -
Uses of CellReference in org.apache.poi.hssf.util
Subclasses of CellReference in org.apache.poi.hssf.util -
Uses of CellReference in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return CellReferenceModifier and TypeMethodDescriptionFormula.getExpReference()
Gets the locator for the correspondingSharedFormulaRecord
,ArrayRecord
orTableRecord
if this formula belongs to such a grouping.static CellReference
DataValidationEvaluator.DataValidationContext.getTarget()
Methods in org.apache.poi.ss.formula with parameters of type CellReferenceModifier and TypeMethodDescriptionprotected 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.WorkbookEvaluator.evaluate
(String formula, CellReference ref) Evaluate a formula outside a cell value, e.g.WorkbookEvaluator.evaluate
(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.WorkbookEvaluator.evaluateList
(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.FormulaParsingWorkbook.get3DReferencePtg
(CellReference cell, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d cell referenceConditionalFormattingEvaluator.getConditionalFormattingForCell
(CellReference cellRef) This checks all applicableConditionalFormattingRule
s for the cell's sheet, in defined "priority" order, returning the matches if any.DataValidationEvaluator.getValidationContextForCell
(CellReference cell) Finds and returns theDataValidationEvaluator.DataValidationContext
for the cell, if there is one.DataValidationEvaluator.getValidationForCell
(CellReference cell) Finds and returns theDataValidation
for the cell, if there is one.DataValidationEvaluator.getValidationValuesForCell
(CellReference cell) IfDataValidationEvaluator.getValidationForCell(CellReference)
returns an instance, and theDataValidationConstraint.ValidationType
isDataValidationConstraint.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 byDataValidationEvaluator.getValidationForCell(CellReference)
if you want the error display details.Constructors in org.apache.poi.ss.formula with parameters of type CellReferenceModifierConstructorDescriptionDataValidationContext
(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 CellReferenceModifierConstructorDescriptionRef3DPtg
(CellReference c, int externIdx) Ref3DPxg
(int externalWorkbookNumber, SheetIdentifier sheetName, CellReference c) Ref3DPxg
(SheetIdentifier sheetName, CellReference c) RefPtg
(CellReference cr) protected
-
Uses of CellReference in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel with parameters of type CellReferenceModifier and TypeMethodDescriptionTableStyleType.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.CreationHelper.createAreaReference
(CellReference topLeft, CellReference bottomRight) Creates an area ref from a pair of Cell References..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 CellReferenceMethods in org.apache.poi.ss.usermodel.charts with parameters of type CellReferenceModifier and TypeMethodDescriptionvoid
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 CellReferenceModifier and TypeMethodDescriptionAreaReference.getAllReferencedCells()
Returns a reference to every cell covered by this areaAreaReference.getFirstCell()
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 CellReferenceModifier and TypeMethodDescriptionboolean
CellRangeAddressBase.isInRange
(CellReference ref) Determines if the givenCellReference
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 CellReferenceModifierConstructorDescriptionAreaReference
(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 CellReferenceModifier and TypeMethodDescriptionXDDFChart.setSheetTitle
(String title, int column) set sheet title in excel fileMethods in org.apache.poi.xddf.usermodel.chart with parameters of type CellReferenceModifier and TypeMethodDescriptionvoid
XDDFChartData.Series.setTitle
(String title, CellReference titleRef) -
Uses of CellReference in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming with parameters of type CellReferenceModifier and TypeMethodDescriptionSXSSFCreationHelper.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 CellReferenceModifier and TypeMethodDescriptionXSSFTable.getEndCellReference()
XSSFTable.getStartCellReference()
Methods in org.apache.poi.xssf.usermodel with parameters of type CellReferenceModifier and TypeMethodDescriptionvoid
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) XSSFCreationHelper.createAreaReference
(CellReference topLeft, CellReference bottomRight) Creates an area ref from a pair of Cell References..XSSFSheet.createPivotTable
(Name source, CellReference position) Create a pivot table using the Name range, at the given position.XSSFSheet.createPivotTable
(Name source, CellReference position, Sheet sourceSheet) Create a pivot table using the Name range reference on sourceSheet, at the given position.XSSFSheet.createPivotTable
(Table source, CellReference position) Create a pivot table using the Table, at the given position.XSSFSheet.createPivotTable
(AreaReference source, CellReference position) Create a pivot table using the AreaReference range, at the given position.XSSFSheet.createPivotTable
(AreaReference source, CellReference position, Sheet sourceSheet) Create a pivot table using the AreaReference range on sourceSheet, 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 tableBaseXSSFEvaluationWorkbook.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 CellReferenceMethods in org.apache.poi.xssf.usermodel.charts with parameters of type CellReferenceModifier and TypeMethodDescriptionvoid
AbstractXSSFChartSeries.setTitle
(CellReference titleReference) Deprecated.