Modifier and Type	Class and Description
public static class	CellCopyPolicy.Builder

Field Summary

Modifier and Type	Field and Description
private boolean	condenseRows
private boolean	copyCellFormula
private boolean	copyCellStyle
private boolean	copyCellValue
private boolean	copyHyperlink
private boolean	copyMergedRegions
private boolean	copyRowHeight
public static final boolean	DEFAULT_CONDENSE_ROWS_POLICY
public static final boolean	DEFAULT_COPY_CELL_FORMULA_POLICY
public static final boolean	DEFAULT_COPY_CELL_STYLE_POLICY
public static final boolean	DEFAULT_COPY_CELL_VALUE_POLICY
public static final boolean	DEFAULT_COPY_HYPERLINK_POLICY
public static final boolean	DEFAULT_COPY_MERGED_REGIONS_POLICY
public static final boolean	DEFAULT_COPY_ROW_HEIGHT_POLICY
public static final boolean	DEFAULT_MERGE_HYPERLINK_POLICY
private boolean	mergeHyperlink

Constructor Summary

Access	Constructor and Description
public	CellCopyPolicy() Default CellCopyPolicy, uses default policy For custom CellCopyPolicy, use `Builder` class
public	CellCopyPolicy(CellCopyPolicy policy to copy other) Copy constructor
private	CellCopyPolicy(CellCopyPolicy.Builder builder)

Method Summary

Modifier and Type	Method and Description
public CellCopyPolicy.Builder	createBuilder()
public boolean	Returns: the condenseRows setting isCondenseRows() If condenseRows is true, a discontinuity in srcRows will be removed when copied to destination For example: Sheet.copyRows({Row(1), Row(2), Row(5)}, 11, policy) results in rows 1, 2, and 5 being copied to rows 11, 12, and 13 if condenseRows is True, or rows 11, 11, 15 if condenseRows is false
public boolean	Returns: the copyCellFormula isCopyCellFormula()
public boolean	Returns: the copyCellStyle isCopyCellStyle()
public boolean	Returns: the copyCellValue isCopyCellValue()
public boolean	Returns: the copyHyperlink isCopyHyperlink()
public boolean	Returns: the copyMergedRegions isCopyMergedRegions()
public boolean	Returns: the copyRowHeight isCopyRowHeight()
public boolean	Returns: the mergeHyperlink isMergeHyperlink()
public void	setCondenseRows(boolean the condenseRows to set condenseRows) If condenseRows is true, a discontinuity in srcRows will be removed when copied to destination For example: Sheet.copyRows({Row(1), Row(2), Row(5)}, 11, policy) results in rows 1, 2, and 5 being copied to rows 11, 12, and 13 if condenseRows is True, or rows 11, 11, 15 if condenseRows is false
public void	setCopyCellFormula(boolean the copyCellFormula to set copyCellFormula)
public void	setCopyCellStyle(boolean the copyCellStyle to set copyCellStyle)
public void	setCopyCellValue(boolean the copyCellValue to set copyCellValue)
public void	setCopyHyperlink(boolean the copyHyperlink to set copyHyperlink)
public void	setCopyMergedRegions(boolean the copyMergedRegions to set copyMergedRegions)
public void	setCopyRowHeight(boolean the copyRowHeight to set copyRowHeight)
public void	setMergeHyperlink(boolean the mergeHyperlink to set mergeHyperlink)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

condenseRows	back to summary
private boolean condenseRows

copyCellFormula	back to summary
private boolean copyCellFormula

copyCellStyle	back to summary
private boolean copyCellStyle

copyCellValue	back to summary
private boolean copyCellValue

copyHyperlink	back to summary
private boolean copyHyperlink

copyMergedRegions	back to summary
private boolean copyMergedRegions

copyRowHeight	back to summary
private boolean copyRowHeight

DEFAULT_CONDENSE_ROWS_POLICY	back to summary
public static final boolean DEFAULT_CONDENSE_ROWS_POLICY

DEFAULT_COPY_CELL_FORMULA_POLICY	back to summary
public static final boolean DEFAULT_COPY_CELL_FORMULA_POLICY

DEFAULT_COPY_CELL_STYLE_POLICY	back to summary
public static final boolean DEFAULT_COPY_CELL_STYLE_POLICY

DEFAULT_COPY_CELL_VALUE_POLICY	back to summary
public static final boolean DEFAULT_COPY_CELL_VALUE_POLICY

DEFAULT_COPY_HYPERLINK_POLICY	back to summary
public static final boolean DEFAULT_COPY_HYPERLINK_POLICY

DEFAULT_COPY_MERGED_REGIONS_POLICY	back to summary
public static final boolean DEFAULT_COPY_MERGED_REGIONS_POLICY

DEFAULT_COPY_ROW_HEIGHT_POLICY	back to summary
public static final boolean DEFAULT_COPY_ROW_HEIGHT_POLICY

DEFAULT_MERGE_HYPERLINK_POLICY	back to summary
public static final boolean DEFAULT_MERGE_HYPERLINK_POLICY

mergeHyperlink	back to summary
private boolean mergeHyperlink

Constructor Detail

CellCopyPolicy	back to summary
public CellCopyPolicy() Default CellCopyPolicy, uses default policy For custom CellCopyPolicy, use `Builder` class

CellCopyPolicy	back to summary
public CellCopyPolicy(CellCopyPolicy other) Copy constructor Parameters other:CellCopyPolicy policy to copy

CellCopyPolicy

back to summary

public CellCopyPolicy(CellCopyPolicy other)

Copy constructor

Parameters

other:CellCopyPolicy: policy to copy

CellCopyPolicy	back to summary
private CellCopyPolicy(CellCopyPolicy.Builder builder)

Method Detail

createBuilder	back to summary
public CellCopyPolicy.Builder createBuilder()

isCondenseRows	back to summary
public boolean isCondenseRows() If condenseRows is true, a discontinuity in srcRows will be removed when copied to destination For example: Sheet.copyRows({Row(1), Row(2), Row(5)}, 11, policy) results in rows 1, 2, and 5 being copied to rows 11, 12, and 13 if condenseRows is True, or rows 11, 11, 15 if condenseRows is false Returns:boolean the condenseRows setting

isCondenseRows

back to summary

public boolean isCondenseRows()

If condenseRows is true, a discontinuity in srcRows will be removed when copied to destination

For example:

Sheet.copyRows({Row(1), Row(2), Row(5)}, 11, policy) results in rows 1, 2, and 5 being copied to rows 11, 12, and 13 if condenseRows is True, or rows 11, 11, 15 if condenseRows is false

Returns:boolean: the condenseRows setting

isCopyCellFormula	back to summary
public boolean isCopyCellFormula() Returns:boolean the copyCellFormula

isCopyCellStyle	back to summary
public boolean isCopyCellStyle() Returns:boolean the copyCellStyle

isCopyCellValue	back to summary
public boolean isCopyCellValue() Returns:boolean the copyCellValue

isCopyHyperlink	back to summary
public boolean isCopyHyperlink() Returns:boolean the copyHyperlink

isCopyMergedRegions	back to summary
public boolean isCopyMergedRegions() Returns:boolean the copyMergedRegions

isCopyRowHeight	back to summary
public boolean isCopyRowHeight() Returns:boolean the copyRowHeight

isMergeHyperlink	back to summary
public boolean isMergeHyperlink() Returns:boolean the mergeHyperlink

setCondenseRows	back to summary
public void setCondenseRows(boolean condenseRows) If condenseRows is true, a discontinuity in srcRows will be removed when copied to destination For example: Sheet.copyRows({Row(1), Row(2), Row(5)}, 11, policy) results in rows 1, 2, and 5 being copied to rows 11, 12, and 13 if condenseRows is True, or rows 11, 11, 15 if condenseRows is false Parameters condenseRows:boolean the condenseRows to set

setCondenseRows

back to summary

public void setCondenseRows(boolean condenseRows)

If condenseRows is true, a discontinuity in srcRows will be removed when copied to destination

For example:

Sheet.copyRows({Row(1), Row(2), Row(5)}, 11, policy) results in rows 1, 2, and 5 being copied to rows 11, 12, and 13 if condenseRows is True, or rows 11, 11, 15 if condenseRows is false

Parameters

condenseRows:boolean: the condenseRows to set

setCopyCellFormula	back to summary
public void setCopyCellFormula(boolean copyCellFormula) Parameters copyCellFormula:boolean the copyCellFormula to set

setCopyCellStyle	back to summary
public void setCopyCellStyle(boolean copyCellStyle) Parameters copyCellStyle:boolean the copyCellStyle to set

setCopyCellValue	back to summary
public void setCopyCellValue(boolean copyCellValue) Parameters copyCellValue:boolean the copyCellValue to set

setCopyHyperlink	back to summary
public void setCopyHyperlink(boolean copyHyperlink) Parameters copyHyperlink:boolean the copyHyperlink to set

setCopyMergedRegions	back to summary
public void setCopyMergedRegions(boolean copyMergedRegions) Parameters copyMergedRegions:boolean the copyMergedRegions to set

setCopyRowHeight	back to summary
public void setCopyRowHeight(boolean copyRowHeight) Parameters copyRowHeight:boolean the copyRowHeight to set

setMergeHyperlink	back to summary
public void setMergeHyperlink(boolean mergeHyperlink) Parameters mergeHyperlink:boolean the mergeHyperlink to set

org.apache.poi.ss.usermodel back to summary

public Class CellCopyPolicy.Builder

Class Inheritance

extends Object

java.lang.Object
org.apache.poi.ss.usermodel.CellCopyPolicy.Builder

Field Summary

Modifier and Type	Field and Description
private boolean	condenseRows
private boolean	copyCellFormula
private boolean	copyCellStyle
private boolean	copyCellValue
private boolean	copyHyperlink
private boolean	copyMergedRegions
private boolean	copyRowHeight
private boolean	mergeHyperlink

Constructor Summary

Access	Constructor and Description
public	Builder() Builder class for CellCopyPolicy

Method Summary

Modifier and Type	Method and Description
public CellCopyPolicy	build()
public CellCopyPolicy.Builder	cellFormula(boolean copyCellFormula)
public CellCopyPolicy.Builder	cellStyle(boolean copyCellStyle)
public CellCopyPolicy.Builder	cellValue(boolean copyCellValue)
public CellCopyPolicy.Builder	condenseRows(boolean condenseRows)
public CellCopyPolicy.Builder	copyHyperlink(boolean copyHyperlink)
public CellCopyPolicy.Builder	mergedRegions(boolean copyMergedRegions)
public CellCopyPolicy.Builder	mergeHyperlink(boolean mergeHyperlink)
public CellCopyPolicy.Builder	rowHeight(boolean copyRowHeight)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

condenseRows	back to summary
private boolean condenseRows

copyCellFormula	back to summary
private boolean copyCellFormula

copyCellStyle	back to summary
private boolean copyCellStyle

copyCellValue	back to summary
private boolean copyCellValue

copyHyperlink	back to summary
private boolean copyHyperlink

copyMergedRegions	back to summary
private boolean copyMergedRegions

copyRowHeight	back to summary
private boolean copyRowHeight

mergeHyperlink	back to summary
private boolean mergeHyperlink

Constructor Detail

Builder	back to summary
public Builder() Builder class for CellCopyPolicy

Method Detail

build	back to summary
public CellCopyPolicy build()

cellFormula	back to summary
public CellCopyPolicy.Builder cellFormula(boolean copyCellFormula)

cellStyle	back to summary
public CellCopyPolicy.Builder cellStyle(boolean copyCellStyle)

cellValue	back to summary
public CellCopyPolicy.Builder cellValue(boolean copyCellValue)

condenseRows	back to summary
public CellCopyPolicy.Builder condenseRows(boolean condenseRows)

copyHyperlink	back to summary
public CellCopyPolicy.Builder copyHyperlink(boolean copyHyperlink)

mergedRegions	back to summary
public CellCopyPolicy.Builder mergedRegions(boolean copyMergedRegions)

mergeHyperlink	back to summary
public CellCopyPolicy.Builder mergeHyperlink(boolean mergeHyperlink)

rowHeight	back to summary
public CellCopyPolicy.Builder rowHeight(boolean copyRowHeight)

public Class CellCopyPolicy

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public Class CellCopyPolicy.Builder

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail