- Excel Desktop Client new !
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.
|Cell:||Cell location (eg. B6 → cell in the 2nd column, 6th row)|
|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.|