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

public final Class DCount

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 DCount function: Counts the number of numeric cells in a column in an area with given conditions.

Field Summary

Modifier and TypeField and Description
private long
count

Constructor Summary

AccessConstructor and Description
public
DCount()

Method Summary

Modifier and TypeMethod and Description
public boolean
allowEmptyMatchField()

Overrides default org.apache.poi.ss.formula.functions.IDStarAlgorithm.allowEmptyMatchField.

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

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

Constructor Detail

DCountback to summary
public DCount()

Method Detail

allowEmptyMatchFieldback to summary
public boolean allowEmptyMatchField()

Overrides default org.apache.poi.ss.formula.functions.IDStarAlgorithm.allowEmptyMatchField.

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

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

Returns:boolean

whether the field value can evaluate to empty

Annotations
@Override
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