com.aspose.cells

com.aspose.cells

Class CopyOptions

  • java.lang.Object
    • com.aspose.cells.CopyOptions
public class CopyOptions 
extends java.lang.Object

Represents the copy options.

Constructor Summary
CopyOptions()
CopyOptions constructor.
 
Property Getters/Setters Summary
booleangetColumnCharacterWidth()
void
setColumnCharacterWidth(booleanvalue)
           Indicates whether copying column width in unit of characters.
booleangetCopyInvalidFormulasAsValues()
void
setCopyInvalidFormulasAsValues(booleanvalue)
           If the formula is not valid for the dest destination, only copy values.
booleangetCopyNames()
void
setCopyNames(booleanvalue)
           Indicates whether copying the names.
booleangetExtendToAdjacentRange()
void
setExtendToAdjacentRange(booleanvalue)
           Indicates whether extend ranges when copying the range to adjacent range.
booleangetReferToDestinationSheet()
void
setReferToDestinationSheet(booleanvalue)
           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.
booleangetReferToSheetWithSameName()
void
setReferToSheetWithSameName(booleanvalue)
           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

        public CopyOptions()
        CopyOptions constructor.

    • Property Getters/Setters Detail

      • getExtendToAdjacentRange/setExtendToAdjacentRange

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

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

      • getCopyInvalidFormulasAsValues/setCopyInvalidFormulasAsValues

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

      • getColumnCharacterWidth/setColumnCharacterWidth

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

      • getReferToSheetWithSameName/setReferToSheetWithSameName

        public boolean getReferToSheetWithSameName() / public void setReferToSheetWithSameName(boolean 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

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

    setExtendToAdjacentRange

    public voidsetExtendToAdjacentRange(booleanvalue)
    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.

    setCopyNames

    public voidsetCopyNames(booleanvalue)
    Indicates whether copying the names.

    setCopyInvalidFormulasAsValues

    public voidsetCopyInvalidFormulasAsValues(booleanvalue)
    If the formula is not valid for the dest destination, only copy values.

    setColumnCharacterWidth

    public voidsetColumnCharacterWidth(booleanvalue)
    Indicates whether copying column width in unit of characters.

    setReferToSheetWithSameName

    public voidsetReferToSheetWithSameName(booleanvalue)
    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.

    setReferToDestinationSheet

    public voidsetReferToDestinationSheet(booleanvalue)
    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.