| Package | Description |
|---|---|
| org.apache.poi.hssf.record.aggregates |
The record aggregates are not real "records" but collections of records that act as a single record.
|
| 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 |
| Modifier and Type | Method and Description |
|---|---|
static SharedValueManager |
SharedValueManager.create(SharedFormulaRecord[] sharedFormulaRecords,
CellReference[] firstCells,
ArrayRecord[] arrayRecords,
TableRecord[] tableRecords) |
SharedFormulaRecord |
SharedValueManager.linkSharedFormulaRecord(CellReference firstCell,
FormulaRecordAggregate agg) |
| Modifier and Type | Method and 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) |
| Modifier and Type | Method and Description |
|---|---|
static CellReference |
OperationEvaluationContext.applyR1C1Reference(CellReference anchorReference,
String relativeReference) |
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() |
| Modifier and Type | Method and Description |
|---|---|
static CellReference |
OperationEvaluationContext.applyR1C1Reference(CellReference anchorReference,
String relativeReference) |
ValueEval |
WorkbookEvaluator.evaluate(String formula,
CellReference ref)
Evaluate a formula outside a cell value, e.g.
|
ValueEval |
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.
|
ValueEval |
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.
|
Ptg |
FormulaParsingWorkbook.get3DReferencePtg(CellReference cell,
SheetIdentifier sheet)
Produce the appropriate Ptg for a 3d cell reference
|
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. |
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. |
| Constructor and Description |
|---|
DataValidationContext(DataValidation dv,
DataValidationEvaluator dve,
CellRangeAddressBase region,
CellReference target)
Populate the context with the necessary values.
|
| Constructor and Description |
|---|
Ref3DPtg(CellReference c,
int externIdx) |
Ref3DPxg(int externalWorkbookNumber,
SheetIdentifier sheetName,
CellReference c) |
Ref3DPxg(SheetIdentifier sheetName,
CellReference c) |
RefPtg(CellReference cr) |
RefPtgBase(CellReference c) |
| Modifier and Type | Method and 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) |
| Modifier and Type | Method and Description |
|---|---|
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() |
| Modifier and Type | Method and Description |
|---|---|
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 ?
|
| Constructor and 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.
|