org.apache.poi.ss.formula.functions

Class DGet

java.lang.Object

org.apache.poi.ss.formula.functions.DGet

All Implemented Interfaces:

IDStarAlgorithm

public final class DGet
extends java.lang.Object
implements IDStarAlgorithm

Implementation of the DGet function: Finds the value of a column in an area with given conditions. TODO: - wildcards ? and * in string conditions - functions as conditions

Constructor Summary

Constructors

Constructor and Description
DGet()

Method Summary

Modifier and Type	Method and Description
ValueEval	getResult() Return a result ValueEval that will be the result of the calculation.
boolean	processMatch(ValueEval eval) Process a match that is found during a run through a database.
void	reset() Reset the state of this algorithm.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DGet

public DGet()

Method Detail

reset

public void reset()

Description copied from interface: IDStarAlgorithm

Reset the state of this algorithm. This is called before each run through a database.

Specified by:

reset in interface IDStarAlgorithm

processMatch

public boolean processMatch(ValueEval eval)

Description copied from interface: IDStarAlgorithm

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

Specified by:

processMatch in interface IDStarAlgorithm

Parameters:

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

Returns:

Whether we should continue iterating through the database.

getResult

public ValueEval getResult()

Description copied from interface: IDStarAlgorithm

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.

Specified by:

getResult in interface IDStarAlgorithm

Returns:

a ValueEval