Package org.apache.poi.ss.formula.functions

Class DCountA

  • All Implemented Interfaces:
    IDStarAlgorithm
    public final class DCountA
extends java.lang.Object
implements IDStarAlgorithm
    Implementation of the DCountA function: Counts the number of non-blank cells in a column in an area with given conditions.

    • Constructor Summary

      Constructors 
      Constructor Description
      DCountA()  

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method 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

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

    • Constructor Detail

      • DCountA

        public DCountA()

    • 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