Hello,
Show Style Dialog crash on out of memory exception or take a while when many cells are selected.
Any idea?
Hi Richard,
Thank you for contacting Aspose support.
I have evaluated the presented scenario while using the latest version of
Aspose.Cells.GridDesktop 9.0.0, however, I was not able to observe any problem. Please note, I have executed the following statement in the Form1_Load event, and it showed the Format Cells dialog correctly.
Please give a try to the latest version of the component. In case the problem persists, please provide us an executable sample application along with its dependencies.
C#
this.gridDesktop1.ShowStyleDialog();
Thanks for your answer.
I have selected 1000*1000 cells range.
Hi Richard,
Thank you for sharing more information.
I have given this scenario another try by loading a sample spreadsheet containing data for 1000x1000 matrix. On GridDesktop interface, I selected all cells using CTRL + A then executed the statement (from my previous response) using a button click event. In another test, I dynamically injected values to the GridDesktop using the following snippet and repeated the process. In both cases, I am not able to observe any exception.
If you have tested the latest build and the problem persists, please share the sample application along with all dependencies to replicate the issue.
C#
for(int r = 0; r< 1001;r++)
{
for (int c = 0; c < 1001; c++)
{
this.gridDesktop1.Worksheets[0].Cells[r, c].Value = 1;
}
}
this.gridDesktop1.Refresh();