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,