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

Class DSum

  • All Implemented Interfaces:
    IDStarAlgorithm
    public final class DSum
extends java.lang.Object
implements IDStarAlgorithm
    Implementation of the DSum function: Finds the total value of matching values in a column in an area with given conditions. TODO: - wildcards ? and * in string conditions - functions as conditions

    • Constructor Summary

      Constructors 
      Constructor Description
      DSum()  

    • Method Summary

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

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • DSum

        public DSum()

    • 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