Copy Reference

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 CopyReferenceTool (make sure the library Library.Tools.Edit is included with Include Libaries)
  • To refer to it by its full path, use Library.Tools.Edit.CopyReferenceTool

 

See also:


The copy reference tool gives another method to reference cells or values in a formula. It can also be used to create hyperlinks to top level frames.

Typically, you click on a value while a formula is open to reference that value. With copy reference, you can copy the reference name of a value before ever opening a formula, then paste that reference into the formula you choose.

Use copy reference for a value name:
  1. Right click on a cell, dynamic expression, or drawing label.
  2. Select Copy Reference.
  3. Open a formula.
  4. Paste the reference in (ctrl+v or Right Click>Paste).
Use copy reference for a hyperlink address:
  1. Right click on a top level frame in the left of the screen.
  2. Select Copy Reference.
  3. Insert a hyperlink.
  4. Paste the reference in (ctrl+v or Right Click>Paste).
Notes:
  • When you paste a copied reference in Blockpad, the reference is fitted to the destination. For example, if you copy cell B5 in Sheet1, it will paste as B5 in Sheet1, but as Sheet1.B5 if pasted into Sheet2.
  • Copy Reference also works for table ranges. You can select a range in a table or spreadsheet, click Copy Reference, and then paste the range into a formula.
  • If you paste a copied reference into another file, Blockpad will automatically create an external reference to link to the copied reference.
See also: