Multiple Row Paste Validation

11 replies. Last post: February 4, 2010 9:23 PM by Andi Santoso
Tags :
  • New Discussion
  • New Question
  • New Product Feedback
Dan RansomMember

The "Paste Multiple Rows from Clipboard" feature sounds great in theory, but in practice we are finding it impossible to implement in a real-world scenario. As far as we can tell, there is no way to highlight bad data inserted into the grid when using this feature.

For example: we have a grid with a mix of numeric, date, text, and valuelist (dropdown) columns. Some of the fields are set to require input. When users enter data in the new row at the top of the grid all of the cells are validated ensuring good values. However, using the "Paste Multiple Rows from Clipboard" feature, users can put in values that are in no way valid, i.e. text in a date field, dates in a numeric field, value list items that are not in the list, and even NULL values in a required field.

Despite the extremely limited amount of documentation on this feature, we have been able to apply some of our own validation using the OnAddPendingChanges client event. However, even though we can blank out celss or apply default values to the added fields, we can find no way to highlight these bad cells to inform the user of the invalid data.

It would be great if we could just run row.Vaidate() or row.GetElement() but we can't access the rows inserted by the multiple row paste feature using GetRow(#) or any other meathod.

How can we highlight (with color) specific inserted cells to denote bad pasted values?

All times are GMT -5. The time now is 11:05 AM.
Previous Next