winform7下清空spread内容，特别卡。

收藏

winform7下清空spread内容，特别慢，画面会卡好一会。数据差不多有500条。写法如下：
objSpdObj.ClearRange(0, 0, 500, 24, False)；
请问该怎么优化？

iceman · iceman

回复 1楼gengwh的帖子

请问你那边的测试时间是多少？
在我的机器上使用时间为：00:00:00.1858036。
测试代码如下：

private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
for (int i = 1; i < 25; i++)
{
dt.Columns.Add("第"+i.ToString()+"列");
}
for (int i = 0; i < 500; i++)
{
dt.Rows.Add("test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test");
}
this.fpSpread1.DataSource = dt;
}
private void clearRangeToolStripMenuItem_Click(object sender, EventArgs e)
{
Stopwatch st = new Stopwatch();
st.Start();
fpSpread1.SuspendLayout();
fpSpread1.Sheets[0].ClearRange(0, 0, 500, 24, false);
fpSpread1.ResumeLayout();
st.Stop();
MessageBox.Show(st.Elapsed.ToString());
}

复制代码

gengwh · gengwh

00:00:00.37664。
弹出这个框之后，会卡那么一段时间，
也不知道是什么原因。。

iceman · iceman

回复 3楼gengwh的帖子

gengwh 你好，
请问你那边如果不弹出框，还会卡么？

private void clearRangeToolStripMenuItem_Click(object sender, EventArgs e)
{
Stopwatch st = new Stopwatch();
st.Start();
fpSpread1.SuspendLayout();
fpSpread1.Sheets[0].ClearRange(0, 0, 500, 24, false);
fpSpread1.ResumeLayout();
st.Stop();
//MessageBox.Show(st.Elapsed.ToString());
}
private void setDataToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
for (int i = 1; i < 25; i++)
{
dt.Columns.Add("第" + i.ToString() + "列");
}
for (int i = 0; i < 500; i++)
{
dt.Rows.Add("test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test", "test");
}
this.fpSpread1.DataSource = dt;
}

复制代码

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

[已处理] winform7下清空spread内容，特别卡。