CellReference tempRef = new CellReference(templateRange.getSheet(), templateCell);
CellReference newRef = new CellReference(templateRange.getSheet(), newCell.getR());
newRef.move(newRow.getR().intValue(), newRef.getColumn());
if (bandData.getOrientation() == BandOrientation.VERTICAL) {
newRef.shift(0, previousRangesRightOffset);
}
newCell.setR(newRef.toReference());
newRow.getC().add(newCell);