Error Messages/42552

Error Message

In the call to Function SpreadsheetRange, the value 'Vals' passed to the «what» parameter is unrecognized. 
You should use one of the following values for «what»: "Value", "NumericValue", "Formula", or "RelativeFormula".

Cause

You have specified the optional «what» parameter to the indicated function, either SpreadsheetRange or SpreadsheetCell, but not given it a recognized value. That parameter recognizes only the indicated values.

Remedy

Correct the parameter value.

Reference material

SpreadsheetRange(..., what:"Value" )

retrieves the computed values, with dates imported as date-time numbers.

SpreadsheetRange(..., what:"NumericValue" )

retrieves the computed values, with the numeric value of dates imported as numbers, rather than as date-time values.

SpreadsheetRange(..., what:"Formula" )

retrieves the cell formula in the format you would see from the Excel user interface. For example: "=Sum(D4:D10)"

SpreadsheetRange(..., what:"RelativeFormula" )

retrieves the cell formula in a relative offset format, so that formulas that are essentially the same (refering to the same relative offsets) will end up being identical. For example, "=Sum(R[-10]C:R[-4]C)"

The «what» parameter was introduced in Analytica 4.3.

See Also

Comments


You are not allowed to post comments.