Griddesktop : crash on Show Style Dialog

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();