asposecells.api

asposecells.api

Class CopyOptions

Represents the copy options.

Constructor Summary
CopyOptions()
CopyOptions constructor.
 
Property Getters/Setters Summary
methodgetColumnCharacterWidth()
method
setColumnCharacterWidth(value)
           Indicates whether copying column width in unit of characters.
methodgetCopyInvalidFormulasAsValues()
method
setCopyInvalidFormulasAsValues(value)
           If the formula is not valid for the dest destination, only copy values.
methodgetCopyNames()
method
setCopyNames(value)
           Indicates whether copying the names.
methodgetExtendToAdjacentRange()
method
setExtendToAdjacentRange(value)
           Indicates whether extend ranges when copying the range to adjacent range.
methodgetKeepMacros()
method
setKeepMacros(value)
           Indicates whether keeping macros;
methodgetReferToDestinationSheet()
method
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.
methodgetReferToSheetWithSameName()
method
setReferToSheetWithSameName(value)
           When copying a worksheet to another workbook and the worksheet contains the formulas which refer to other worksheets in MS Excel, the copied formulas should refer to source workbook. But sometimes we have copied other worksheets and we hope the copied formulas refer to other worksheets with the name in the same workbook, please set this property as true.
 

    • Constructor Detail

      • CopyOptions

        CopyOptions()
        CopyOptions constructor.

    • Property Getters/Setters Detail

      • getKeepMacros/setKeepMacros : boolean 

        boolean getKeepMacros() / setKeepMacros(value)
        Indicates whether keeping macros; Only for copying workbook.

      • getExtendToAdjacentRange/setExtendToAdjacentRange : boolean 

        boolean getExtendToAdjacentRange() / 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 

        boolean getCopyNames() / setCopyNames(value)
        Indicates whether copying the names.

      • getCopyInvalidFormulasAsValues/setCopyInvalidFormulasAsValues : boolean 

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

      • getColumnCharacterWidth/setColumnCharacterWidth : boolean 

        boolean getColumnCharacterWidth() / setColumnCharacterWidth(value)
        Indicates whether copying column width in unit of characters.

      • getReferToSheetWithSameName/setReferToSheetWithSameName : boolean 

        boolean getReferToSheetWithSameName() / setReferToSheetWithSameName(value)
        When copying a worksheet to another workbook and the worksheet contains the formulas which refer to other worksheets in MS Excel, the copied formulas should refer to source workbook. But sometimes we have copied other worksheets and we hope the copied formulas refer to other worksheets with the name in the same workbook, please set this property as true. The default value is true.

      • getReferToDestinationSheet/setReferToDestinationSheet : boolean 

        boolean getReferToDestinationSheet() / 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.