Hi,
We observed problem with hanging indefinitely Infragistics control due our used large variable range in Named Manager: =Events!$B$2:$B$1048576
This number can be really high so we using large number to be on safe side. Now attaching this named range to the validation list in another sheet causing to hang on opening even that list is empty.
Sample: Please try to load attached below Excel spreadsheet into XamSpreadSheet control then switch to Links worksheet then select A2 row and simply click on dropdown to see available list of Events.
Hanging_tests.xlsx
Same behavior does not cause this behavior in opened Excel thus problem related to Infragistics. Hanging stack trace:
Similar topic: https://es.infragistics.com/community/forums/f/ultimate-ui-for-wpf/123694/column-filter-performance-problems-in-xamspreadsheet-control
After retesting my sample using Infragistics version 22.1.40 the problem gone. Obviously there was a fix applied between version 20.1.9 and 22.1.40 which solved the problem.
I haven't got any feedback on this topic. I am attaching simple application with already attached Excel file sample:
Hanging_sample.zip