fpspread打开报表初始化时需要设置很多单元格elock属性和背景色，性能很慢，打开一...

收藏

fpspread打开报表初始化时需要设置很多单元格elock属性和背景色，性能很慢，打开一张表五秒多，怎么改善性能

dexteryao · dexteryao

您把您现在的代码发过来我们看下。

回复 · 13818435845

dexteryao 发表于 2017-1-23 10:22
您把您现在的代码发过来我们看下。

fpSpread1.ActiveSheet.Protect = true;
         for (int i = 0; i < 28; i++)
         {
            for (int j = 0; j <18; j++)
            {
                  if (array[i, j] == 1)
                  {
                     fpSpread1.ActiveSheet.Cells[i + 4, j + 3].Locked = false;
                  }
            }
         }
private int[,] array = new int[,] { {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
                                       {1,1,1,1,1,1,1,1,1,1,1,1,0,2,1,0,2,0 },
                                       {1,1,1,1,1,1,1,1,1,1,1,1,0,1,2,0,0,2 },
                                       {3,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
                                       {3,3,1,1,1,1,1,1,1,1,1,1,0,2,1,0,2,0 },
      {3,3,1,1,1,1,1,1,1,1,1,1,0,1,2,0,0,2 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {3,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {3,3,1,0,1,0,1,0,1,0,1,0,0,2,1,0,2,0 },
      {3,3,1,0,1,0,1,0,1,0,1,0,0,1,2,0,0,2 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {1,0,1,0,1,0,1,0,1,0,1,0,0,2,1,0,2,0 },
      {1,0,1,0,1,0,1,0,1,0,1,0,0,1,2,0,0,2 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {1,1,1,1,1,1,1,1,1,1,1,1,0,2,1,0,2,0 },
      {1,1,1,1,1,1,1,1,1,1,1,1,0,1,2,0,0,2 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {1,1,1,1,1,1,1,1,1,1,1,1,0,2,1,0,2,0 },
      {1,1,1,1,1,1,1,1,1,1,1,1,0,1,2,0,0,2 },
      {3,3,3,3,3,3,3,3,0,0,0,0,0,0,0,0,0,0 },
      {3,3,3,3,3,3,3,3,1,1,1,1,0,2,1,0,2,0 },
      {3,3,3,3,3,3,3,3,1,1,1,1,0,1,2,0,0,2 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 },
      {1,1,1,1,1,1,1,1,1,1,1,1,0,2,1,0,2,0 },
      {1,1,1,1,1,1,1,1,1,1,1,1,0,1,2,0,0,2 },
      {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 }};
for (int i = 0; i < fpSpread1.ActiveSheet.RowCount; i++)
         {
            for (int j = 0; j < fpSpread1.ActiveSheet.ColumnCount; j++)
            {
                  if (fpSpread1.ActiveSheet.Cells[i, j].Locked.Equals(false))
                  {
                     fpSpread1.ActiveSheet.Cells[i, j].BackColor = System.Drawing.Color.FromArgb(((System.Byte)(198)), ((System.Byte)(226)), ((System.Byte)(255)));
                  }
                  else
                  {
                     fpSpread1.ActiveSheet.Cells[i, j].BackColor = this.BackColor;
                     fpSpread1.ActiveSheet.Cells[i, j].CanFocus = false;
                  }
                  if (this.fpSpread1.ActiveSheet.Cells[i, j].Locked.Equals(false) && flag)
                  {
                     this.fpSpread1.ActiveSheet.SetActiveCell(i, j);
                     flag = false;
                  }
            }
         }

dexteryao · dexteryao

您按照下面代码试下，把AllowCellOverflow 设置成false再设置背景色

bool oldAllowCellOverflow = fpSpd.AllowCellOverflow;
fpSpd.AllowCellOverflow = false;
for (int r = 0; r < 27; r++)
{
for (int c = 0; c < 26; c++)
{
var rowIndex = r + 5;
var colIndex = c + 3;
Cell cell = fpSpd.ActiveSheet.Cells[rowIndex, colIndex];
if (cell != null)
{
cell.BackColor = Color.Gray;
}
}
}
fpSpd.AllowCellOverflow = oldAllowCellOverflow;
}
}

复制代码

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

[已处理] fpspread打开报表初始化时需要设置很多单元格elock属性和背景色，性能很慢，打开一...

3 个回复

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章