fpSpread如何选中多个单元格后计算出所有单元格中数字之和

收藏

各位大侠请教：
我现在在一个项目中用FPSpread的时候，用户希望在选中多个单元格之后自动计算出单元格中数字之和(所有单元格中只有数字类型),
之前尝试过如下代码:
         int sum = 0;
         int startrow = this.fpSpread1.ActiveSheet.ActiveCell.Row.Index;
         int startcolumn = this.fpSpread1.ActiveSheet.ActiveCell.Column.Index;
         int rowlen = this.fpSpread1.ActiveSheet.GetSelection(0).RowCount;
         int columnlen = this.fpSpread1.ActiveSheet.GetSelection(0).ColumnCount;

         for (int i = 0; i < rowlen; i++) {
            for (int j = 0; j < columnlen; j++) {
                  if (this.fpSpread1.ActiveSheet.Cells[startrow + i, startcolumn + j].Value != null || Convert.ToInt32(this.fpSpread1.ActiveSheet.Cells[startrow + i, startcolumn + j].Value) != 0)
                  {
                     sum += Convert.ToInt32(this.fpSpread1.ActiveSheet.Cells[startrow + i, startcolumn + j].Value);
                  }
            }
         }

但是这样计算出来的结果是不正确的，哪位高手援助下啊
跪求答案...
在线等...

gw0506 · gw0506

具体是怎么不正确呢？

gerry · gerry

小改了一下您的code
int sum = 0;
int startrow = this.fpSpread1.ActiveSheet.GetSelection(0).Row;
int startcolumn = this.fpSpread1.ActiveSheet.GetSelection(0).Column;
         int rowlen = this.fpSpread1.ActiveSheet.GetSelection(0).RowCount;
         int columnlen = this.fpSpread1.ActiveSheet.GetSelection(0).ColumnCount;

         for (int i = 0; i < rowlen; i++) {
            for (int j = 0; j < columnlen; j++) {
                  if (this.fpSpread1.ActiveSheet.Cells[startrow + i, startcolumn + j].Value != null || Convert.ToInt32(this.fpSpread1.ActiveSheet.Cells[startrow + i, startcolumn + j].Value) != 0)
                  {
                     sum += Convert.ToInt32(this.fpSpread1.ActiveSheet.Cells[startrow + i, startcolumn + j].Value);
                  }
            }
         }

相信你看了就知道你错在哪里了:-)

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

fpSpread如何选中多个单元格后计算出所有单元格中数字之和

2 个回复

活字格认证