SpreadJS 11.2.1+ throws away invalid formulas

SpreadJS 11.2.1+ throws away invalid formulas

Posted by: jb9244 on 16 October 2018, 10:48 am EST

• 

  jb9244

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 October 2018, 10:48 am EST

  SpreadJS 11.2.1 - 11.2.6

  Typing a formula where a function’s arguments are not satisfied causes the update to the cell to be thrown out. Example:

  =DATE()
  
  =DATE(2018, 10, 16, 1)

  • Entering the formulas above in an empty cell and hitting enter prior to 11.2.1 resulted in #VALUE!, or the additional arguments were ignored, but now results in an empty cell with no formula, so a typo results in having to re-enter the entire formula.

  Editing an existing formula and having the wrong number of arguments for a function will cause your change to be quietly discarded, so a value may still be there, possibly causing you to not notice that your updated formula wasn’t saved.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 17 October 2018, 11:14 am EST

  Hello,

  We are able to replicate this issue, it looks like a design behavior. I have asked the dev team to further look into this. I will let you know as soon as I get an update on this.
  
  The tracking id for this issue is 265905.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 22 October 2018, 5:43 am EST

  Hello,

  This issue has been identified as the design behavior.
  
  This change has been introduced knowingly matching the behavior of Excel. You can further handle ‘invalidOperation’ event and show the message as per your requirement.
  
  This event fires for the incorrect formula input.

  Thanks,
  
  Deepak sharma