-
Type:
New Feature
-
Resolution: Unresolved
-
Priority:
Normal
-
None
-
Affects Version/s: 3.8.3
-
Component/s: 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.
