Examples of Subtotal

org.apache.poi.ss.formula.functions.Subtotal

Implementation for the Excel function SUBTOTAL

Syntax :
SUBTOTAL ( functionCode, ref1, ref2 ... )

functionCode	(1-11) Selects the underlying aggregate function to be used (see table below)
ref1, ref2 ...	Arguments to be passed to the underlying aggregate function

functionCode	Aggregate Function
1	AVERAGE
2	COUNT
3	COUNTA
4	MAX
5	MIN
6	PRODUCT
7	STDEV
8	STDEVP *
9	SUM
10	VAR *
11	VARP *
101-111	*

* Not implemented in POI yet. Functions 101-111 are the same as functions 1-11 but with the option 'ignore hidden values'.

@author Paul Tomlin < pault at bulk sms dot com >

org.boris.expr.function.excel.SUBTOTAL

        retval[337] = NumericFunction.POWER;


        retval[342] = NumericFunction.RADIANS;
        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[337] = NumericFunction.POWER;


        retval[342] = NumericFunction.RADIANS;
        retval[343] = NumericFunction.DEGREES;


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


        retval[354] = new Roman();

            assertEquals("SQRT not working", eval(s, d), Math.sqrt(d));
        }
    }


    public void testSUBTOTAL() throws Exception {
        SUBTOTAL s = new SUBTOTAL();
        fail("SUBTOTAL not implemented");
    }

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.

Examples of Subtotal

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

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

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