RangeChanged causes performance issue

RangeChanged causes performance issue

Posted by: ngocnguyen09910060 on 10 July 2022, 12:56 pm EST

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 July 2022, 12:56 pm EST

  Hi teams,

  On my web application, i have 2 cells. When end user move mouse cursor to bottom-right corner of cell 1 , SpreadJS will display black plus. End user can hold and move to cell 2 to execute fill handle.
  
  I’m using “RangeChanged” to handle data of the above case. I get current string of cell 2 (that has just copied from cell 1) and validate:

  • “If current string is valid => OK.”

  • “If current string is invalid => setValue of cell 2 to blank.”

  When i using setValue, it take about 3-4 seconds to reset current string to blank.
  
  I think setValue make “RangeChanged” loop a few times.
  
  Please help me resolve this issue.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2022, 5:04 am EST

  Hi,

  We are sorry but we are unable to replicate the issue at our end, could you please check the following sample and update it to reflect your issue:
  
  https://jscodemine.grapecity.com/share/PiZYNCYipU_E3sU2x4DCtg/
  
  You may also share a sample of your own.

  Also, please make sure to enclose the updates call within suspendPaint()/resumePaint() call to improve performance.

  Regards
  
  Sharad

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy

  Posted 12 July 2022, 6:35 am EST

  Hi sharad.tomer,

  I have implemented your suggestion and it works well.

  Thank you very much.