I'm working with Infragistics3.Documents.Excel.v11.1 (v11.1.20111.2050)
I have a workbook with a cells with very complex formula (formulas referenced to other worksheets with another formulas, these to other worksheets with another formulas,....so successively )(The workbook have 20 worksheets...)
I recalculate the workbook and save to another workbook, and the cell values to some cells are incorrect.But formula of the cell is correct (h.Rows(5).Cells(2).Formula.ToString() is correct, but not the value)To what level of complexity of the formula can work infragistics?
I only want to work with cell values of one worksheet...
What is the problem? Some solution?
Thanks in advance
As I said above, getting the first value does recalculate the entire workbook. If you feel like the performance should be improved, you can contact Developer Support and submit an issue for this. We may be able to find other ways to improve the speed. But regardless of how fast it can be, the CPU will most likely run at 100% while the workbook is being recalculated.
The CPU is set at 100% to get the GetCellValue of one cell with formulas, (not recalculate workbook), however, when I work with the Excel application the cpu use is much lower.The fact that it consumes so many cpu it is not optimal.
There are a lot of things which have to occur to recalculate the entire workbook. The only way to do all the calculations without the CPU being at 100% is to do some time-slicing approach internally, but this would just make the delay longer. Is there a problem with the CPU hitting 100%?
I've been doing more testing and the response time has improved, but to get cell value, CPU is at 100%.That should improve as well.
OK, I upgraded to the latest SR (version 11.1.20111.2111), and value is correct and response time too.Thanks for your help