Uses of Interface
org.apache.poi.ss.formula.eval.AreaEval
Packages that use AreaEval
Package
Description
This package contains common internal POI code for manipulating formulas.
-
Uses of AreaEval in org.apache.poi.ss.formula
Classes in org.apache.poi.ss.formula that implement AreaEvalModifier and TypeClassDescriptionfinal classProvides holding structure for temporary values in arrays during the evaluation process.Methods in org.apache.poi.ss.formula that return AreaEval -
Uses of AreaEval in org.apache.poi.ss.formula.eval
Classes in org.apache.poi.ss.formula.eval that implement AreaEvalMethods in org.apache.poi.ss.formula.eval that return AreaEvalModifier and TypeMethodDescriptionAreaEval.offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) Creates an AreaEval offset by a relative amount from the upper left cell of this areaRefEval.offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) Creates anAreaEvaloffset by a relative amount from this RefEvalMethods in org.apache.poi.ss.formula.eval with parameters of type AreaEvalModifier and TypeMethodDescriptionstatic ValueEvalOperandResolver.chooseSingleElementFromArea(AreaEval ae, int srcCellRow, int srcCellCol) Implements (some perhaps not well known) Excel functionality to select a single cell from an area depending on the coordinates of the calling cell.static ValueEvalOperandResolver.getElementFromArray(AreaEval ae, EvaluationCell cell) Retrieves a single value from an area evaluation utilizing the 2D indices of the cell within its own area reference to index the value in the area evaluation. -
Uses of AreaEval in org.apache.poi.ss.formula.functions
Methods in org.apache.poi.ss.formula.functions with parameters of type AreaEvalModifier and TypeMethodDescriptionprotected ValueEvalAverageIf.aggregateMatchingCells(org.apache.poi.ss.formula.functions.Baseifs.Aggregator aggregator, AreaEval sumRange, AreaEval testRange, org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate mp)