SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Overview / Arrays in a Formula
In This Topic
    Arrays in a Formula
    In This Topic

    Formulas may include functions that operate on arrays. SpreadJS supports array constants in formulas. Use curly brackets { } to enclose the array elements. Use a comma to separate elements within a row. Use a semicolon to separate rows within the array. Individual elements can be number values, text values, logical values, or error values. Some examples of arrays are: