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

Improve cell style matching time when cloning a sheet

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • 3.9.1
    • None
    • Security Level: Jimmy
    • Sprint 8

      steps to reproduce

      1. run the attached junit test case

      current result

      it spends about 15 ~25 s to clone a sheet from 1324-long.xlsx.

      expected result

      clone a sheet can take a shorter time.

      debug info

      • 1324-long.xlsx has 30% more cells than 1324-short.xlsx, but it spends much more time on cloning a sheet. Since matching style consumes lots of time:

        1. 1324-long.xlsx
          151 kB
        2. 1324-short.xlsx
          88 kB
        3. CloneBookTest.java
          2 kB
        4. empty.xlsx
          8 kB
        5. match.png
          match.png
          67 kB

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

              Created:
              Updated: