Gracpecity Spread formula is not working

Gracpecity Spread formula is not working

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

• 

  johina.olla

  • Post Options:
  • Link
    Copy

  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.

  

  1914×774 157 KB

  

  1914×774 183 KB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  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

• 

  johina.olla

  • Post Options:
  • Link
    Copy

  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.
  
  

  

  948×879 51.5 KB

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  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