1. Home
  2. Forum
  3. WPF
  4. Validation and revert data when cell in Edit mode and pasting data from clipboard.

Validation and revert data when cell in Edit mode and pasting data from clipboard.

Hi team,

I am using SfDataGrid to capture and display data. I am making using of different column types for my columns example GridCurrencyColumn, GridNumericColumn etc.
When using GridCurrencyColumn I would like to know how can I prevent user from pasting Alphabets or invalid characters into the textbox when the cell is in EditMode.

The cell/column prevents me from entering any alphabets from key board  but when I do a Ctrl+V i.e. paste in the cell when in edit mode the value defaults to zero and I loose the original value that was already captured.

Is there a way to restrict this from happening and retain previously entered value when any invalid data is being pasted in edit mode of currency column.

Let me know if you need any additional information.


Thanks,
Srikanth V

6 Replies
VS Vijayarasan Sivanandham Syncfusion Team February 13, 2020 01:49 PM UTC

Hi Srikanth Vattipally, 
 
Thank you for contacting Syncfusion Support. 
 
We have checked your reported issue in our source. We are loaded the SfCurrencyTextbox as edit element in GridCurrencyColumn.So, we have reported this issue with SfCurrencyTextbox team. We will provide the complete details on February 17, 2020.  
  
We appreciate your patience until then. 
 
 Regards, 
Vijayarasan 


FP Farjana Parveen Ayubb Syncfusion Team February 18, 2020 03:48 AM UTC

Hi Srikanth, 
 
As we updated earlier, we are able to reproduce your reported issue and we are considered this as a bug. Could you please share your Syncfusion version so that we will provide a patch for that version? 
 
Regards, 
Farjana Parveen A 


SV Srikanth Vattipally February 18, 2020 09:38 AM UTC

Hi Farjana,

Thank you for the updates. We are currently using NuGet version 17.3.0.19.



Thanks,
Srikanth V.


SS Susmitha Sundar Syncfusion Team February 19, 2020 01:25 PM UTC

Hi Srikanth, 
 
Thank you for your update. 
 
We have created bug report for the reported issue. We will fix this issue and include in our 25th February 2020 NuGet release.  
   
We appreciate your patience until then.  
 
You can track the status of this report through the following feedback link,   
 
 
 
Note: The provided feedback link is private, and you need to login to view this feedback.   
 
Regards, 
Susmitha S 


SS Susmitha Sundar Syncfusion Team February 25, 2020 01:24 PM UTC

Hi Srikanth,  
  
Sorry for the inconvenience caused.  
  
We did not include your reported issue in our weekly NuGet release.  We will include this fix in our 3rd March 2020 weekly NuGet without fail. 
 
We appreciate your patience until then. 
 
Regards, 
Susmitha S 


SS Susmitha Sundar Syncfusion Team March 3, 2020 11:07 AM UTC

Hi Srikanth, 
  
We have fixed the mentioned issue “Value reset to zero when pasting non-numeric text in CurrencyTextBox” and included the issue fix in our weekly NuGet update version 17.4.0.53 which is available for download (nuget.org).  
  
We thank you for your support and appreciate your patience in waiting for this update. Please get in touch with us if you would require any further assistance. 
  
Regards, 
Susmitha S 


Loader.
Up arrow icon