Skip to content
TREB Docs

SetRangeOptions

SetRangeOptions interface

options for the SetRange method

Members
argument_separatoroptional
',' | ';'
',' | ';'
argument separator to use when parsing the input formula. set this option to call SetRange with a consistent argument separator, independent of current locale.
arrayoptional
boolean
boolean
apply as an array (as if you pressed ctrl+shift+enter)
r1c1optional
boolean
boolean
allow R1C1-style references; these can be either absolute addresses (e.g. R2C4) or relative to the cell (e.g. R[-3]C[0]).
recycleoptional
boolean
boolean
recycle values (R-style)
spilloptional
boolean
boolean
spill over
transposeoptional
boolean
boolean
transpose rectangular array before inserting
Referenced by
EmbeddedSpreadsheet.SetRange