Top Fields Constructors Methods
org.apache.poi.ss.usermodel

public abstract Class RangeCopier

extends Object
Class Inheritance
Known Direct Subclasses
org.apache.poi.hssf.usermodel.HSSFRangeCopier
Annotations
@Beta
Imports
java.util.HashMap, .Map, org.apache.poi.ss.formula.FormulaShifter, org.apache.poi.ss.formula.ptg.Ptg, org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.util.Beta

Field Summary

Modifier and TypeField and Description
private Sheet
destSheet

private FormulaShifter
horizontalFormulaShifter

private Sheet
sourceSheet

private FormulaShifter
verticalFormulaShifter

Constructor Summary

AccessConstructor and Description
public
RangeCopier(Sheet sourceSheet, Sheet destSheet)

public
RangeCopier(Sheet sheet)

Method Summary

Modifier and TypeMethod and Description
protected abstract void
adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY)

protected boolean
adjustInBothDirections(Ptg[] ptgs, int sheetIndex, int deltaX, int deltaY)

public static void
cloneCellContent(Cell srcCell, Cell destCell, Map<Integer, CellStyle> styleMap)

public void
copyRange(CellRangeAddress
source range which should be copied in tiled manner
tilePatternRange, CellRangeAddress
destination range, which should be overridden
tileDestRange)

Uses input pattern to tile destination region, overwriting existing content.

public void
copyRange(CellRangeAddress
source range which should be copied in tiled manner
tilePatternRange, CellRangeAddress
destination range, which should be overridden
tileDestRange, boolean
whether to copy the cell styles
copyStyles, boolean
whether to copy merged ranges
copyMergedRanges)

Uses input pattern to tile destination region, overwriting existing content.

private void
copyRange(CellRangeAddress sourceRange, int deltaX, int deltaY, Sheet sourceClone, Map<Integer, CellStyle> styleMap)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

destSheetback to summary
private Sheet destSheet
horizontalFormulaShifterback to summary
private FormulaShifter horizontalFormulaShifter
sourceSheetback to summary
private Sheet sourceSheet
verticalFormulaShifterback to summary
private FormulaShifter verticalFormulaShifter

Constructor Detail

RangeCopierback to summary
public RangeCopier(Sheet sourceSheet, Sheet destSheet)
RangeCopierback to summary
public RangeCopier(Sheet sheet)

Method Detail

adjustCellReferencesInsideFormulaback to summary
protected abstract void adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY)
adjustInBothDirectionsback to summary
protected boolean adjustInBothDirections(Ptg[] ptgs, int sheetIndex, int deltaX, int deltaY)
cloneCellContentback to summary
public static void cloneCellContent(Cell srcCell, Cell destCell, Map<Integer, CellStyle> styleMap)
copyRangeback to summary
public void copyRange(CellRangeAddress tilePatternRange, CellRangeAddress tileDestRange)

Uses input pattern to tile destination region, overwriting existing content. Works in following manner : 1.Start from top-left of destination. 2.Paste source but only inside of destination borders. 3.If there is space left on right or bottom side of copy, process it as in step 2.

Parameters
tilePatternRange:CellRangeAddress

source range which should be copied in tiled manner

tileDestRange:CellRangeAddress

destination range, which should be overridden

copyRangeback to summary
public void copyRange(CellRangeAddress tilePatternRange, CellRangeAddress tileDestRange, boolean copyStyles, boolean copyMergedRanges)

Uses input pattern to tile destination region, overwriting existing content. Works in following manner : 1.Start from top-left of destination. 2.Paste source but only inside of destination borders. 3.If there is space left on right or bottom side of copy, process it as in step 2.

Parameters
tilePatternRange:CellRangeAddress

source range which should be copied in tiled manner

tileDestRange:CellRangeAddress

destination range, which should be overridden

copyStyles:boolean

whether to copy the cell styles

copyMergedRanges:boolean

whether to copy merged ranges

Since
5.0.0
copyRangeback to summary
private void copyRange(CellRangeAddress sourceRange, int deltaX, int deltaY, Sheet sourceClone, Map<Integer, CellStyle> styleMap)