Block users from adding new rows by copy and pasting data.

[altyra]

I am  having  a problem, is there anyway to block the user from adding new rows if they copy and paste a number of rows greater then a i already have in the table itself. For example if i have 8 rows and the user adds 12 from an external excel i want to still only have 8 rows.

Thank you for time

[paramvir]

beforeValidate event can be used to do any customization of pasted data.

https://paramquery.com/pro/api#event-beforeValidate

In your case you can remove the extra rows from ui.addList or ui.updateList by using normal js array manipulation methods.