Delete all rangeChanged data length is too large

Delete all rangeChanged data length is too large

Posted by: 122368177 on 2 June 2020, 5:41 am EST

• 

  122368177

  • Post Options:
  • Link
    Copy

  Posted 2 June 2020, 5:41 am EST

  I deleted all the cell and I undo the operation,
  
  It emited the rangeChanged event,
  
  but I got the changedCells’s length is too large.
  
  I need to get the deleted cell values and distinguish rangeChanged action is undo or do~~
  
  Thanks

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 3 June 2020, 9:56 am EST

  Hi,

  but I got the changedCells’s length is too large.
  
  changedCells array contains a list of all the cells which are affected by the range operation. So if a large no. of cells were affects then the value of changedCells.length would also be large.

  I need to get the deleted cell values and distinguish rangeChanged action is undo or do
  
  We are sorry but currently, we do SJS does not support isUndo flag for RangeChanged event and hence we have created an enhancement request(SJS-4495) on your behalf to support this feature. We will let you know about any updates regarding the same.
  
  Till then you may override the undo command to add support for isUndo flag at your end. Please refer to the following sample which demonstrates the same:
  
  https://codesandbox.io/s/nice-banzai-sjm1j?file=/src/index.js

  Regards
  
  Sharad

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 July 2020, 3:58 am EST

  Hi,

  isUndo property for RangeChanged event is now added in our latest build v13.2.0. Please update to the latest build and let us know if you face any issues.
  
  You may download the latest version using the following link: http://cdn.grapecity.com/spreadjs/13.2.0/Files/SpreadJS.Release.13.2.0.zip

  Regards

• 

  122368177

  • Post Options:
  • Link
    Copy

  Posted 30 July 2020, 2:29 am EST

  Thanks~