Script Access to “Paste Multiple Rows from Clipboard”

danjransom@gmail.com — Tue, 09 Feb 2010 14:49:12 GMT

Is there any way to access the “Paste Multiple Rows from Clipboard” feature from javascript outside of the row context menu? We want users to be able to paste multiple rows at a single time into an empty grid. However, if the grid is empty and there are no rows, there is no way to access the “Paste Multiple Rows from Clipboard” command.

Is there a way to perform this function from a button outside the grid? Alternatively, is there a way to show the row context menu even when there are no rows?

Multiple Row Paste Validation

danjransom@gmail.com — Thu, 28 Jan 2010 23:00:50 GMT

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?

Intersoft Community - paste

Script Access to “Paste Multiple Rows from Clipboard”

Multiple Row Paste Validation