Sidebar
FORMULA REFERENCE
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.
 FORMULA REFERENCE |
|
|---|---|
| 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) |