Error Messages/42552


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.

Note that "Border[Left|Right|Up|Down][Color|Style|Weight]" is not a recognized value, but rather the values "BorderLeftColor", "BorderLeftStyle", "BorderUpWeight", etc., are recognized.

BorderLeftStyle: There is a bug in release 4.4.1 -- the error message says this is an acceptable value, but the function doesn't accept it. The function will accept "BorderLeftLineStyle".

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 (referring 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 Analytica 4.4.

See Also

Comments


You are not allowed to post comments.