Improve cell style matching time when cloning a sheet

XMLWordPrintable

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

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

              Created:
              Updated: