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

improve rendering speed when scrolling a sheet with a filter enabled

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 3.9.0
    • None
    • Security Level: Jimmy

      steps to reproduce

      1. load the attached Excel file
      2. scroll down (or right) 15 rows for each time
      3. scroll several times and observe the row rendering behavior

      result

      There is an obvious blank content appearing after a scroll for 3 seconds.

      expect result

      Showing the blank content as short as possible

      workaround

      • preloadRowSize="2000"

      debug info

      • setAutoFilter() takes too much times during scrolling. see rendering-filter.cpuprofile
      • ignoreAutoHeight="true" doesn't help on this case

      steps to reproduce - long scrolling

      1. load the attached Excel file
      2. scroll down for over 100 row for each time

      result

      The time to show the blank content becomes even longer. ZSS takes more time on js setAutoFilter(). Please see longScrolling.cpuprofile

        1. sumproduct.xlsx
          326 kB
        2. rendering-filter.cpuprofile
          1.61 MB
        3. blank.png
          blank.png
          45 kB
        4. longScrolling.cpuprofile
          4.48 MB
        5. scrolling1.png
          scrolling1.png
          28 kB
        6. scrolling2.png
          scrolling2.png
          33 kB

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

              Created:
              Updated: