Examples of COUNTBLANK

org.apache.poi.ss.formula.functions.Countblank
Implementation for the function COUNTBLANK
Syntax: COUNTBLANK ( range )

range is the range of cells to count blanks

@author Mads Mohr Christensen
org.boris.expr.function.excel.COUNTBLANK

range	is the range of cells to count blanks

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

        retval[343] = NumericFunction.DEGREES;


        retval[344] = new Subtotal();
        retval[345] = new Sumif();
        retval[346] = new Countif();
        retval[347] = new Countblank();


        retval[354] = new Roman();


        retval[359] = new Hyperlink();

View Full Code Here

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

        retval[343] = NumericFunction.DEGREES;


        retval[344] = new Subtotal();
        retval[345] = new Sumif();
        retval[346] = new Countif();
        retval[347] = new Countblank();


        retval[354] = new Roman();


        retval[359] = new Hyperlink();

View Full Code Here

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

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


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

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.