src/org/tiefaces/components/websheet/configuration/ConfigRange.java
public final void shiftRowRef(final Sheet sheet, final int shiftnum) {
		try {
			this.setFirstRowRef(sheet
					.getRow(attrs.getFirstRowAddr().getRow() + shiftnum)
					.getCell(attrs.getFirstRowAddr().getColumn(),
							MissingCellPolicy.CREATE_NULL_AS_BLANK),
					false);
			this.setLastRowPlusRef(sheet,
					attrs.getLastRowPlusAddr().getColumn(),
					attrs.getLastRowPlusAddr().getRow() + shiftnum - 1,
					false);

			if (commandList != null) {
				for (ConfigCommand command : commandList) {
					command.shiftRowRef(sheet, shiftnum);
				}
			}

		} catch (Exception ex) {
			LOG.log(Level.SEVERE,
					"shiftRowRef error =" + ex.getLocalizedMessage(), ex);
		}
	}
public final void shiftRowRef(final Sheet sheet, final int shiftnum) {
		try {
			this.setFirstRowRef(sheet
					.getRow(attrs.getFirstRowAddr().getRow() + shiftnum)
					.getCell(attrs.getFirstRowAddr().getColumn(),
							MissingCellPolicy.CREATE_NULL_AS_BLANK),
					false);
			this.setLastRowPlusRef(sheet,
					attrs.getLastRowPlusAddr().getColumn(),
					attrs.getLastRowPlusAddr().getRow() + shiftnum - 1,
					false);

			if (commandList != null) {
				for (ConfigCommand command : commandList) {
					command.shiftRowRef(sheet, shiftnum);
				}
			}

		} catch (Exception ex) {
			LOG.log(Level.SEVERE,
					"shiftRowRef error =" + ex.getLocalizedMessage(), ex);
		}
	}
public final void shiftRowRef ( final Sheet sheet , final int shiftnum ) { try { this . setFirstRowRef ( sheet . getRow ( attrs . getFirstRowAddr ( ) . getRow ( ) + shiftnum ) . getCell ( attrs . getFirstRowAddr ( ) . getColumn ( ) , MissingCellPolicy . CREATE_NULL_AS_BLANK ) , false ) ; this . setLastRowPlusRef ( sheet , attrs . getLastRowPlusAddr ( ) . getColumn ( ) , attrs . getLastRowPlusAddr ( ) . getRow ( ) + shiftnum - 1 , false ) ; if ( commandList != null ) { for ( ConfigCommand command : commandList ) { command . shiftRowRef ( sheet , shiftnum ) ; } } } catch ( Exception ex ) { LOG . log ( Level . SEVERE , "shiftRowRef error =" + ex . getLocalizedMessage ( ) , ex ) ; } }
Shift row ref.

@param sheet
the sheet
@param shiftnum
the shiftnum
Shift row ref .