I am using the following version of the Infragistics Excel dlls:-
Name: Infragistics3.Documents.Excel.v12.1
Version:12.1.20121.2008
I am facing following issues:-
The first issue may be a bug. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue. As far as performance, when you access the first calculated value in the workbook, all formulas are calculated if they haven't been calculated yet. That is probably why the first sheet is taking so long. However, I will have DS submit a second issue so we can do a performance pass and see if any improvements can be made.