Guide Section: Interacting with an Excel spreadsheet | EASAP Tree: SPREADSHEET LIST branch
FORMULA REFERENCE references a formula object within the worksheet specified in its Parent SHEET.
FORMULA REFERENCE 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) |