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:
| 7 | 4 |
| 4 | |
| -3 | 32 |
| 2 | -7.2 |
| 11 | 18 |
| 16 | 41 |
| 8 | |
After:
4 | 7 | 4 |
-3 | 4 | |
2 | -3 | 32 |
11 | 2 | -7.2 |
| 11 | 18 |
32 | 16 | 41 |
| 8 | |
($b2) = fill($c1:$d10,2,5,reverse)