Top Description Fields Constructors Methods
org.apache.poi.hssf.usermodel.helpers

pack-priv final Class HSSFRowColShifter

extends Object
Class Inheritance
Annotations
@Internal
Imports
org.apache.logging.log4j.LogManager, .Logger, org.apache.poi.hssf.usermodel.*, org.apache.poi.ss.formula.*, org.apache.poi.ss.formula.ptg.Ptg, org.apache.poi.ss.usermodel.*, org.apache.poi.util.Internal
Class for code common to HSSFRowShifter and HSSFColumnShifter
Since
POI 5.1.0

Field Summary

Modifier and TypeField and Description
private static final Logger
LOG

Constructor Summary

AccessConstructor and Description
private
HSSFRowColShifter()

Method Summary

Modifier and TypeMethod and Description
pack-priv static String

Returns:

the shifted formula if the formula was changed, null if the formula wasn't modified
shiftFormula(Row
the row of the cell this formula belongs to. Used to get a reference to the parent workbook.
row, String
the formula to shift
formula, FormulaShifter
the FormulaShifter object that operates on the parsed formula tokens
formulaShifter)

Shift a formula using the supplied FormulaShifter

pack-priv static void
updateFormulas(Sheet sheet, FormulaShifter formulaShifter)

Update formulas.

pack-priv static void
updateRowFormulas(HSSFRow
the row to update the formulas on
row, FormulaShifter
the formula shifting policy
formulaShifter)

Update the formulas in specified row using the formula shifting policy specified by shifter

pack-priv static void
updateSheetFormulas(Sheet sh, FormulaShifter formulashifter)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

LOGback to summary
private static final Logger LOG

Constructor Detail

HSSFRowColShifterback to summary
private HSSFRowColShifter()

Method Detail

shiftFormulaback to summary
pack-priv static String shiftFormula(Row row, String formula, FormulaShifter formulaShifter)

Shift a formula using the supplied FormulaShifter

Parameters
row:Row

the row of the cell this formula belongs to. Used to get a reference to the parent workbook.

formula:String

the formula to shift

formulaShifter:FormulaShifter

the FormulaShifter object that operates on the parsed formula tokens

Returns:String

the shifted formula if the formula was changed, null if the formula wasn't modified

updateFormulasback to summary
pack-priv static void updateFormulas(Sheet sheet, FormulaShifter formulaShifter)

Update formulas.

updateRowFormulasback to summary
pack-priv static void updateRowFormulas(HSSFRow row, FormulaShifter formulaShifter)

Update the formulas in specified row using the formula shifting policy specified by shifter

Parameters
row:HSSFRow

the row to update the formulas on

formulaShifter:FormulaShifter

the formula shifting policy

updateSheetFormulasback to summary
pack-priv static void updateSheetFormulas(Sheet sh, FormulaShifter formulashifter)