SfCellGrid does not fire CommitCellInfo when pasting multiple cells

Thread ID:	Created:	Updated:	Platform:	Replies:
142029	Jan 15,2019 10:37 PM UTC	Jan 16,2019 09:19 AM UTC	UWP	1

Subscribe to this post

Tags: SfCellGrid

John Dye

Asked On January 15, 2019 10:37 PM UTC

Steps to reproduce:

1) Hook SfCellGrid's
CommitCellInfo & QueryCellInfo:
CellGrid.Model.CommitCellInfo += RowList_CommitCellInfo;

CellGrid.Model.QueryCellInfo += RowList_QueryCellInfo;

2) Enter some dummy data into the grid

3) Copy this data selecting more than 1 cell

4) Paste these cells into another part of the grid

5) Notice RowList_CommitCellInfo info is not fired, my data source cant be updated with the pasted values.

Reply | Reply with quote

Jayaleshwari N [Syncfusion]

Replied On January 16, 2019 09:19 AM UTC

Hi John Dye,

Thanks for contacting Syncfusion Products.

We have checked the reported query “SfCellGrid does not fire CommitCellInfo when pasting multiple cells” from our side. You can achieve the requirement of updating the pasted values in data source by invoking ClipboardCopy and ClipboardPaste Events of SfCellGrid.

grid.Model.ClipboardCopy += Model_ClipboardCopy;

grid.Model.ClipboardPaste += Model_ClipboardPaste;

private void Model_ClipboardCopy(object sender, GridCutPasteEventArgs e)

{

copiedRange = e.Range;

}

private void Model_ClipboardPaste(object sender, GridCutPasteEventArgs e)

{

//Updating the copied values in the list.

List<string> values = new List<string>();

for(int i = copiedRange.Top; i <= copiedRange.Bottom; i++)

{

for (int j = copiedRange.Left; j <= copiedRange.Right; j++)

values.Add(grid.Model[i, j].CellValue.ToString());

}

You can refer the following user guide documentation to know more about the copy and paste operations.

https://help.syncfusion.com/uwp/sfcellgrid/interactive-features#event-related-with-paste-operation

https://help.syncfusion.com/uwp/sfcellgrid/interactive-features#event-related-with-copy-operation

Note: CommitCellInfo Event of SfCellGrid will not be invoked for Clipboard operations.

Please let me know if you would require further assistance.

Regards

Jayaleshwari N.

Reply | Reply with quote

CONTACT US

SfCellGrid does not fire CommitCellInfo when pasting multiple cells

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US