Spreadsheet - Insert Rows on data loss validation

[Brian]

Hi,

I was trying to insert rows when my one of my columns in the spreadsheet has values in all rows. Are we able to detect the function or event before the data loss validation?

What i want to achieve is that before this validation is trigger, i will delete off some of the rows automatically in the spreadsheet itself.

I tried the insertRow event, but this validation check will take place before that was executed. Thanks in advance.

Regards,

Brian

[Martin]

Hello, could you please share what steps I need to make to observe the issue you are experiencing? If you could provide a small dojo example and a xlsx file for testing, I would be very grateful.