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

org.apache.poi.ss.formula.functions.Rept

Implementation for Excel REPT () function.

Syntax:
REPT (text,number_times )

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. text : text The text that you want to repeat. number_times: A positive number specifying the number of times to repeat text. If number_times is 0 (zero), REPT returns "" (empty text). If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point. The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!. @author cedric dot walter @ gmail dot com

        retval[25] = NumericFunction.INT;
        retval[26] = NumericFunction.SIGN;
        retval[27] = NumericFunction.ROUND;
        retval[28] = new Lookup();
        retval[29] = new Index();
        retval[30] = new Rept();


        retval[31] = TextFunction.MID;
        retval[32] = TextFunction.LEN;
        retval[33] = new Value();
        retval[34] = BooleanFunction.TRUE;

        retval[25] = NumericFunction.INT;
        retval[26] = NumericFunction.SIGN;
        retval[27] = NumericFunction.ROUND;
        retval[28] = new Lookup();
        retval[29] = new Index();
        retval[30] = new Rept();


        retval[31] = TextFunction.MID;
        retval[32] = TextFunction.LEN;
        retval[33] = new Value();
        retval[34] = BooleanFunction.TRUE;

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

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