回复 5楼jian.du的帖子
Spread for ASP.NET 设计器中只能对单个的单元格进行设置公式。如果公式量过大我推荐您用代码设置:
- FarPoint.Web.Spread.Column mycol;
- mycol = FpSpread1.ActiveSheetView.Columns[2];
- FpSpread1.ActiveSheetView.SetValue(0, 0, 10);
- FpSpread1.ActiveSheetView.SetValue(1, 0, 10);
- FpSpread1.ActiveSheetView.SetValue(0, 1, 10);
- FpSpread1.ActiveSheetView.SetValue(1, 1, 10);
- mycol.Formula = "PRODUCT(A1:B1)";
- FpSpread1.ClientAutoCalculation = true;
复制代码 |