Copy Down Cells

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:
  1. Select the cells.
  2. Click and drag the bottom right of the selection.
  3. 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.
  • 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.
See also: