org.apache.poi.xssf.usermodel.helpers
Class XSSFRowShifter

java.lang.Object
  extended by org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter

public final class XSSFRowShifter
extends java.lang.Object

Helper for shifting rows up or down


Constructor Summary
XSSFRowShifter(XSSFSheet sh)
           
 
Method Summary
 java.util.List<CellRangeAddress> shiftMerged(int startRow, int endRow, int n)
          Shift merged regions
 void updateConditionalFormatting(FormulaShifter shifter)
           
 void updateFormulas(FormulaShifter shifter)
          Update formulas.
 void updateHyperlinks(FormulaShifter shifter)
          Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink is of type LINK_DOCUMENT and refers to a cell that was shifted).
 void updateNamedRanges(FormulaShifter shifter)
          Updated named ranges
 void updateRowFormulas(XSSFRow row, FormulaShifter shifter)
          Update the formulas in specified row using the formula shifting policy specified by shifter
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

XSSFRowShifter

public XSSFRowShifter(XSSFSheet sh)
Method Detail

shiftMerged

public java.util.List<CellRangeAddress> shiftMerged(int startRow,
                                                    int endRow,
                                                    int n)
Shift merged regions

Parameters:
startRow - the row to start shifting
endRow - the row to end shifting
n - the number of rows to shift
Returns:
an array of affected cell regions

updateNamedRanges

public void updateNamedRanges(FormulaShifter shifter)
Updated named ranges


updateFormulas

public void updateFormulas(FormulaShifter shifter)
Update formulas.


updateRowFormulas

@Internal
public void updateRowFormulas(XSSFRow row,
                                       FormulaShifter shifter)
Update the formulas in specified row using the formula shifting policy specified by shifter

Parameters:
row - the row to update the formulas on
shifter - the formula shifting policy

updateConditionalFormatting

public void updateConditionalFormatting(FormulaShifter shifter)

updateHyperlinks

public void updateHyperlinks(FormulaShifter shifter)
Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink is of type LINK_DOCUMENT and refers to a cell that was shifted). Hyperlinks do not track the content they point to.

Parameters:
shifter -


Copyright 2016 The Apache Software Foundation or its licensors, as applicable.