aspose.cells

aspose.cells

Class PasteOptions

Represents the paste special options.

Constructor Summary
PasteOptions()
 
Property Getters/Setters Summary
functiongetIgnoreLinksToOriginalFile()
function
setIgnoreLinksToOriginalFile(value)
           Ingore links to the original file.
functiongetKeepOldTables()
function
setKeepOldTables(value)
          
functiongetOnlyVisibleCells()
function
setOnlyVisibleCells(value)
           True means only copying visible cells.
functiongetOperationType()
function
setOperationType(value)
           Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.
functiongetPasteType()
function
setPasteType(value)
           The paste special type. The value of the property is PasteType integer constant.
functiongetShiftFormulasOfShapes()
function
setShiftFormulasOfShapes(value)
          
functiongetSkipBlanks()
function
setSkipBlanks(value)
           Indicates whether skips blank cells.
functiongetTranspose()
function
setTranspose(value)
           True to transpose rows and columns when the range is pasted. The default value is False.
 

    • Constructor Detail

      • PasteOptions

        function PasteOptions()

    • Property Getters/Setters Detail

      • getPasteType/setPasteType : Number 

        function getPasteType() / function setPasteType(value)
        The paste special type. The value of the property is PasteType integer constant.

      • getShiftFormulasOfShapes/setShiftFormulasOfShapes : boolean 

        function getShiftFormulasOfShapes() / function setShiftFormulasOfShapes(value)

      • getSkipBlanks/setSkipBlanks : boolean 

        function getSkipBlanks() / function setSkipBlanks(value)
        Indicates whether skips blank cells.

      • getKeepOldTables/setKeepOldTables : boolean 

        function getKeepOldTables() / function setKeepOldTables(value)

      • getOnlyVisibleCells/setOnlyVisibleCells : boolean 

        function getOnlyVisibleCells() / function setOnlyVisibleCells(value)
        True means only copying visible cells.

      • getTranspose/setTranspose : boolean 

        function getTranspose() / function setTranspose(value)
        True to transpose rows and columns when the range is pasted. The default value is False.

      • getOperationType/setOperationType : Number 

        function getOperationType() / function setOperationType(value)
        Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.

      • getIgnoreLinksToOriginalFile/setIgnoreLinksToOriginalFile : boolean 

        function getIgnoreLinksToOriginalFile() / function setIgnoreLinksToOriginalFile(value)
        Ingore links to the original file.