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

public final Class DSum

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
Implementation of the DSum function: Finds the total value of matching values in a column in an area with given conditions.

Todo

- functions as conditions

Field Summary

Modifier and TypeField and Description
private double
totalValue

Constructor Summary

AccessConstructor and Description
public
DSum()

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

totalValueback to summary
private double totalValue

Constructor Detail

DSumback to summary
public DSum()

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