Formula are not working always show 0

Formula are not working always show 0

Posted by: chander.pal on 31 January 2024, 6:50 am EST

• 

  chander.pal

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 January 2024, 6:50 am EST - Updated 1 February 2024, 1:19 am EST

  Hi,
  
  I tried to export excel from spreadjs 16.02 after that for this specific sheet the formulas are not working. other templates(documents) are working fine. I tried same on desktop with spread .net there it is working fine only in spreadjs it is not working properly.

  I exported the web excel now i add formula (=SUM(13,4)) on H3 it is showing 0 . I attached both the sheets of both web(spreadjs) and desktop(farpoint spread .net).

  I also tried this on L4 and on web formula is not working. so i tried to export the excel document and found that there are no formulas on sheet.

  Can you please help what can be the root cause? Need help asapexcel (2).zip

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2024, 3:05 am EST - Updated 1 February 2024, 3:10 am EST

  Hi,

  Thank you for sharing the xlsx files and images with us.

  After investigating the issue, we found that the issue occurs because the xlsx file “Web exported excel.xlsx” contains a table, and cell H4 is the table header cell(web_excel_table.png). It is important to note that the table header cell values can only be static values. It can not be a formula that is dynamic in nature. That is why the formula result is not applied. So, the mentioned behavior is expected.

  However, in the xlsx file “desktop exported excel.xlsx”, there is no table, and cell H4 is not a table header cell. That is why the formula result is applied properly and there are no issues.

  Additionally, if you want to remove the table and keep its content on the sheet in SpreadJS, you can use the remove() method of the TableManager class. Please refer to https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Tables.TableManager#remove for more information.

  Also, we set the formula “=SUM(13, 4)” in cell L4 in the “Web exported excel.xlsx” file in SpreadJS, exported it to xlsx file, and opened the exported xlsx file in MS Excel. The formula was working correctly in SpreadJS and MS Excel without any issues. Please refer to the attached GIF.

  We hope the above explanation resolves your issue. If you still face the issue, kindly let us know and explain the issue in more detail that you are facing.

  

  1916×1043 93.8 KB

  

  Regards

• 

  chander.pal

  • Post Options:
  • Link
    Copy

  Posted 2 February 2024, 6:22 am EST

  Yes , the explanation resolves the issue .
  
  Thank you