EASA Help Pages

User Tools

Site Tools

You are here: EASA 6.0 » What is an EASA system? » EASA Guides » Author's Guide » Tree Objects » RANGE REFERENCE

Sidebar

Homepage | About EASA | Contact

Contents

RANGE REFERENCE

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 a data entry object using its 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)
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.

Page Tools