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
.