fill

1. Syntax:

Return Range  dup(Range source, Integer width, Integer height)

Description:

Redistributes source to a new range at the location of the given cell with the dimensions given by width and height.

2. Syntax:

Return Range  dup(Range source, Integer width, Integer height, Identifier mode)

Description:

Redistributes source to a new range at the location of the given cell with the dimensions given by width and height in reverse.

Options:

Identifier mode:

Examples:

($a1) = fill($b2:$c5,1,6)
Before:
AB C
174
24
3-332
42-7.2
51118
61641
78
After:
AB C
1474
2-34
32-332
4112-7.2
51118
6321641
78
($b2) = fill($c1:$d10,2,5,reverse)