Desktop Grid - Auto Formula Calculation in ImportDataTable

Aspose.Cells Product Family
1

Hi

I am using following code in desktop grid:

Dim lintRowCounter as Integer = 0
while lintRowCounter < 100
ldtAllData.Rows(lintRowCounter).Item"GroupName") = “+O2+P2”
lintRowCounter+=1
End While
grdDataEntry.Worksheets(0).ImportDataTable(ldtAllData, True, 0, 0)
grdDataEntry.RunAllFormulas()

When my ImportDataTable function runs, its taking a long time to import data table in grid since i have used forumulas. The reason i noticed is that its running/calculating forumals at the time of importing. How can we stop this formula calculation while importing and instead use RunAllFormulas() after the data import.

Thanks

2

Hi,

Please utilize the property i.e.., "GridDesktop.RecalculateFormulas" to enable/disable it to recalculate all the cells formulas when a cell's value is changed. The default value is "true".

Please set "GridDesktop.RecalculateFormulas" to false for your scenario before you call "Worksheet.ImportDataTable()" method and you may set it back to true after the import operation is done. This may help to enhance the import datatable performance.

Thank you.