Formula change event

Formula change event

Posted by: udayab on 8 September 2017, 9:47 am EST

• 

  udayab

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:47 am EST

  when i chenged the value of any cell in spreadjs the n dependent cells values will change on one chane.i can get the single cell value changed by value changed value event,how i can i get the all the dependent chaged cells value in this case?i want to get the all the cells whose value changed according to formula?? to save in to the data base??please replay for this issue.

  for example
  
  i will change the cell (0,0) value to 10,in this case the value change event will be triggered and i can get the chaged value as well as row c and Column.
  
  now in this case for cell (0,1) and cell (0,2) i have the formula like A1+10 means both the cell value will change acrding to formula since that is dependent on the A1.in my case i want to get the (0,1) an d(0,2) cells value and reference?
  
  is there any event to tackle this through event?

  please have a suggetion for me…

• 

  manpreetkaur

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:47 am EST

  Hello,

  As discussed in the following forum link, the issue has already been escalated to the development team.

  Unfortunately, I do not have any update regarding this issue currently. I have requested the concerned team for an update. I would let you know as soon as I get any information in this regard.

  Thanks,
  
  Manpreet Kaur

• 

  aakriti1711

  • Post Options:
  • Link
    Copy

  Posted 13 October 2017, 1:48 am EST

  HI,

  Is there any Formula change event ?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 13 October 2017, 11:41 am EST

  Hello,

  There is a UserFormulaEntered event which fires whenever a user changes the Formula by editing the cell.

  http://help.grapecity.com/spread/SpreadSheets10/JavascriptLibrary~GC.Spread.Sheets.Events~UserFormulaEntered_EV.html

  Thanks,
  
  Deepak Sharma