Custom 'Invalid Formula' modal in SpreadJS Designer

Custom 'Invalid Formula' modal in SpreadJS Designer

Posted by: lpagliaro on 8 January 2021, 12:34 am EST

• 

  lpagliaro

  • Post Options:
  • Link
    Copy

  Posted 8 January 2021, 12:34 am EST - Updated 3 October 2022, 1:01 am EST

  Hello! In SpreadJS Designer, is it possible to modify or create a custom ‘Invalid Formula’ modal?

  

  Thanks!

  Regards.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 11 January 2021, 6:20 pm EST

  Hi Luis,

  If you are using the Designer v13 or any earlier version the you may override the MessageBox.show method for the required functionality. Please refer to the following code snippet.

  
  let old = GC.Spread.Sheets.Designer.MessageBox.show;
    GC.Spread.Sheets.Designer.MessageBox.show = function (
      text,
      title,
      icon,
      buttons,
      callback
    ) {
      if (text === "Invalid Formula") {
        designer.MessageBox.show(
          "This is Custom Modal ",
          "Custom Title",
          2 /* warning */,
          0 /* ok */,
          function () {
            $(".fill-content").focus();
          }
        );
      } else {
        old.apply(this, arguments);
      }
    };
  });
  
  

  Further for Designer v14, we are unable to achieve the required functionality hence we forwarded this issue to the concerned team for further investigation. We will update you regarding this as soon as we get any information. The internal ID for this issue will be SJS-7204.

  Regards
  
  Avinash

• 

  lpagliaro

  • Post Options:
  • Link
    Copy

  Posted 12 January 2021, 7:01 am EST

  Sounds good. Thank you!