org.apache.poi.ss.formula.functions

Class DCount

java.lang.Object

org.apache.poi.ss.formula.functions.DCount

All Implemented Interfaces:

IDStarAlgorithm

public final class DCount
extends Object
implements IDStarAlgorithm

Implementation of the DCount function: Counts the number of numeric cells in a column in an area with given conditions.

Constructor Summary

Constructors

Constructor and Description
DCount()

Method Summary

Modifier and Type	Method and Description
boolean	allowEmptyMatchField() Whether the field value (the 2nd param in DCOUNT, DGET, etc.) can evaluate to empty.
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.

Methods inherited from class java.lang.Object

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

Constructor Detail

DCount

public DCount()

Method Detail

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

allowEmptyMatchField

public boolean allowEmptyMatchField()

Description copied from interface: IDStarAlgorithm

Whether the field value (the 2nd param in DCOUNT, DGET, etc.) can evaluate to empty. It is allowed to evaluate to empty for DCOUNT.

Specified by:

allowEmptyMatchField in interface IDStarAlgorithm

Returns:

whether the field value can evaluate to empty