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
There are a couple reasons why the formula's value might be incorrect. If you are seeing a #NAME? error instead of a calculated value, it probably means the Excel library does not have an implementation of one or more functions being used by that cell or any cell it references. If you are seeing a calculated value that is incorrect, it is possible our implementation of the function does not match Excel's in all cases. In either case, it should be considered a bug. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.
Ok.
Url from excel file example test_definitive_Infragistics.rar:http://www.mediafire.com/download.php?cx2xkawu67p2dj3I want to work from RESUMEN_A_CARGAR worksheet.For example, cell value from C6 is one cell which is incorrect,...Also, the response time of GetCellValue is very high.I look forward to his reply.Sincerely,
I get value:h.Rows(5).Cells(2).Value or r.GetCellValue(2)Or recalculate the workbook with method w.Recalculate(),and the result is always wrong.Which version are you performing the test???I need read all cells in worksheet, so that times are enormous. Are necessary better response times for the control. But is not feasible to work ...
Best regards,
I tested with version 11.1.20111.2111, which is the latest SR and I only get the slowness when asking for the first two values. After that, all values are returned immediately. I also tested with version 2050 and I see what you are talking about now. The wrong value is returned for C6 and there is a delay when getting all calculated values. If you upgrade to the latest SR, it should fix the issue.
OK, I upgraded to the latest SR (version 11.1.20111.2111), and value is correct and response time too.Thanks for your help
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.
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%?
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.