CopyOptions

Inheritance: java.lang.Object

public class CopyOptions

Represents the copy options.

Constructors

ConstructorDescription
CopyOptions()CopyOptions constructor.

Methods

MethodDescription
equals(Object arg0)
getClass()
getColumnCharacterWidth()Indicates whether copying column width in unit of characters.
getCopyInvalidFormulasAsValues()If the formula is not valid for the dest destination, only copy values.
getCopyNames()Indicates whether copying the names.
getExtendToAdjacentRange()Indicates whether extend ranges when copying the range to adjacent range.
getKeepMacros()Indicates whether keeping macros;
getReferToDestinationSheet()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.
getReferToSheetWithSameName()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.
hashCode()
notify()
notifyAll()
setColumnCharacterWidth(boolean value)Indicates whether copying column width in unit of characters.
setCopyInvalidFormulasAsValues(boolean value)If the formula is not valid for the dest destination, only copy values.
setCopyNames(boolean value)Indicates whether copying the names.
setExtendToAdjacentRange(boolean value)Indicates whether extend ranges when copying the range to adjacent range.
setKeepMacros(boolean value)Indicates whether keeping macros;
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.
setReferToSheetWithSameName(boolean 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.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

CopyOptions()

public CopyOptions()

CopyOptions constructor.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getColumnCharacterWidth()

public boolean getColumnCharacterWidth()

Indicates whether copying column width in unit of characters.

Returns: boolean

getCopyInvalidFormulasAsValues()

public boolean getCopyInvalidFormulasAsValues()

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

Returns: boolean

getCopyNames()

public boolean getCopyNames()

Indicates whether copying the names.

Returns: boolean

getExtendToAdjacentRange()

public boolean getExtendToAdjacentRange()

Indicates whether extend ranges when copying the range to adjacent range.

Remarks

If it’s true, only extends the range of the hyperlink,not adding a new hyperlink when copying hyperlinks to adjacent rows.

Returns: boolean

getKeepMacros()

public boolean getKeepMacros()

Indicates whether keeping macros;

Remarks

Only for copying workbook.

Returns: boolean

getReferToDestinationSheet()

public boolean getReferToDestinationSheet()

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.

Remarks

The default value is false, it works as MS Excel.

Returns: boolean

getReferToSheetWithSameName()

public boolean getReferToSheetWithSameName()

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.

Remarks

The default value is true.

Returns: boolean

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setColumnCharacterWidth(boolean value)

public void setColumnCharacterWidth(boolean value)

Indicates whether copying column width in unit of characters.

Parameters:

ParameterTypeDescription
valueboolean

setCopyInvalidFormulasAsValues(boolean value)

public void setCopyInvalidFormulasAsValues(boolean value)

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

Parameters:

ParameterTypeDescription
valueboolean

setCopyNames(boolean value)

public void setCopyNames(boolean value)

Indicates whether copying the names.

Parameters:

ParameterTypeDescription
valueboolean

setExtendToAdjacentRange(boolean value)

public void setExtendToAdjacentRange(boolean value)

Indicates whether extend ranges when copying the range to adjacent range.

Remarks

If it’s true, only extends the range of the hyperlink,not adding a new hyperlink when copying hyperlinks to adjacent rows.

Parameters:

ParameterTypeDescription
valueboolean

setKeepMacros(boolean value)

public void setKeepMacros(boolean value)

Indicates whether keeping macros;

Remarks

Only for copying workbook.

Parameters:

ParameterTypeDescription
valueboolean

setReferToDestinationSheet(boolean value)

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.

Remarks

The default value is false, it works as MS Excel.

Parameters:

ParameterTypeDescription
valueboolean

setReferToSheetWithSameName(boolean value)

public void setReferToSheetWithSameName(boolean 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.

Remarks

The default value is true.

Parameters:

ParameterTypeDescription
valueboolean

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int