aspose.cells

Class CopyOptions

Represents the copy options.

Constructor Summary
CopyOptions()
CopyOptions constructor.
 
Property Getters/Setters Summary
functiongetColumnCharacterWidth()
function
           Indicates whether copying column width in unit of characters.
functiongetCopyInvalidFormulasAsValues()
function
           If the formula is not valid for the dest destination, only copy values.
functiongetCopyNames()
function
           Indicates whether copying the names.
functiongetExtendToAdjacentRange()
function
           Indicates whether extend ranges when copying the range to adjacent range.
functiongetKeepMacros()
function
           Indicates whether keeping macros;
functiongetReferToDestinationSheet()
function
           When copying the range in the same file and the chart refers to the source sheet, False means the copied chart's data source will not be changed. True means the copied chart's data source refers to the destination sheet.
functiongetReferToSheetWithSameName()
function
           In ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one, the copied formulas should refer to source workbook. However, for some situations user may need the copied formulas refer to worksheets with the same name in the same workbook, such as when those worksheets have been copied before this copy operation, then this property should be kept as true.
 

    • Constructor Detail

      • CopyOptions

        function CopyOptions()
        CopyOptions constructor.
    • Property Getters/Setters Detail

      • getKeepMacros/setKeepMacros : boolean 

        function getKeepMacros() / function setKeepMacros(value)
        
        Indicates whether keeping macros; Only for copying workbook.
      • getExtendToAdjacentRange/setExtendToAdjacentRange : boolean 

        function getExtendToAdjacentRange() / function setExtendToAdjacentRange(value)
        
        Indicates whether extend ranges when copying the range to adjacent range. If it's true, only extends the range of the hyperlink,not adding a new hyperlink when copying hyperlinks to adjacent rows.
      • getCopyNames/setCopyNames : boolean 

        function getCopyNames() / function setCopyNames(value)
        
        Indicates whether copying the names.
      • getCopyInvalidFormulasAsValues/setCopyInvalidFormulasAsValues : boolean 

        function getCopyInvalidFormulasAsValues() / function setCopyInvalidFormulasAsValues(value)
        
        If the formula is not valid for the dest destination, only copy values.
      • getColumnCharacterWidth/setColumnCharacterWidth : boolean 

        function getColumnCharacterWidth() / function setColumnCharacterWidth(value)
        
        Indicates whether copying column width in unit of characters.
      • getReferToSheetWithSameName/setReferToSheetWithSameName : boolean 

        function getReferToSheetWithSameName() / function setReferToSheetWithSameName(value)
        
        In ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one, the copied formulas should refer to source workbook. However, for some situations user may need the copied formulas refer to worksheets with the same name in the same workbook, such as when those worksheets have been copied before this copy operation, then this property should be kept as true. The default value is true.
      • getReferToDestinationSheet/setReferToDestinationSheet : boolean 

        function getReferToDestinationSheet() / function setReferToDestinationSheet(value)
        
        When copying the range in the same file and the chart refers to the source sheet, False means the copied chart's data source will not be changed. True means the copied chart's data source refers to the destination sheet. The default value is false, it works as MS Excel.