Custom 'Invalid Formula' modal in SpreadJS Designer

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

  • Posted 8 January 2021, 12:34 am EST

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



    Thanks!

    Regards.
  • Replied 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
  • Replied 12 January 2021, 7:01 am EST

    Sounds good. Thank you!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels