Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-721

improve the performance of pasting hundreds of cells

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Major Major
    • 6.0.0
    • None
    • None
    • Security Level: Jimmy

      Steps to reproduce

      1. import https://docs.google.com/spreadsheets/d/1qkbOKoOoFVA22YQxB-8RgjopDPkyGOl2/edit?usp=share_link&ouid=114351817352708928223&rtpof=true&sd=true
      2. copy 45 row * 7 columns cells from input.xlsx
      3. paste them to uren!M5:S50

      Current Result

      the au request having onClipboardPaste takes around 30s

      Expected result

      1s~2s

      Debug Info

      • if solving KEIKAI-679, it will speed up this operation

      Workaround

      CellEditTextAction.java
      since it calls setCellEditText() many times, optimize them:

      r.setAutoRefresh(false);
      ...
      Ranges.range(_sheet, _row, _column, _lastRow, _lastColumn).notifyChange();
      

            rebeccalai rebeccalai
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: