Replied 8 September 2017, 2:07 pm EST
Well I try with this code but always receive error message
<font color="#3300ff"><b> Dim _Range As String = "Sheet1!B1:B10"</b></font>
<font color="#3300ff"><b> FpSpread1.ActiveSheetIndex = 1
FpSpread1.Sheets(0).ReferenceStyle = Model.ReferenceStyle.A1
Dim formula As String = "AVERAGE(" & _Range & ")"
FpSpread1.Sheets(1).Cells(5,5).Formula = formula</b></font>
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.
<font color="#ff0000"><b> FpSpread1.Sheets(1).Cells(0,0).Formula =
and use the ReferenceStyle property to set the reference style.
But Does Work!
Some body can show me the correct way to do that? <img src="/emoticons/emotion-9.gif" alt="Crying" /><img src="/emoticons/emotion-8.gif" alt="Indifferent" /><img src="/emoticons/emotion-7.gif" alt="Tongue Tied" />