Aspose::Cells::ICopyOptions Class Referenceabstract

Represents the copy options. More...

Inherits Object.

Public Member Functions

virtual bool GetCopyNames ()=0
 Indicates whether copying the names. More...
 
virtual void SetCopyNames (bool value)=0
 Indicates whether copying the names. More...
 
virtual bool GetCopyInvalidFormulasAsValues ()=0
 If the formula is not valid for the dest destination, only copy values. More...
 
virtual void SetCopyInvalidFormulasAsValues (bool value)=0
 If the formula is not valid for the dest destination, only copy values. More...
 
virtual bool GetColumnCharacterWidth ()=0
 Indicates whether copying column width in unit of characters. More...
 
virtual void SetColumnCharacterWidth (bool value)=0
 Indicates whether copying column width in unit of characters. More...
 
virtual bool GetReferToSheetWithSameName ()=0
 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. More...
 
virtual void SetReferToSheetWithSameName (bool value)=0
 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. More...
 
virtual bool GetReferToDestinationSheet ()=0
 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. More...
 
virtual void SetReferToDestinationSheet (bool value)=0
 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. More...
 

Detailed Description

Represents the copy options.

Member Function Documentation

◆ GetColumnCharacterWidth()

virtual bool Aspose::Cells::ICopyOptions::GetColumnCharacterWidth ( )
pure virtual

Indicates whether copying column width in unit of characters.

◆ GetCopyInvalidFormulasAsValues()

virtual bool Aspose::Cells::ICopyOptions::GetCopyInvalidFormulasAsValues ( )
pure virtual

If the formula is not valid for the dest destination, only copy values.

◆ GetCopyNames()

virtual bool Aspose::Cells::ICopyOptions::GetCopyNames ( )
pure virtual

Indicates whether copying the names.

◆ GetReferToDestinationSheet()

virtual bool Aspose::Cells::ICopyOptions::GetReferToDestinationSheet ( )
pure virtual

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.

◆ GetReferToSheetWithSameName()

virtual bool Aspose::Cells::ICopyOptions::GetReferToSheetWithSameName ( )
pure virtual

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.

◆ SetColumnCharacterWidth()

virtual void Aspose::Cells::ICopyOptions::SetColumnCharacterWidth ( bool  value)
pure virtual

Indicates whether copying column width in unit of characters.

◆ SetCopyInvalidFormulasAsValues()

virtual void Aspose::Cells::ICopyOptions::SetCopyInvalidFormulasAsValues ( bool  value)
pure virtual

If the formula is not valid for the dest destination, only copy values.

◆ SetCopyNames()

virtual void Aspose::Cells::ICopyOptions::SetCopyNames ( bool  value)
pure virtual

Indicates whether copying the names.

◆ SetReferToDestinationSheet()

virtual void Aspose::Cells::ICopyOptions::SetReferToDestinationSheet ( bool  value)
pure virtual

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.

◆ SetReferToSheetWithSameName()

virtual void Aspose::Cells::ICopyOptions::SetReferToSheetWithSameName ( bool  value)
pure virtual

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.