CELL REFRESH synchronizes cells in Excel spreadsheets to EASAP data entry objects with active Range Reference: parameters.
Specify one or more SPREADSHEETs to refresh in Spreadsheets:
CELL REFRESH is recruited to increase responsive performance for EASAP-spreadsheet dependencies described in Objects:
|Spreadsheets:||Select spreadsheet(s) with the cell(s) to refresh|
|Do if:||logical expression, if TRUE then action performed, if FALSE then action NOT performed|
|Objects:||Select cell-linked objects the Author knows need to be refreshed (dependents are refreshed automatically as well).
The default blank setting here will refresh every cell in the spreadsheet(s)
|Separator:|| Set a character or string to separate the list in Objects:
Default: ' (or COMMA)
Valid Objects: include any UI objects with Range Reference: values set, as well as SUB PANEs or TABBED PANEs. Dependents of the specified objects and their child objects (useful for GUI objects) are refreshed from Excel as well.
With a large spreadsheet with many cells linked to EASAP objects it might become important to avoid a 'global' CELL REFRESH (update the spreadsheet's cells with values from all Excel-linked EASAP objects.
In this case the efficient approach to refreshing only Excel cells with values from EASAP objects which have been changed.
This use case puts WRITE EXCEL ACTIONs as CELL REFRESH > Objects: (a 'partial' CELL REFRESH) to push the specified EASAP object values and their dependents into an Excel spreadsheet without refreshing all the cells in a spreadsheet. For this case the SPREADSHEET must have Global Dependencies: TRUE
This gives the EASAP knowledge of which Excel cells are dependents (including both dependencies in the Excel spreadsheet and dependencies within the EASAP) of the WRITE EXCEL ACTION.
SPREADSHEET > Global dependencies:TRUE calculation adds some time to an 'EASAP Builder > Save' so we recommend setting the parameter just prior to publishing the EASAP.
Global Dependencies: TRUE should never be used with a CELL REFRESH with an empty Objects: parameter as Excel cell dependency knowledge actually slows down a 'global' CELL REFRESH.