Validation error pops up on each row of Excel (Edit in Excel)
Validation error pops up on each row of excel (while using Edit in Excel). When excel is used to load the data table, the validation errors pop up for each row individually rather than validating all the rows and throwing a final pop-up with error messages. Closing pop-up on each row validation is an overhead for the user.
Steps to Reproduce
1. Create a repeat grid in a section.
2. Configure an icon which launches an Excel where the data can be edited.
3. When rows are edited, there is a pop up window which appears for the validation of every row.
The root cause of the issue is that the macros configured for the excel throw a separate error for each column.
The issue is not a bug, however, it is causing overhead for the user by showing a separate error pop up for each row. An enhancement request (FDBK-12070) is raised to address this issue.
0% found this useful