How to set a formula as the following image

Posted by: malishin on 8 November 2020, 9:10 pm EST

    • Post Options:
    • Link

    Posted 8 November 2020, 9:10 pm EST - Updated 30 September 2022, 3:01 am 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

  • Posted 11 November 2020, 7:38 pm EST


    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.



  • Posted 15 November 2020, 3:31 pm EST

    Thanks Pragati

Need extra support?

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

Learn More

Forum Channels