fpspread for windows application in vb column multiplication

Posted by: preethimurthy11 on 8 September 2017, 2:55 pm EST

  • Posted 8 September 2017, 2:55 pm EST

     

    Im my application i wanna to multiply in fpspread sheet in a row .... there are columns... i need to multiply col*col and result should appear in the corresponding column.... 

  • Replied 8 September 2017, 2:55 pm EST

    Are you saying you want to multply an entire column by another entire column or are you talking about multplying 2 cells in 2 different columns, and when you say the result should appear in the corresponding column, what does that mean?
  • Replied 8 September 2017, 2:55 pm EST

    Hello,

    It seems you want the cell in Column A to be multiplied by Column B and the result should appear in Column C. If that is correct you may set the formula for all cells in Column C as :

     

    fpSpread1.Sheets[0].ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
    int i;
    for (i = 0; i <= fpSpread1.ActiveSheet.RowCount - 1; i++)
    {
    fpSpread1.Sheets[0].Cells[i, 2].Formula = "RC[-1] * RC[-2]" ;

    }

     

    Thanks,

  • Replied 8 September 2017, 2:55 pm EST

    Thank you very much sir...

    I would appreciate your understanding level.... i would def.... try this code in my application 

     

     thanks

     

    preethi

Need extra support?

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

Learn More

Forum Channels