org.apache.poi.xssf.usermodel.helpers

Class XSSFRowShifter

java.lang.Object

org.apache.poi.ss.usermodel.helpers.BaseRowColShifter

org.apache.poi.ss.usermodel.helpers.RowShifter

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

public final class XSSFRowShifter
extends RowShifter

Helper for shifting rows up or down (上下移动行的助手)

Field Summary

Fields inherited from class org.apache.poi.ss.usermodel.helpers.RowShifter

sheet

Constructor Summary

Constructors

Constructor and Description
XSSFRowShifter(XSSFSheet sh)

Method Summary

Modifier and Type	Method and Description
void	updateConditionalFormatting(FormulaShifter formulaShifter) Update conditional formatting (更新条件格式)
void	updateFormulas(FormulaShifter formulaShifter) Update formulas. (更新公式。)
void	updateHyperlinks(FormulaShifter formulaShifter) 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). (移动超链接锚点（不是超链接文本，即使超链接的类型为 LINK_DOCUMENT 并且指的是已移动的单元格）。)
void	updateNamedRanges(FormulaShifter formulaShifter) Update named ranges (更新命名范围)
void	updateRowFormulas(XSSFRow row, FormulaShifter formulaShifter) Update the formulas in specified row using the formula shifting policy specified by shifter (使用 shifter 指定的公式移位策略更新指定行中的公式)

Methods inherited from class org.apache.poi.ss.usermodel.helpers.RowShifter

shiftMergedRegions, validateShiftLeftParameters, validateShiftParameters

Methods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter

shiftRange

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

updateNamedRanges

public void updateNamedRanges(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

Update named ranges (更新命名范围)

Specified by:

updateNamedRanges in class BaseRowColShifter (类 BaseRowColShifter 中的 updateNamedRanges)

updateFormulas

public void updateFormulas(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

Update formulas. (更新公式。)

Specified by:

updateFormulas in class BaseRowColShifter (BaseRowColShifter 类中的更新公式)

updateRowFormulas

@Internal(since="3.15 beta 2")
public void updateRowFormulas(XSSFRow row,
                                                             FormulaShifter formulaShifter)

Update the formulas in specified row using the formula shifting policy specified by shifter (使用 shifter 指定的公式移位策略更新指定行中的公式)

Parameters:

row - the row to update the formulas on (row - 更新公式的行)

formulaShifter - the formula shifting policy (formulaShifter - 公式转换策略)

updateConditionalFormatting

public void updateConditionalFormatting(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

Update conditional formatting (更新条件格式)

Specified by:

updateConditionalFormatting in class BaseRowColShifter (类 BaseRowColShifter 中的 updateConditionalFormatting)

Parameters:

formulaShifter - The FormulaShifter to use (formulaShifter - 要使用的 FormulaShifter)

updateHyperlinks

public void updateHyperlinks(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

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. (移动超链接锚点（不是超链接文本，即使超链接的类型为 LINK_DOCUMENT 并且指的是已移动的单元格）。超链接不跟踪它们指向的内容。)

Specified by:

updateHyperlinks in class BaseRowColShifter (BaseRowColShifter 类中的 updateHyperlinks)

Parameters:

formulaShifter - the formula shifting policy (formulaShifter - 公式转换策略)