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.
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
getKeepMacros/setKeepMacros
public boolean getKeepMacros() / public void setKeepMacros(boolean value)
Indicates whether keeping macros;
Only for copying workbook.
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)
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.
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.