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 copying data validations, EPPlus iterates all data validation items in the worksheet to see if the address matches the copied range this has devestating effects on performance when a high amount of dataValidations are present.
Workaround: Exclude dataValidations when copying cell by cell then add the addresses to the dataValidation ranges manually.
Use of quadtree could be a helpful starting point.
The text was updated successfully, but these errors were encountered:
When copying data validations, EPPlus iterates all data validation items in the worksheet to see if the address matches the copied range this has devestating effects on performance when a high amount of dataValidations are present.
Workaround: Exclude dataValidations when copying cell by cell then add the addresses to the dataValidation ranges manually.
Use of quadtree could be a helpful starting point.
The text was updated successfully, but these errors were encountered: