Top Description Fields Constructors Methods
org.apache.poi.ss.formula.functions

public final Class DVarp

extends Object
implements IDStarAlgorithm
Class Inheritance
All Implemented Interfaces
org.apache.poi.ss.formula.functions.IDStarAlgorithm
Imports
org.apache.poi.ss.formula.eval.NumberEval, .NumericValueEval, .ValueEval, org.apache.poi.ss.util.NumberToTextConverter, java.math.BigDecimal, java.util.ArrayList
Implementation of the DVarp function: Gets the variance value of a column in an area with given conditions.

Field Summary

Modifier and TypeField and Description
private final ArrayList<NumericValueEval>
values

Constructor Summary

AccessConstructor and Description
public
DVarp()

Method Summary

Modifier and TypeMethod and Description
public ValueEval
getResult()

Implements org.apache.poi.ss.formula.functions.IDStarAlgorithm.getResult.

Return a result ValueEval that will be the result of the calculation.

public boolean
processMatch(ValueEval
ValueEval of the cell in the matching row. References will already be resolved.
eval)

Implements org.apache.poi.ss.formula.functions.IDStarAlgorithm.processMatch.

Process a match that is found during a run through a database.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

valuesback to summary
private final ArrayList<NumericValueEval> values

Constructor Detail

DVarpback to summary
public DVarp()

Method Detail

getResultback to summary
public ValueEval getResult()

Implements org.apache.poi.ss.formula.functions.IDStarAlgorithm.getResult.

Doc from org.apache.poi.ss.formula.functions.IDStarAlgorithm.getResult.

Return a result ValueEval that will be the result of the calculation. This is always called at the end of a run through the database.

Returns:ValueEval

a ValueEval

Annotations
@Override
processMatchback to summary
public boolean processMatch(ValueEval eval)

Implements org.apache.poi.ss.formula.functions.IDStarAlgorithm.processMatch.

Doc from org.apache.poi.ss.formula.functions.IDStarAlgorithm.processMatch.

Process a match that is found during a run through a database.

Parameters
eval:ValueEval

ValueEval of the cell in the matching row. References will already be resolved.

Returns:boolean

Whether we should continue iterating through the database.

Annotations
@Override