Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
55
More Complex Formulas with References
posted

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