Hi,
We are unable to read any formula cell value in the attached sheet.
For example: Sheet [0] and Cell P3 & P4
Excel dll:- Infragistics4.Documents.Excel.v12.1
Version:12.1.20121.1001
Thanks,
As per my investigation, I am able to read the formula cell above sheet with the old version of the dll
Infragistics4.Documents.Excel.v11.2 ; Version: 11.2.20112.1010
but there is excel hang up issue resolved in the latest version of dll : Infragistics4.Documents.Excel.v12.1 ; Version: 12.1.20121.1001
but formaula in cell "D57" is not evaluate properly by any version of the above dlls.
Correction: Formaula in cell "D59" is not evaluate properly by any version of the above dlls.
Formula: ='Seal Main by CC'!$G$201+'Seal Main by CC'!$G$202
I was able to reproduce this issue. It was actually already fixed for issue id 99854. The fix will be released in the next Service Release for versions 11.1 and later. I will have Developer Support notify you when the SR is released.
This issue has been linked to item 99854 which was submitted earlier to development. You will be notified when the fix is released.
Support case CAS-91462-21B8ZJ has been opened for you and you will receive updates through the case.