Examples of COUNTA

org.apache.poi.ss.formula.functions.Counta
Counts the number of cells that contain data within the list of arguments. Excel Syntax COUNTA(value1,value2,...) Value1, value2, ... are 1 to 30 arguments representing the values or ranges to be counted. @author Josh Micich
org.boris.expr.function.excel.COUNTA

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


        retval[ID.INDIRECT] = null; // Indirect.evaluate has different signature
        retval[162] = TextFunction.CLEAN;  //Aniket Banerjee    
        retval[167] = new IPMT();
        retval[168] = new PPMT();
        retval[169] = new Counta();


        retval[183] = AggregateFunction.PRODUCT;
        retval[184] = NumericFunction.FACT;


        retval[190] = LogicalFunction.ISNONTEXT;

View Full Code Here

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


        retval[ID.INDIRECT] = null; // Indirect.evaluate has different signature
        retval[162] = TextFunction.CLEAN;  //Aniket Banerjee    
        retval[167] = new IPMT();
        retval[168] = new PPMT();
        retval[169] = new Counta();


        retval[183] = AggregateFunction.PRODUCT;
        retval[184] = NumericFunction.FACT;


        retval[190] = LogicalFunction.ISNONTEXT;

View Full Code Here

Examples of org.boris.expr.function.excel.COUNTA

        assertEquals(eval(c, (Object) null, ExprMissing.MISSING), 0);
        assertEquals(eval(c, 1.2, -1.2), 2);
    }


    public void testCOUNTA() throws Exception {
        COUNTA c = new COUNTA();
        assertEquals(eval(c, 1, 2, 3, "asdf", true), 5);
        assertEquals(eval(c, (Object) null, ExprMissing.MISSING), 0);
        assertEquals(eval(c, 1.2, -1.2), 2);
    }

View Full Code Here

TOP

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.