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
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.
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 was not able to reproduce the issue with the latest build of 11.1. When I ask for the value of RESUMEN_A_CARGAR!C6, I am correctly getting the value 368834.38790735. It takes about 8 seconds to return the value on my machine. This is because when a recalculation is required for a requested cell, everything in the workbook is recalculated before returning the cell value. However, if this time is unacceptable, I can have Developer Support submit an issue for you so that we can investigate additional performance improvements.
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,
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.