We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to paste the data by custom column order instead of the first column in the SfDataGrid when SelectionUnit is a Row?

Platform: WPF |
Control: SfDataGrid |
.NET Framework: 4.5

When SelectionUnit is a Row, the data can be pasted only from the first column, by default. Now, you can paste the copied data anywhere in the Grid by deriving a new class from GridCutCopyPaste and overriding the PasteToRow virtual method.



public class CustomCopyPaste : GridCutCopyPaste
        public CustomCopyPaste(SfDataGrid sfgrid)
            : base(sfgrid)
        protected override void PasteToRow(object clipboardcontent, object selectedRecords)
            //Splits the row into number of cells by using \t.
            clipboardcontent = Regex.Split(clipboardcontent.ToString(), @"\t");
            var copyValue = (string[])clipboardcontent;
            //For Row selection
            if (dataGrid.SelectionUnit == GridSelectionUnit.Row)
                int columnindex = 0;
                //Gets the currentcell column index.
                var index = this.dataGrid.SelectionController.CurrentCellManager.CurrentCell.ColumnIndex;
                foreach (var column in dataGrid.Columns)
                    if (index >= dataGrid.Columns.Count)
                    if (copyValue.Count() <= this.dataGrid.Columns.IndexOf(column))
                    // Calls the PasteToCell method and passes the copied data and pastes the column index.
                    PasteToCell(selectedRecords, this.dataGrid.Columns[index], copyValue[columnindex]);


You can customize the GridCutCopyPaste class and assign its instance to the SfDataGird.GridCopyPasteproperty as described in the following code.


this.sfdatagrid.GridCopyPaste = new CustomCopyPaste(sfdatagrid);


Sample Links:




2X faster development

The ultimate WPF UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile