Class Rept

  • All Implemented Interfaces:
    Function, Function2Arg

    public class Rept
    extends Fixed2ArgFunction
    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!.