Any means that the parameter can take value of any type.
Function SET_CELL_VALUE() takes any value as a second argument.
Formula Expression argument means that a function takes a formula as an input parameter, which may be or may not be evaluated, depending on some conditions.
A good example of such "short-circuit" behavior is IF() function. In the following example, the 2nd and the 3rd parameters are of
Formula Exression type. Only one of them will be actually evaluated, depending on A1 value.
Another example uses named columns. To refer to a column, type its name prepended with
Function SET_FRAME_CELL() takes a formula expression as the third argument.
For the below example assume that cell
A1 contains a data frame with at least two columns:
How to read this: "In the data frame located at
A1 cell, set
price column value to
id column has value
Range type is a reference to a Spreadsheet cell, or to a range of cells. MINTDATA™ works with
A single-cell range:
A range of 5 columns and 5 rows:
A fixed range reference:
Range List type is a special type for functions, which can take more than one Range as an argument.
Executing multiple ranges with DO() function: