i m elaborate my doubt clearly...
Step 1 : i have draged a fpspread(fpspread1) into my form .
step 2 : i m just binding a excel sheet to the fpspread1.
and this excel contains some formula like
Eth column contains sum formula i.e =SUM(B:D)
means if 2th row then E2=SUM(B2:D2),3th row then E3=SUM(B3:D3) so on........
Step 3:now through code i m writhing the values in column B,C,D and now E Column should show the sum of B,C and D as per the above formula but it's not showing the Eth column value is showing zero.
code using to writing the values in column (B,C and D ) using for loop and values is writing properly.
FpSpread1.ActiveSheet.Cells(RowNumber - 1, ColumnNumber - 1).Value = CStr(dsSummary.Tables(0).Rows(i)("Shells"))
Note:after binding the excel sheet in the FpSpread1 if i typing the value directly in the fpspread1 column B,C and D then it's showing the sum correctly in E column but through code it's not working.
hope now u guys will be clear abt my doubt..
SantoshSantosh4u, if this helps please login to Mark As Answer. | Alert Moderator