Sidebar
NAMED RANGE
Guide Section: Interacting with an Excel spreadsheet | EASAP Tree: SPREADSHEET LIST→ SPREADSHEET
A NAMED RANGE is created automatically by the EASAP Builder by reading the file in a SPREADSHEET.
An Author is encouraged to create 'named ranges' within a spreadsheet to allow an EASAP an explicit way to access cells.
- A NAMED RANGE may be used within a,
- Range Reference: of a data entry object
- Ranges: of an Excel action
A NAMED RANGE may specify additional information; for example, a dimension may be entered as a Unit: or Cell Type: may be manually modified.
 NAMED RANGE |
|
|---|---|
| Essential | |
| Object Name: | name of this object |
| Name: | select a NAMED RANGE from a list, the NAMED RANGE object name should be identical to this name |
| Optional | |
| Dependents: | comma-separated list of cells dependent on this referenced cell set automatically by dependency calculation, an Author may not change these but may specify Additional Dependents: |
| Additional Dependents: | comma-separated list of dependent cells that the dependency algorithm has failed to include ( [1!A5] → Cell A5 in Sheet 1) |
| Unit: | select unit of value stored in cell should be set when value in cell is not in the base unit used in EASAP for this value. |
| Cell Type: | set whether the cell is an INPUT or OUTPUT, or BOTH |
| Address: | address of the named range in the spreadsheet, updated after each save |
| Precedents: | populated when dependencies are calculated, when any of the listed cells are modified by an EXCEL WRITE ACTION, any user interface elements linked to this NAMED RANGE will be refreshed Author should not change this parameter. |
Below is an example of a NAMED RANGE
