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 :)