DependencyMap breaks down with dynamic variables in CalcEngine

May 23, 2012 at 4:00 PM

I'm using CalcEngine to Financial statements. The chart of accounts, formulas and account balances come from the database. The formulas have dependency between them thus a network of formulas.

CalcEngine works fine as long as I don't handle ResolveVariable events -- I tried to assign default values if the database doesn't have values.  CalcEngine's dependencyMap seems to be breaking down if I tried to resolve the type and values of the variables at runtime. Is there a workaround/fix for this issue.

Thanks much. It's a great tool.

 

Siva