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"); }