Named ranges

Named ranges can represent cell references, constants, formulas, and tables. You can use named ranges to make report definitions more readable, for yourself and for other report authors. For example, if cell A1 contains Price and cell B2 contains Units, then this formula in C3 calculates Revenue:

=$A$1*$B$2

If you name cell A1 Price and cell B2 Units then you can write the formula as =Price*Units. Or, name cell C3 Revenue and define it as =Price*Units.

Names apply only to the report in which they are defined.

If a report uses a style sheet then names that you specify can potentially conflict with the style sheet. By default the names of ranges override style sheets.

Named cells exist only in Definition mode. In View mode, named cells behave as ordinary cells. For example, if a named cell is in a hyperblock, the cell is duplicated for each element displayed by the hyperblock.

Examples

This table shows examples of how named ranges can be used:


Without name	With name	Description
`=$C$27`	`=Connection`	C27 is named Connection.
`$A$1:$B$5`	`=Expense`	The cell range A1 to B5 is named Expense.
`=SUM($A$1:$B$5) *1.21`	`=SUM(Expense) * Tax`	The cell range A1 to B5 is named Expense and the cell that holds the value *1.21 is named Tax.
`=SIN(PI()/180 * 30)`	`=SIN(RadToDeg * 30)`	The calculation `PI()/180` is named RadtoDegree.