User Tools

Site Tools


Guide Section: Interacting with an Excel spreadsheet | EASAP Tree: SPREADSHEET LISTSPREADSHEET

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 specify additional information; for example, a dimension may be entered as a Unit: or Cell Type: may be manually modified.

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
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