We were thinking about reaplacing the usage of COM Excel object with some of the 3rd party .Net components. I was evaluating several of them and saw that Infragistics component is one of few that uses its own(?) CalcEngine. Hovever it has problems when referencing other sheets and ranges. Is there any way to tweak the CalcEngine to work with formulas like this:
=IF('ALL YLT'!A4<>"";SUMIF('ALL YLT'!$D$3:$Z$3;"STD";'ALL YLT'!D4:Z4)+SUMIF('ALL YLT'!$D$3:$Z$3;"ADH";'ALL YLT'!D4:Z4);"")
Code:
Outupt window:
File in Excel
Thanks
A formula like that should work. I believe a bug fix was made recently which might cause this to work. Can you send me the excel file you used with this code and I will check to see if it works now?
here you go :)
Hello ,
I have created a support ticket for you with id CAS-85229-N2T9YS, in order to investigate this further for you. I will update you trough the case as soon as I have information for you.
Thank you for using Infragistics Components.
So it looks like I was wrong. This is a bug which still exists in the Excel library, but it is actually already submitted (bug id 99854). I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.