Spread for ASP.NET 使用拼接方法设置公式

鉴于论坛中有很多用户提出如何在后台拼接公式，下面给出实现方法：

1. protected void Page_Load(object sender, EventArgs e)
   
2.         {
   
3.             if (IsPostBack)
   
4.             {
   
5.                 return;
   
6.             }
   
7.             FpSpread1.Sheets[0].ReferenceStyle = FarPoint.Web.Spread.Model.ReferenceStyle.R1C1;
   
8.             this.FpSpread1.ClientAutoCalculation = true;
   
9. 
   
10.             this.FpSpread1.Sheets[0].Cells[0, 2].Tag = "单价";
    
11.             this.FpSpread1.Sheets[0].Cells[1, 3].Tag = "数量";
    
12.             this.FpSpread1.Sheets[0].Cells[2, 3].Tag = "总金额";
    
13. 
    
14.             FarPoint.Web.Spread.Cell _unitPrice = this.FpSpread1.Sheets[0].GetCellFromTag(this.FpSpread1.Sheets[0].Cells[0, 0], "单价");
    
15.             FarPoint.Web.Spread.Cell _quantity = this.FpSpread1.Sheets[0].GetCellFromTag(this.FpSpread1.Sheets[0].Cells[0, 0], "数量");
    
16.             FarPoint.Web.Spread.Cell _toalPrice = this.FpSpread1.Sheets[0].GetCellFromTag(this.FpSpread1.Sheets[0].Cells[0, 0], "总金额");
    
17.             this.FpSpread1.Sheets[0].AllowUserFormulas = true;
    
18.             string formula = "PRODUCT(" + "R" + (_unitPrice.Row.Index + 1).ToString() + "C" + (_unitPrice.Column.Index + 1).ToString() + "," + "R" + (_quantity.Row.Index + 1).ToString() + "C" + (_quantity.Column.Index + 1).ToString() + ")";
    
19. 
    
20.             _toalPrice.Formula = formula;
    
21.         }

复制代码