If you want to append rows dusing a paste, you will have to handle this your self.
One way is to subscribe to the PasteCellText and add the row there is needed.
//subscribe to the event
this.gridDataBoundGrid1.Model.PasteCellText += new GridPasteCellTextEventHandler(Model_PasteCellText);
//the handler
private void Model_PasteCellText(object sender, GridPasteCellTextEventArgs e)
{
if(e.ColIndex > this.gridDataBoundGrid1.Model.ColCount)
e.Cancel = true;
else if(e.RowIndex == this.gridDataBoundGrid1.Model.RowCount)
{
CurrencyManager cm = this.gridDataBoundGrid1.BindingContext[this.gridDataBoundGrid1.DataSource,
this.gridDataBoundGrid1.DataMember] as CurrencyManager;
cm.AddNew();
}
else if(e.RowIndex >= this.gridDataBoundGrid1.Model.RowCount)
e.Cancel = true;
}