|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use CellReference | |
|---|---|
| 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 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.usermodel.charts | |
| org.apache.poi.ss.util | |
| 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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
class |
CellReference
Common conversion functions between Excel style A1, C27 style cell references, and POI usermodel style row=0, column=0 style references. |
| Uses of CellReference in org.apache.poi.ss.formula |
|---|
| Methods in org.apache.poi.ss.formula that return CellReference | |
|---|---|
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 | |
|---|---|
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 ConditionalFormattingRules 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 | |
|---|---|
DataValidationEvaluator.DataValidationContext(DataValidation dv,
DataValidationEvaluator dve,
CellRangeAddressBase region,
CellReference target)
|
|
| Uses of CellReference in org.apache.poi.ss.formula.ptg |
|---|
| Constructors in org.apache.poi.ss.formula.ptg with parameters of type CellReference | |
|---|---|
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 | |
|---|---|
AreaReference |
CreationHelper.createAreaReference(CellReference topLeft,
CellReference bottomRight)
Creates an area ref from a pair of Cell References.. |
| Uses of CellReference in org.apache.poi.ss.usermodel.charts |
|---|
| Methods in org.apache.poi.ss.usermodel.charts that return CellReference | |
|---|---|
CellReference |
ChartSeries.getTitleCellReference()
|
| Methods in org.apache.poi.ss.usermodel.charts with parameters of type CellReference | |
|---|---|
void |
ChartSeries.setTitle(CellReference titleReference)
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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
AreaReference(CellReference topLeft,
CellReference botRight)
Deprecated. use AreaReference.AreaReference(CellReference, CellReference, SpreadsheetVersion) instead |
|
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.xssf.streaming |
|---|
| Methods in org.apache.poi.xssf.streaming with parameters of type CellReference | |
|---|---|
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 | |
|---|---|
CellReference |
XSSFTable.getEndCellReference()
|
CellReference |
XSSFTable.getStartCellReference()
|
| Methods in org.apache.poi.xssf.usermodel with parameters of type CellReference | |
|---|---|
void |
XSSFSheet.addIgnoredErrors(CellReference cell,
IgnoredErrorType... ignoredErrorTypes)
Add ignored errors (usually to suppress them in the UI of a consuming application). |
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 | |
|---|---|
CellReference |
AbstractXSSFChartSeries.getTitleCellReference()
|
| Methods in org.apache.poi.xssf.usermodel.charts with parameters of type CellReference | |
|---|---|
void |
AbstractXSSFChartSeries.setTitle(CellReference titleReference)
|
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||