By changing the value in data validation list, formula is not getting triggered

By changing the value in data validation list, formula is not getting triggered

Posted by: aditya.chauhan on 21 March 2023, 4:11 am EST

• 

  aditya.chauhan

  • Post Options:
  • Link
    Copy

  Posted 21 March 2023, 4:11 am EST - Updated 21 March 2023, 5:56 am EST

  Upon changing the value in data validation list, formula is not getting triggered upon changing the value in list

  It is working as expected in excel

  Demo videos attached too for the same in excel and SpreadJs and the file
  
  Demo in Excel and SpreadJS.zip

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 22 March 2023, 2:46 am EST

  Hello,

  We tried to replicate the issue on our end but we were not able to do so. We have attached a sample in which a data validator is used to validate the value on a cell. Other cells reference the cell on which the data validator is applied. Whenever the value in the data validator cell is changed, other cells also get changed.

  Please provide us a json or a sample which replicates the issue. You may modify the sample we have attached as well by forking another sample.

  Sample: https://jscodemine.grapecity.com/share/2hrf4tDN00KTZ1LEOdUiTQ/?defaultOpen={“OpenedFileName”:[“/index.html”,“/src/app.js”],“ActiveFile”:“/src/app.js”}

  Regards,
  
  Avinash