Uses of Class
org.apache.poi.ss.util.CellReference
-
Packages that use CellReference Package Description 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 modelorg.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 Formulasorg.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 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 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 Description class
CellReference
Deprecated.POI 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 Description CellReference
Formula. getExpReference()
Gets the locator for the correspondingSharedFormulaRecord
,ArrayRecord
orTableRecord
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 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 referencejava.util.List<EvaluationConditionalFormatRule>
ConditionalFormattingEvaluator. getConditionalFormattingForCell(CellReference cellRef)
This checks all applicableConditionalFormattingRule
s for the cell's sheet, in defined "priority" order, returning the matches if any.DataValidationEvaluator.DataValidationContext
DataValidationEvaluator. getValidationContextForCell(CellReference cell)
Finds and returns theDataValidationEvaluator.DataValidationContext
for the cell, if there is one.DataValidation
DataValidationEvaluator. getValidationForCell(CellReference cell)
Finds and returns theDataValidation
for the cell, if there is one.java.util.List<ValueEval>
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 CellReference Constructor 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 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 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 Description CellReference
ChartSeries. getTitleCellReference()
Deprecated.Methods in org.apache.poi.ss.usermodel.charts with parameters of type CellReference Modifier and Type Method 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 Description CellReference[]
AreaReference. getAllReferencedCells()
Returns a reference to every cell covered by this areaCellReference
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 Description boolean
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 CellReference Constructor 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 Description CellReference
XDDFChart. setSheetTitle(java.lang.String title, int column)
set sheet title in excel fileMethods in org.apache.poi.xddf.usermodel.chart with parameters of type CellReference Modifier and Type Method 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 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 Description CellReference
XSSFTable. getEndCellReference()
CellReference
XSSFTable. getStartCellReference()
Methods in org.apache.poi.xssf.usermodel with parameters of type CellReference Modifier and Type Method 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(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.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.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 tablePtg
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 Description CellReference
AbstractXSSFChartSeries. getTitleCellReference()
Deprecated.Methods in org.apache.poi.xssf.usermodel.charts with parameters of type CellReference Modifier and Type Method Description void
AbstractXSSFChartSeries. setTitle(CellReference titleReference)
Deprecated.
-