dc22wt 你好,
可以设置公式在第二列,然后隐藏第二列,最后把结果赋值给第一列:- for (int i = 0; i < 10; i++)
- {
- this.fpSpread1.Sheets[0].Cells[i, 0].Value = i*100;
- }
- this.fpSpread1.Sheets[0].Columns[1].Visible = false;
- this.fpSpread1.Sheets[0].Columns[0].Formula = "QUOTIENT(A1,100)";
复制代码 |