@Internal public abstract class BaseRowColShifter extends java.lang.Object
RowShifter
and
ColumnShifter
Helper for shifting rows up or down and columns left and right
(RowShifter 和 ColumnShifter Helper 通用的代码类,用于向上或向下移动行以及向左和向右移动列)
Constructor and Description |
---|
BaseRowColShifter() |
Modifier and Type | Method and Description |
---|---|
abstract java.util.List<CellRangeAddress> |
shiftMergedRegions(int start, int end, int n)
Shifts, grows, or shrinks the merged regions due to a row shift (
RowShifter ) or column shift (
ColumnShifter ).
(由于行移位 (RowShifter) 或列移位 (ColumnShifter) 而移位、增长或缩小合并区域。)
|
static CellRangeAddress |
shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx) |
abstract void |
updateConditionalFormatting(FormulaShifter formulaShifter)
Update conditional formatting
(更新条件格式)
|
abstract void |
updateFormulas(FormulaShifter formulaShifter)
Update formulas.
(更新公式。)
|
abstract 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 并且指的是已移动的单元格)。)
|
abstract void |
updateNamedRanges(FormulaShifter formulaShifter)
Update named ranges
(更新命名范围)
|
public abstract void updateNamedRanges(FormulaShifter formulaShifter)
public abstract void updateFormulas(FormulaShifter formulaShifter)
public abstract java.util.List<CellRangeAddress> shiftMergedRegions(int start, int end, int n)
RowShifter
) or column shift (
ColumnShifter
). Merged regions that are completely overlaid by shifting will be deleted.
(由于行移位 (RowShifter) 或列移位 (ColumnShifter) 而移位、增长或缩小合并区域。通过移位完全覆盖的合并区域将被删除。)
start
- the first row or column to be shifted
(start - 要移动的第一行或第一列)
end
- the last row or column to be shifted
(end - 要移动的最后一行或最后一列)
n
- the number of rows or columns to shift
(n - 要移动的行数或列数)
public abstract void updateConditionalFormatting(FormulaShifter formulaShifter)
formulaShifter
- The
FormulaShifter
to use
(formulaShifter - 要使用的 FormulaShifter)
public abstract void updateHyperlinks(FormulaShifter formulaShifter)
formulaShifter
- the formula shifting policy
(formulaShifter - 公式转换策略)
public static CellRangeAddress shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.