Examples of org.apache.poi.ss.formula.functions.Count

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

Examples of org.apache.poi.ss.formula.functions.Count

org.apache.poi.ss.formula.functions.Count
Counts the number of cells that contain numeric data within the list of arguments. Excel Syntax COUNT(value1,value2,...) Value1, value2, ... are 1 to 30 arguments representing the values or ranges to be counted. TODO: Check this properly matches excel on edge cases like formula cells, error cells etc

    protected static final Function[] functions = produceFunctions();


    private static Function[] produceFunctions() {
        Function[] retval = new Function[368];


        retval[0] = new Count();
        retval[ID.IF] = new IfFunc();
        retval[2] = LogicalFunction.ISNA;
        retval[3] = LogicalFunction.ISERROR;
        retval[ID.SUM] = AggregateFunction.SUM;
        retval[5] = AggregateFunction.AVERAGE;

View Full Code Here

    protected static final Function[] functions = produceFunctions();


    private static Function[] produceFunctions() {
        Function[] retval = new Function[368];


        retval[0] = new Count();
        retval[ID.IF] = new IfFunc();
        retval[2] = LogicalFunction.ISNA;
        retval[3] = LogicalFunction.ISERROR;
        retval[ID.SUM] = AggregateFunction.SUM;
        retval[5] = AggregateFunction.AVERAGE;

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.functions.Count

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.eval.NumberEval

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.