Gracpecity Spread formula is not working

Posted by: johina.olla on 4 March 2022, 12:55 am EST

  • Posted 4 March 2022, 12:55 am EST - Updated 30 September 2022, 11:39 am EST

    We are using both windows and web spread version in our application. We are using a formula in sheet, in case of desktop the spread formula is working properly but in case of web application is it not working as shown in attached image (desktop.jpg and web.jpg). Please suggest if there is any other way to evaluate the formula for spread for web version.

  • Posted 4 March 2022, 6:58 am EST

    Hi,

    From the screenshot, It seems like you are using the GCExcel product. Could you please share the detail of the product and the version that you are using so that we could have a better understanding? Also, it would be helpful if you provide a small working sample that replicates this so that we could investigate it further and assist you accordingly,

    Regards,

    Avinash

  • Posted 4 March 2022, 7:30 am EST - Updated 30 September 2022, 11:39 am EST

    We Could not provide the sample but i have shared the code that we are using for desktop and web version. Please the find product version in the attached image.

  • Posted 7 March 2022, 10:31 am EST

    Hi,

    Please find the attached sample that shows the XLSX file in Spread JS processed using the GcExcel.

    Here formula is present in one column and for one column it is set from the code.

    Please modify the sample depicting your issue if the issue persists.

    Regards,

    Manish Gupta

    IfErrorFormula_fromCode.zip

Need extra support?

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

Learn More

Forum Channels