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

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

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

org.apache.poi.ss.formula.functions.Rank
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. Syntax: RANK(number,ref,order) Number is the number whose rank you want to find. Ref is an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored. Order is a number specifying how to rank number. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order. @author Rubin Wang

        retval[197] = NumericFunction.TRUNC;
        retval[198] = LogicalFunction.ISLOGICAL;


        retval[212] = NumericFunction.ROUNDUP;
        retval[213] = NumericFunction.ROUNDDOWN;
        retval[216] = new Rank();
        retval[219] = new Address();  //Aniket Banerjee
        retval[220] = new Days360();
        retval[221] = new Today();


        retval[227] = AggregateFunction.MEDIAN;

View Full Code Here

        retval[197] = NumericFunction.TRUNC;
        retval[198] = LogicalFunction.ISLOGICAL;


        retval[212] = NumericFunction.ROUNDUP;
        retval[213] = NumericFunction.ROUNDDOWN;
        retval[216] = new Rank();
        retval[219] = new Address();  //Aniket Banerjee
        retval[220] = new Days360();
        retval[221] = new Today();


        retval[227] = AggregateFunction.MEDIAN;

View Full Code Here

TOP

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

org.apache.poi.ss.formula.eval.AreaEval

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

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

org.apache.poi.ss.formula.eval.ValueEval

org.apache.poi.ss.formula.eval.EvaluationException

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.