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

    <p> </p><p>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....  <br></p>
  • 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

    <p>Hello,</p><p>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 :</p><p> </p><p>fpSpread1.Sheets[0].ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;<br>int i;<br>for (i = 0; i <= fpSpread1.ActiveSheet.RowCount - 1; i++) <br>{<br>fpSpread1.Sheets[0].Cells[i, 2].Formula = "RC[-1] * RC[-2]" ;</p><p>} </p><p> </p><p>Thanks, <br></p>
  • Replied 8 September 2017, 2:55 pm EST

    <p>Thank you very much sir...<br></p><p>I would appreciate your understanding level.... i would def.... try this code in my application  <br></p><p> </p><p> thanks</p><p> </p><p> preethi<br></p>
Need extra support?

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

Learn More

Forum Channels