Apply .Formula Property in SpreadHeader - FarPoint - SpreadSheet ver 7.0
- by vetrivelan.s
In FarPoint SpreadSheet ver 7 - How to apply .Formula property at SpreadHeader+1 ? .That is second Header of the Spread. We can apply .Formula property at SpreadHeader + 0.That is Top Header. I use the following code,
With fpSpread1
.Row = SpreadHeader + 0
.col = 1
.CellType = CellTypeNumber
.Formula = "SUM(A1:A10)"
End With