How to set a formula as the following image

How to set a formula as the following image

Posted by: malishin on 9 November 2020, 6:10 am EST

• 

  malishin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 November 2020, 6:10 am EST - Updated 30 September 2022, 12:01 pm EST

  “C” column =“D” column +“E” column
  
  It means that each cell in column C is the sum of the cells in the same row in column D and E
  
  In excel, just select column C, then enter D:D+E:E in the formula textbox

  

  290×553 3.9 KB

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 12 November 2020, 4:38 am EST

  Hi,

  In order to apply formula on a column such that it displays sum of the row values in other two columns, you can use the following code snippet:

  
  fpSpread1.SetRefStyle (RefStyleA1)
  fpSpread1.AutoCalc = True
  fpSpread1.AllowUserFormulas = True
  
  fpSpread1.Col = 3 'index of the column in which the formula is to be set
  fpSpread1.CellType = CellTypeNumber
  fpSpread1.Formula = "SUM(A1:B1)"
  
  

  Please refer to the attached sample implementing the same.

  Thanks,
  
  Pragati

  SpreadFormulaCheck.zip

• 

  malishin

  • Post Options:
  • Link
    Copy

  Posted 16 November 2020, 12:31 am EST

  Thanks Pragati