Application crash when Formula is set to =TODAY()

Posted by: Jose.Aguirre on 18 October 2022, 8:19 pm EST

  • Posted 18 October 2022, 8:19 pm EST - Updated 18 October 2022, 8:33 pm EST


    when trying to set the formula =TODAY() to cell, it causes the application to crash. No exception nor another message to check what failed.

    Used version: 15.2.20223.0

                Cell cell = c.ActiveSheet.ActiveCell;
                //cell.Formula = "=SUM(A1:B1)";
                cell.Formula = "=TODAY()";

    It also crashes in the Spread WPF Explorer. Please fix.

  • Posted 18 October 2022, 11:04 pm EST

    Hi Jose,

    Thanks for informing this behavior.

    We have replicate this issue at our end and we have escalated it to the development team. Will get back to you once we have any update from them.[Internal Tracking Id - SPNET-27489]

    Best Regards,


  • Posted 9 January 2023, 3:39 am EST

    Hello, is this bug already fixed?

  • Posted 10 January 2023, 12:25 am EST


    Apologize for the inconvenience.

    As per the development team, This is a bug of the calculation engine. There’s an infinite loop in “Volatile” functions. It’s a known issue and not all volatile functions will be re-calculated when a cell value has changed.

    The original problem (application hangs) can be fixed in v16.1. The formula value update issue shadowed by the original problem is a limitation.

    So, you need to wait till v16.1 release.

    Best Regards,


  • Posted 10 April 2023, 11:32 pm EST

    Hello, where can I check your current version?

  • Posted 11 April 2023, 3:30 pm EST - Updated 11 April 2023, 3:35 pm EST

    Hi Jose,

    You can check with the latest installer. Select the latest version from the left-top dropdown. And then you can check the latest version specific to the technology i.e., Winforms, Asp.Net and WPF.

    You can download the latest installer from here:

    Best Regards,


Need extra support?

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

Learn More

Forum Channels