ArrayFormula

File Object Type

You can refer to this file object type 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 ArrayFormula (make sure the library Library.Docs.Objects is included with Include Libaries)
  • To refer to it by its full path, use Library.Docs.Objects.ArrayFormula

 

See also:

With Blockpad Array Formulas, you can display and interact with an array, vector, or matrix in a spreadsheet format.

Any formula with an array output can be an array formula.

Create an array formula:
  1. In a spreadsheet or table, type in a formula with an array output.
  2. When finished, press ctrl+shift+enter (instead of just enter).
Delete an array formula:
  • Press the delete key while any cell is selected.
Edit an array formula:
  1. Double click any cell in the array.
  2. Edit the formula.
  3. Press enter.
Examples:

Example 1

Example 2Example 2

Notes:
  • Array formulas will automatically expand if the result changes to have more rows or columns.
  • If there is a filled cell in the way of an array formula, the full array formula is still created, but the display is cut short and a dotted red line is displayed along that edge.

    • Red Line Example

See also: