Spread for ASP.NET 使用拼接方法设置公式_fpspread+formula-优快云博客

本文详细介绍了如何在网页中初始化FPSpread控件，并通过设置ReferenceStyle为R1C1，启用客户端自动计算，以及定义单元格的标签来实现数据的直观展示和公式计算。具体包括了获取特定单元格作为单价、数量和总金额的计算基础，并通过公式计算总金额的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

protected void Page_Load(object sender, EventArgs e)

{

if (IsPostBack)

{

return;

}

FpSpread1.Sheets[0].ReferenceStyle = FarPoint.Web.Spread.Model.ReferenceStyle.R1C1;

this.FpSpread1.ClientAutoCalculation = true;

this.FpSpread1.Sheets[0].Cells[0, 2].Tag = "单价";

this.FpSpread1.Sheets[0].Cells[1, 3].Tag = "数量";

this.FpSpread1.Sheets[0].Cells[2, 3].Tag = "总金额";

FarPoint.Web.Spread.Cell _unitPrice = this.FpSpread1.Sheets[0].GetCellFromTag(this.FpSpread1.Sheets[0].Cells[0, 0], "单价");

FarPoint.Web.Spread.Cell _quantity = this.FpSpread1.Sheets[0].GetCellFromTag(this.FpSpread1.Sheets[0].Cells[0, 0], "数量");

FarPoint.Web.Spread.Cell _toalPrice = this.FpSpread1.Sheets[0].GetCellFromTag(this.FpSpread1.Sheets[0].Cells[0, 0], "总金额");

this.FpSpread1.Sheets[0].AllowUserFormulas = true;

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() + ")";

_toalPrice.Formula = formula;

}