-
New Feature
-
Resolution: Unresolved
-
Normal
-
None
-
3.8.3
-
None
-
Security Level: Jimmy
Because filtering just hides those filtered rows instead of removing them, all rows' DOM elements in the filtering range are created when applying a filter. Iif there are 5000 rows, in normal case zss only renders part of them (the visible range). After applying a filter, if the 5000 th row matches the criteria. Spreadsheet still needs to render all 5000 rows and hide those filtered ones. This will force a browser to load all elements including invisible ones and make it very slow.
A potential solution could be:
- do not render hidden rows
- render the hidden rows only when users unhide them by dragging row height.