Hello,
I'm using a XamDataGrid and the Copy/paste function.
When I paste on cell a value which is exactly the same than the current one, then my binded property is not updated.
Does it possible to have my property update after the paste even if the value has not changed ?
In my grid some field on different cell could have a specific behavior so I want my binded property is alert even if value is the same.
My version is : 16.2.20162.2237
Thanks by advance.
Hello Frederic,
I am under the impression in this case that you are referring to the XamDataGrid in the Infragistics for WPF product and not our UWP product. If this is the case, I will move the forum thread. If this is not the case, please let me know as the following is based on this impression.
Currently, the XamDataGrid will not change its underlying bound property if you paste the same value in the cell because put simply, the value is not actually changing. My best recommendation for you on this would be to utilize the ExecutedCommand event of the grid and catch the paste event. You could do that using the following event handler:
private void XamDataGrid_ExecutedCommand(object sender, Infragistics.Windows.Controls.Events.ExecutedCommandEventArgs e) { if(e.Command != null && e.Command.Name == "Paste") { //do something } }
In place of the “//do something” above, you could utilize the ActiveCell of the XamDataGrid to find the cell that you pasted into. The resulting Cell can get you the Record it is part of and the Field and should allow you to update your data item.
Please let me know if you have any other questions or concerns on this matter.
Hello Andrew,
I made this kind of solution to get all pasted Records and treat each pasted even if during paste the cell has not changed.
Do you think exist something more elegant ? Any tips to get all pasted record may be ?
private void DataGrid_OnExecutedCommand(object sender, ExecutedCommandEventArgs e) { if (e.Command != null && e.Command.Name == "Paste") { if (sender is XamDataGrid dataGrid) { var selectedItems = dataGrid.SelectedItems; foreach (var item in selectedItems.OfType<Cell>()) { var dataItem = item.Record.DataItem; if (dataItem is MyDataModel dataModel) { // the item has been pasted // toTreat.Add(dataModel) ..... } } } } }
I have been investigating into a better way to get all of the cells in this case, but unfortunately there does not appear to be a “catch-all” solution in this case. For example, if you have multiple selection enabled and you copy three vertical cells, but then only select one to paste, it will still paste the three vertical values with the first being in the selected cells in the other two in the two cells below it, respectively.
One thing I had missed with my previous update is that there is a ClipboardPasting event that you may be able to use to avoid the e.Command checks, and this event gives you the number of Fields and Records that will be pasted to. It appears that if you loop through the RecordCount and FieldCount, you can get all of the target cells by using the GetTargetCell method of the event arguments and index the Values collection of the event arguments by the cell, like so:
private void XamDataGrid_ClipboardPasting(object sender, Infragistics.Windows.DataPresenter.Events.ClipboardPastingEventArgs e) { for(int i=0; i<e.RecordCount; i++) { for(int j=0; j<e.FieldCount; j++) { var cell = e.GetTargetCell(i, j); var value = e.Values[cell]; } } }
This allows you to get the Cell to be pasted to and the value to be pasted, which would allow you to determine whether or not the Cell.Value is actually different.
I hope this helps. Please let me know if you have any other questions or concerns on this matter.