User Tools

Site Tools


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

A RANGE REFERENCE refers 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.

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)
Cached Value:The most recent value(s)—cached within the EASAP—from Excel. This feature eliminates Excel overhead when the EASAP is loaded. Note: when an underlying spreadsheet is changed, the Author must toggle a single Cell Type: to blank, save the EASAP, and then return the value to its prior value in order to trigger a caching update.