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

Improve cell style matching time when cloning a sheet

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 3.9.1
    • Fix Version/s: None
    • Component/s: None
    • Security Level: Jimmy
    • Labels:
    • gh.sprint.customfield.default.name:
      Sprint 8

      Description

      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:

        Attachments

        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

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: