Guide Section: Interacting With Excel Spreadsheets | EASAP Tree: SPREADSHEET LIST Branch

A RANGE REFERENCE is used to refer to an individual cell within the worksheet specified in its parent SHEET.

The value of the cell referenced in the RANGE REFERENCE can then be linked to the value of certain data entry objects using their Range Reference: parameters.

Details on exchanging data between EASAPs and spreadsheet using the RANGE REFERENCE's in data entry objects is described in more detail in Exchanging Data with Spreadsheets.

RANGE REFERENCE
Essential Parameters:
Cell:	Cell location (eg. B6 → cell in the 2nd column, 6th row)
Optional Parameters:
Dependents:	Comma-separated list of cells dependent on this referenced cell. Set automatically by dependency calculation.
Additional Dependents:	Comma-separated list of dependent cells beyond calculated values. NOTE: Re-run dependency calculation after setting.(eg. [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, or let EASAP determine (default→Automatic, Both, Input, Output)