User Tools

Site Tools


FORMULA REFERENCE

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.

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)