Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1255

Improve the filter performance by not rendering hidden rows

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Normal 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.

            Unassigned Unassigned
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: