GrapeCity.Documents.Excel.IWorkbook.WaitForCalculationToFinish

WaitForCalculationToFinish Method

WaitForCalculationToFinish()

Waits for all calculations in the workbook to finish.

This method blocks the current thread until all pending calculations, including asynchronous calculations, have completed. Call this method before performing operations that depend on calculated results.

Declaration

void WaitForCalculationToFinish()

Sub WaitForCalculationToFinish()

Examples

worksheet.Range["A1"].Formula = "=IMAGE(\"https://example.com/logo.jpg\")";
workbook.Calculate();
workbook.WaitForCalculationToFinish();
CellPicture picture = worksheet.Range["A1"].CellPicture;