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

public final Class DAverage

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, java.math.BigDecimal, .MathContext
Implementation of the DAverage function: Gets the average value of a column in an area with given conditions.

Field Summary

Modifier and TypeField and Description
private long
count

private double
total

Constructor Summary

AccessConstructor and Description
public
DAverage()

Method Summary

Modifier and TypeMethod and Description
private static double
divide(final double total, final long count)

private double
getAverage()

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

countback to summary
private long count
totalback to summary
private double total

Constructor Detail

DAverageback to summary
public DAverage()

Method Detail

divideback to summary
private static double divide(final double total, final long count)
getAverageback to summary
private double getAverage()
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