User Tools

Site Tools


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

FORMULA REFERENCE references a formula object within the worksheet specified in its Parent SHEET object. This object is particularly useful in cases where an Excel sheet uses a formula for data validation.

Essential Parameters:
Formula:Name of formula within the Excel SHEET.
Optional Parameters:
Virtual Address:This parameter is used by the Excel Range Wizard and is not designed to be modified manually.
Dependents:Populated automatically after dependencies have been calculated.
Cell Type:Sets if the behavior should be (default→AUTOMATIC, INPUT only, OUTPUT only)