Hi,

We are using Infragistic Excel version 10.3 in our Silverlight 4 project. We are creating 3 sheets in it which have more than 100 values/formulas and all sheets are intra dependent (i.e. one sheet formula depends on other sheet formula). After filling the sheet when we call Recalculate or even try to get a values of any cell of any sheet then application does not response (even sometime take more than 10 minutes)

We also tried to make/add all three sheets data in one sheet (i.e. first sheet data from row 1 to 100 and second sheet data from 101 to 200 and third from 201 to 300) but still it does not work.

Here is the code snippet how we are filling Infragistic Excel

excelHelper.wb.SuspendCalculations();
FillSheet1();
FillSheet2();
FillSheet3();
excelHelper.wb.ResumeCalculations();
excelHelper.wb.Recalculate();

We apply the formula to each cell like this

formula = "=($" + thisCol + "$2/$" + preCol + "$2 - 1)";
excelHelper.sheetIncomeStmt.Rows[2].Cells[iCol].ApplyFormula(formula);

thisCol and preCol will be dynamic generated column name (like "A", "B")

In debug mode we checked that application remain unresponsive on "excelHelper.wb.Recalculate". Here one thing is important to mention that if we put breakpoint on this line and then try to view any cell value in Quick Watch window then it throw Timeout exception after certain seconds. After this Timeout exception if we press F5 key to run the program then it runs smoothly but if we didn't use Quick Watch window then application does n't response.

We exported Infragistic Excel to Microsoft Excel (Attached one) and it doesn't have any error (like Circular reference or divide by zero).

We will appreciate prompt response. Thank