Ranges

A range is a contiguous group of cells described by its top-left and bottom-right cell references (both inclusive).

Ranges should be entered in the form

cell_reference_tl:cell_reference_br

Example:

A1:B3

This example describes a group of cells two columns wide and three rows deep, with cell A1 as its top left and cell B3 as its bottom right.

Note: Like its predecessor PipeDream, Fireworkz will accept ranges entered in the form A1B3, i.e. you need not use a colon to separate the two cell references which make up a range. The above example is given for users of other spreadsheet applications who are used to entering ranges using colon as a separator. All examples given in this documentation also use the colon separator in ranges for clarity.

A single cell may be specified as a range, e.g. B2:B2 .