How to set formula into GrapeCity.SpreadBuilder.Cells.DDCell

How to set formula into GrapeCity.SpreadBuilder.Cells.DDCell

Posted by: astanishevskaya on 1 June 2020, 5:54 am EST

• 

  astanishevskaya

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 June 2020, 5:54 am EST

  Hi there!
  
  I use GrapeCity.ActiveReports12 and can’t set formula into DDCell.
  
  I tried to set it as value
  
  workbook.Sheets[0].Cell(7, 4).SetValue(“=SUM(C5;C6)”);

  But when I open dowloaded xlsx file I see this value as string in the cell “=SUM(C5;C6)”.
  
  Please, could you help me how can I set formula into DDCell?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 June 2020, 6:09 am EST

  Hello,

  GrapeCity.SpreadBuilder.Cells.DDCell does not support the formula. You can go for our Spread product which support feature of Excel. Please refer to the following link:
  
  https://www.grapecity.com/spreadnet

  Thanks,
  
  Mohit