Skip to content
TREB Docs

GetRangeOptions

GetRangeOptions interface

options for the GetRange method

Members
formattedoptional
boolean
boolean
return formatted values (apply number formats and return strings) (deprecated)
formulaoptional
boolean
boolean
return formulas instead of values. formula takes precedence over "formatted"; if you pass both, returned values will *not* be formatted. (deprecated)
typeoptional
'formatted' | 'formula'
'formatted' | 'formula'
optional style for returned values (replaces old flags).
Referenced by
EmbeddedSpreadsheet.GetRange