net.sourceforge.fixagora.basis.server.control.spreadsheet
Class FormulaShifter

java.lang.Object
  net.sourceforge.fixagora.basis.server.control.spreadsheet.FormulaShifter

public class FormulaShifter
extends java.lang.Object

The Class FormulaShifter.

Constructor Summary

FormulaShifter(org.apache.poi.hssf.usermodel.HSSFWorkbook hssfWorkbook)
Instantiates a new formula shifter.

Method Summary

void	updateCellFormula(org.apache.poi.hssf.usermodel.HSSFCell cell, int colShift, int rowShift) Update cell formula.
static java.lang.String	updateCellReference(java.lang.String reference, int colShift, int rowShift) Update cell reference.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

FormulaShifter

public FormulaShifter(org.apache.poi.hssf.usermodel.HSSFWorkbook hssfWorkbook)

Instantiates a new formula shifter.

Parameters:

hssfWorkbook - the hssf workbook

Method Detail

updateCellFormula

public void updateCellFormula(org.apache.poi.hssf.usermodel.HSSFCell cell,
                              int colShift,
                              int rowShift)

Update cell formula.

Parameters:

cell - the cell

colShift - the col shift

rowShift - the row shift

updateCellReference

public static java.lang.String updateCellReference(java.lang.String reference,
                                                   int colShift,
                                                   int rowShift)

Update cell reference.

Parameters:

reference - the reference

colShift - the col shift

rowShift - the row shift

Returns:

the string