You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When the Formulas plugin is enabled the validator function (and validation hooks) are triggered twice for the changed values. No matter if it was triggered from API or UI. Additionally, I've found that validation is not triggered when the Formulas plugin works in linked workbook mode. Changing the value in the first instance does not update the validity state in the second instance.
The validator in both sheets is customized and always returns false (all changed and related cells should be marked as red). The first sheet works but its validator function is called twice and the second sheet is not updated at all - in context of the validity state.
The commit fixes an issue where the validator function is called twice on cell
value change. Moreover, the PR fixes a bug where the validity states of the
linked workbooks are not updated and fixes an issue where the wrong cells are
validated when some index transformation on the table was applied.
Issue: #8138
Description
When the Formulas plugin is enabled the
validator
function (and validation hooks) are triggered twice for the changed values. No matter if it was triggered from API or UI. Additionally, I've found that validation is not triggered when the Formulas plugin works in linked workbook mode. Changing the value in the first instance does not update the validity state in the second instance.Steps to reproduce
10
;false
(all changed and related cells should be marked as red). The first sheet works but its validator function is called twice and the second sheet is not updated at all - in context of the validity state.Demo
https://jsfiddle.net/budnix/tq1jck3v/
Your environment
The text was updated successfully, but these errors were encountered: