Can I get old values before trigger event Rangechanged

Can I get old values before trigger event Rangechanged

Posted by: cangod05 on 27 August 2022, 10:33 pm EST

• 

  cangod05

  • Post Options:
  • Link
    Copy

  Posted 27 August 2022, 10:33 pm EST

  Hi I have a problems with SpreadJS that I can get old values in rangechanged event. Do you have any sollutions or events can trigger before rangechanged.
  
  Thanks Sir.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 29 August 2022, 7:34 am EST

  Hi,

  We are sorry but we can not get the old values inside the Range change event. Actually, range change fire for multiple actions, and for those actions has their own events as well. You can get the old from specific auction events.

  For example inside the ClipboardPasting, we can get the old value of the cell for paste. Further, Please refer to the list of actions for which range changed event gets fire(we get in eventargs enum RangeChnagedAction) and their specific event which is called just before the action gets performed.

  some of them are mentioned below:

  dragDrop =============> DragDropBlock
  
  dragFill =============> DragFillBlock
  
  evaluateFormula =============> do not have any specific event
  
  paste =============> ClipboardPasting
  
  setArrayFormula =============> do not have any specific event
  
  sort =============> RangeSorting

  Regards,
  
  Avinash