SetRangeOptions
SetRangeOptions interface
options for the SetRange method
Members
argument_separator | optional | argument separator to use when parsing the input formula. set this option to call SetRange with a consistent argument separator, independent of current locale. | |
array | optional | boolean boolean | apply as an array (as if you pressed ctrl+shift+enter) |
r1c1 | optional | 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]). |
recycle | optional | boolean boolean | recycle values (R-style) |
spill | optional | boolean boolean | spill over |
transpose | optional | boolean boolean | transpose rectangular array before inserting |
Referenced by
EmbeddedSpreadsheet.SetRange |