public void Formula6()
{
GcSpreadGrid gcSpread1 = new GcSpreadGrid();
gcSpread1[0, 0].Value = 1;
gcSpread1[0, 1].Value = 2;
gcSpread1[1, 0].Value = 3;
gcSpread1[1, 1].Value = 4;
gcSpread1[0, 2].Formula = "A1";
gcSpread1.ReferenceStyle = ReferenceStyle.R1C1;
gcSpread1[0, 3].Formula = "R2C2";
gcSpread1[0, 4].Formula = "SUM(RC[-4]:R[1]C[-3])";
}
Public Sub Formula6()
Dim gcSpread1 As New GcSpreadGrid()
gcSpread1(0, 0).Value = 1
gcSpread1(0, 1).Value = 2
gcSpread1(1, 0).Value = 3
gcSpread1(1, 1).Value = 4
gcSpread1(0, 2).Formula = "A1"
gcSpread1.ReferenceStyle = ReferenceStyle.R1C1
gcSpread1(0, 3).Formula = "R2C2"
gcSpread1(0, 4).Formula = "SUM(RC[-4]:R[1]C[-3])"
End Sub