public void btnBetaArray_Click(IRibbonControl e)
{
this.btnClear_Click(e);
ObjModel.SetCell(10, "A1");
ObjModel.SetCell(2, "B1");
ObjModel.SetCell(3, "C1");
ObjModel.SetCell(15, "D1");
ObjModel.SetArrayFormulas("A2:D2", "=Beta2M(A1,B1,C1,D1)");
}
public void btnAddFormulas_Click(IRibbonControl e)
{
ObjModel.SetFormulas("A1:B2", "=C3"); //relative references
ObjModel.SetFormulas("A4:B5", "=$C$3"); //absolute references
ObjModel.SetCell(5, "A6");
ObjModel.SetFormulas("A7:A10", "=A5+RandBetween(5,100)+Norm.Inv(.3,0,1)"); //add a formula to the sheet
ObjModel.SetFormulas("E1:H1", "=Column()+2000");
ObjModel.SetArrayFormulas("E2:H2", "=INFL(2002, 2000,1,1,4)*E1:H1");
}