shiftRows

Shifts one or more rows up or down.

shiftRows( workbook, start [, end [, offset ] ] )

##Required arguments

• workbook spreadsheet object
• start numeric: The number of the first, or only, row to shift.

##Optional arguments

• end numeric: The number of the last row to shift. If omitted the function shifts a single row.
• offset numeric default=1: The positive (down) or negative (up) number of rows to shift by. If omitted the function shifts the row down by one.

##Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.shiftRows( workbook,1,1,1 );