final int left = ref.getLeftCol() + colOffset;
final int top = ref.getTopRow() + rowOffset;
final int right = ref.getRightCol() + colOffset;
final int bottom = ref.getBottomRow() + rowOffset;
final RefSheet refSheet = ref.getOwnerSheet();
final int nleft = colOffset < 0 ? Math.max(0, left) : left;
final int ntop = rowOffset < 0 ? Math.max(0, top) : top;
final int nright = colOffset > 0 ? Math.min(maxCol, right) : right;
final int nbottom = rowOffset > 0 ? Math.min(maxRow, bottom) : bottom;