CopyDownCellsTool
| Tool |
You can refer to this tool in any formula, macro, module, or other script in Blockpad. You can use either its name or its full path:
-
To refer to it by name, use
CopyDownCellsTool(make sure the library Library.Tools.Table is included with Include Libaries) - To refer to it by its full path, use
Library.Tools.Table.CopyDownCellsTool
See also:
In Blockpad, you can drag the bottom right corner of a cell selection to create value series or new cells with adjusted cell references.
Drag a cell selection to repeat content:
- Select the cells.
- Click and drag the bottom right of the selection.
- Release the mouse.
Patterns for creating new content:
- Formula offsets: any cell references (C4, AG3, D44) will be adjusted according to the new location of the formula.
- Any references to names are not adjusted. If a named cell (eg.
length = 3 ft) is referenced with the name, then it's not offset. To offset a named cell, use the cell reference in the formula instead of the name. - Formula offsets take any dollar signs ($) in a cell reference into account.
- Any references to names are not adjusted. If a named cell (eg.
- Arithmetic number series: Blockpad will continue an arithmetic series with the drag down tool. (3,6,9 or 1,2,3,4).
- Date series: dates will be continued based on the intervals of the selection.
- Alternating values: if Blockpad doesn't see any of the above patterns, then the selection will be repeated.