Examples of 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

org.boris.expr.function.excel.REPT

        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;

        assertEquals(eval(r, "2009", 3, 2, "10"), "2010");
        assertEquals(eval(r, "123456", 1, 3, "@"), "@456");
    }


    public void testREPT() throws Exception {
        REPT r = new REPT();
        assertResult("REPT({1},3.2)", "111");
        assertEquals(eval(r, "*-", 3), "*-*-*-");
        assertEquals(eval(r, "-", 10), "----------");
        assertException("rept(1,1,1)");
    }

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 Rept

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

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

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