SpreadJS 15
Features / Cells / Paste Options
In This Topic
    Paste Options
    In This Topic

    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.