Error Message

In Analytica 4.3:

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".

In Analytica 4.4:

In the call to Function %1%, the value '%2%' passed to the «what» parameter is unrecognized.  
You should use one of the following values for «what»: "Value", "NumericValue", "Formula", "RelativeFormula", 
"NumberFormat", "BackColor", "Text Color", "FontName", "FontSize", "FontStyle", "WrapText", 
"Border[Left|Right|Up|Down][Color|Style|Weight]", "DirectPrecedents", "DirectDependents", "Precedents", 
or "Descendants".

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

Set the «what» parameter to one of the indicated values, or remove the parameter entirely.

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. Access to numerous cell parameters like number format, colors, borders, etc., were added in 4.4.

Error Messages/42552

Contents

Error Message

Cause

Remedy

Reference material

See Also