Date column is getting set to current date on pasting string

[DebadityaParticipant]

Hi ,
I have a grid with columns in date format . User can copy paste & inline edit in the grid. When the user accidentally pastes a string instead of date in a date column, the value gets reset to current date. How to stop this behaviour or show some sort of error message ?I have included the link to one of your demos
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/dataexport.htm

If you accidentally copy paste first or last name to ship Date , instead of throwing an error it defaults to current date .How to stop this behaviour & show error message ?

[MartinParticipant]

Hello Debaditya,

There is no way to add validation for copy/paste between cells.
You can either stop the whole functionality by setting the clipboard property to “false”,
or you can use the cellvaluechanged event to check the old and new values and return the old one, if needed.

Best Regards,
Martin

jQWidgets Team
http://www.jqwidgets.com/

[DebadityaParticipant]

1. Cellvalue changing does not get triggered on copy paste
2.what if the user is pasting multiple rows together, for one column data mismatch… I will cancel the entire paste event?

[MartinParticipant]

Hello Debaditya,

When pasting values the cellvaluechanged is triggered.
And if you paste multiple cells it is triggered for every cell, so you know each cell’s old and new value.
Here is an Example.

Best Regards,
Martin

jQWidgets Team
http://www.jqwidgets.com/

[DebadityaParticipant]

Which version of JQXGrid are you using in the given example ?

[MartinParticipant]

Hello Debaditya,

The example is using the latest version of jQWidgets- 6.0.6.

Best Regards,
Martin

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts