SpreadJS provides multiple paste options in a spreadsheet. These options are available when you access the context menu by right-clicking an active cell or a selected range.
Paste Option | Description |
---|---|
Paste All
|
Pastes all the cell contents in the target region.
|
Paste Formula
|
Pastes formula(s) without formatting in the target region.
|
Paste Value
|
Pastes formula results without formatting in the target region.
|
Paste Formatting
|
Pastes only the formatting in the target region. The pasted format is adjusted according to the size of the target region while pasting styles, spans, and conditional formats.
Note: Paste Formatting does not support 'Paste Skip Invisible Range'.
|
Paste Values and Formatting
|
Pastes values and formatting in the target region.
|
Paste Formula and Formatting
|
Pastes formula(s) with formatting in the target region.
|