ADD_ROW_BEFORE

Uses expression to search in a frame to select a set of row(s) in it and then inserts the range/frame before the selected row(s) returned by expression.‌

Syntax

ADD_ROW_BEFORE(targetFrame, searchExpr, frameOrRangeToAdd, [addAll])

• targetFrame - Target Frame.

• searchExpr - Search Expression.

• frameOrRangeToAdd - Frame/range to add.

• [addAll] - Add all row? (FALSE default)

Sample Usage

ADD_ROW_BEFORE(C1, "@number = 2", C2)
ADD_ROW_BEFORE(C1, D1, A6:B6)

Return Value

• TRUE if function modified the targetFrame.

• FALSE otherwise.

Notes

In order for ADD_ROW_BEFORE to work, the first argument targetFrame must be FRAME.

See Also