Skip to content
TREB Docs

EvaluateOptions

EvaluateOptions interface

options for the evaluate function

Members
argument_separatoroptional
',' | ';'
',' | ';'
argument separator to use when parsing input. set this option to use a consistent argument separator independent of current locale.
r1c1optional
boolean
boolean
allow R1C1-style references. the Evaluate function cannot use relative references (e.g. R[-1]C[0]), so those will always fail. however it may be useful to use direct R1C1 references (e.g. R3C4), so we optionally support that behind this flag.
Referenced by
EmbeddedSpreadsheet.InsertAnnotation
EmbeddedSpreadsheet.Evaluate