设置单元格类型（NumberCellType）之后，如何使之立刻生效

收藏

绑定数据之后，对单元格设置了CellType（NumberCellType），虽然显示的数据位数都没有问题，但是当使用公式计算（SUM（E1:E2））的时候，还是不好使。但是手动双击单元格之后，公式就正常了，不知道为什么？

fpSpread.Sheets[0].SheetName = "T1";
List<MyClass> strList = new List<MyClass>();
List<MyClass> strList1 = new List<MyClass>();
strList.Add(new MyClass() { P1 = "111" });
strList.Add(new MyClass() { P1 = "222" });
strList.Add(new MyClass() { P1 = "333" });
strList.Add(new MyClass() { P1 = "444" });
strList1.Add(new MyClass() { P1 = "11" });
strList1.Add(new MyClass() { P1 = "22" });
strList1.Add(new MyClass() { P1 = "33" });
strList1.Add(new MyClass() { P1 = "44" });
FarPoint.Win.Spread.Data.SpreadDataBindingAdapter data = new FarPoint.Win.Spread.Data.SpreadDataBindingAdapter();
data.DataSource = strList;
data.Spread = fpSpread;
data.SheetName = "T1";
data.MapperInfo = new FarPoint.Win.Spread.Data.MapperInfo(15,3, strList.Count, 1);
data.FillSpreadDataByDataSource();
data.Dispose();
FarPoint.Win.Spread.Data.SpreadDataBindingAdapter data1 = new FarPoint.Win.Spread.Data.SpreadDataBindingAdapter();
data1.DataSource = strList1;
data1.Spread = fpSpread;
data1.SheetName = "T1";
data1.MapperInfo = new FarPoint.Win.Spread.Data.MapperInfo(15, 4, strList1.Count, 1);
data1.FillSpreadDataByDataSource();
data1.Dispose();
//单元格类型必须在绑定之后设置才有效
FarPoint.Win.Spread.CellType.NumberCellType numCellType = new FarPoint.Win.Spread.CellType.NumberCellType();
numCellType.DecimalPlaces = 2;
this.fpSpread.ActiveSheet.Cells[15, 3, 15 + strList.Count, 3 + 1].CellType = numCellType;
this.fpSpread.ActiveSheet.Cells[15, 4, 15 + strList1.Count, 4 + 1].CellType = numCellType;
for (int t = 15; t <= 15 + strList.Count; t++)
{
CellSumFormula(fpSpread.ActiveSheet.Cells[t - 1, 5], 'D', 1, t);
}
private void CellSumFormula(FarPoint.Win.Spread.Cell cell, char startColumn, int span, int row)
{
char strEnd = (char)(startColumn + span);
string strFormula = "SUM(" + startColumn.ToString() + row.ToString() + ":" + strEnd.ToString() + row.ToString() + ")";
cell.Formula = strFormula;
}
public class MyClass
{
public string P1 { get; set; }
}

复制代码

ZenosZeng · ZenosZeng

回复 1楼fengling2001的帖子

fengling2001 你好

你提到设置公式之后不好使，是指的什么意思呢，是数据格式不对吗，能否提供以下详细的操作步骤。

双击单元格之后会重新格式化单元格的数据。

fengling2001 · fengling2001

上面的代码直接运行，求和单元格显示的是0，然后双击Cells[15, 3, 15 + strList.Count, 3 + 1]和Cells[15, 4, 15 + strList1.Count, 4 + 1]其中的单元格，求和公式就会发生作用，得到正确结果

ZenosZeng · ZenosZeng

fengling2001 你好

这和你数据源中数据的类型有关，你需要将 public string P1 { get; set; } 修改为 public int P1 { get; set; }，最终代码如下：

private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.Sheets[0].SheetName = "T1";
List<MyClass> strList = new List<MyClass>();
List<MyClass> strList1 = new List<MyClass>();
strList.Add(new MyClass() { P1 = 111 });
strList.Add(new MyClass() { P1 = 222 });
strList.Add(new MyClass() { P1 = 333 });
strList.Add(new MyClass() { P1 = 444 });
strList1.Add(new MyClass() { P1 = 11 });
strList1.Add(new MyClass() { P1 = 22 });
strList1.Add(new MyClass() { P1 = 33 });
strList1.Add(new MyClass() { P1 = 44 });
FarPoint.Win.Spread.Data.SpreadDataBindingAdapter data = new FarPoint.Win.Spread.Data.SpreadDataBindingAdapter();
data.DataSource = strList;
data.Spread = fpSpread1;
data.SheetName = "T1";
data.MapperInfo = new FarPoint.Win.Spread.Data.MapperInfo(15, 3, strList.Count, 1);
data.FillSpreadDataByDataSource();
data.Dispose();
FarPoint.Win.Spread.Data.SpreadDataBindingAdapter data1 = new FarPoint.Win.Spread.Data.SpreadDataBindingAdapter();
data1.DataSource = strList1;
data1.Spread = fpSpread1;
data1.SheetName = "T1";
data1.MapperInfo = new FarPoint.Win.Spread.Data.MapperInfo(15, 4, strList1.Count, 1);
data1.FillSpreadDataByDataSource();
data1.Dispose();
//单元格类型必须在绑定之后设置才有效
FarPoint.Win.Spread.CellType.NumberCellType numCellType = new FarPoint.Win.Spread.CellType.NumberCellType();
numCellType.DecimalPlaces = 2;
this.fpSpread1.ActiveSheet.Cells[15, 3, 15 + strList.Count, 3 + 1].CellType = numCellType;
this.fpSpread1.ActiveSheet.Cells[15, 4, 15 + strList1.Count, 4 + 1].CellType = numCellType;
for (int t = 15; t <= 15 + strList.Count; t++)
{
CellSumFormula(fpSpread1.ActiveSheet.Cells[t - 1, 5], 'D', 1, t);
}
}
private void CellSumFormula(FarPoint.Win.Spread.Cell cell, char startColumn, int span, int row)
{
char strEnd = (char)(startColumn + span);
string strFormula = "SUM(" + startColumn.ToString() + row.ToString() + ":" + strEnd.ToString() + row.ToString() + ")";
cell.Formula = strFormula;
}
public class MyClass
{
public int P1 { get; set; }
}

复制代码

		自动登录	找回密码
密码			立即注册

设置单元格类型（NumberCellType）之后，如何使之立刻生效

3 个回复

活字格认证

圣诞拼拼乐

微信认证勋章

讲师达人

元老葡萄

悬赏达人