PasteOptions

PasteOptions interface

optional paste options. we can paste formulas or values, and we can use the source style, target style, or just use the source number formats.

formatting	optional	'source' \| 'target' \| 'number-formats' 'source' \| 'target' \| 'number-formats'	when pasting data from the clipboard, we can copy formatting/style from the original data, or we can retain the target range formatting and just paste data. a third option allows pasting source number formats but dropping other style information. defaults to "source", meaning paste source styles.
values	optional	boolean boolean	when clipboard data includes formulas, optionally paste calculated values instead of the original formulas. defaults to false.