ArrayFormula

File Object Type

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:

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: