Replied 8 September 2017, 2:07 pm EST
Well I try with this code but always receive error message
Dim _Range As String = "Sheet1!B1:B10"
FpSpread1.ActiveSheetIndex = 1
FpSpread1.Sheets(0).ReferenceStyle = Model.ReferenceStyle.A1
Dim formula As String = "AVERAGE(" & _Range & ")"
FpSpread1.Sheets(1).Cells(5,5).Formula = formula
Could You Tell me what it's wrong in this code, because i check the name of the sheet and is correct Sheet1, the range also contain values I try following the help example
Another example would be keeping a running total off cells of one sheet on a
separate sheet. Use the Formula property to put a formula on one sheet that
references the cells you want added from another sheet.
and use the ReferenceStyle property to set the reference style.
But Does Work!
Some body can show me the correct way to do that?