Hi All, I am using the UltraControls v20.2 and I have a simple VB form in Visual Studio with an UltraCalcManager and a series of UltraCurrencyEditors and UltraNumericEditors. The Editors are enabled for input and some of the editors have formulas defined using the values of the other editors. For example:
CurrencyEditor5 = (CurrencyEditor1 * NumericEditor3) / 100
CurrencyEditor6 = (CurrencyEditor2 * NumericEditor4) / 100
CurrencyEditor7 = CurrencyEditor1 - CurrencyEditor5
CurrencyEditor8 = CurrencyEditor2 - CurrencyEditor6
CurrencyEditor11 = CurrencyEditor7 + CurrencyEditor8
Everything seems to work except when I change the value of either of the NumericEditors. This doesn't update CurrencyEditor11 as I would expect. It doesn't appear to change the value at all.
If I modify the other CurrencyEditors this changes the dependent editors and also CurrencyEditor11. But if I change the NumericEditors, although their directly dependent CurrencyEditors (5 and 6) are updated as well and the next level dependent CurrencyEditors (7 and 8), the CurrencyEditor11 value doesn't change. Is there an explanation for this behaviour?
I've tried using the valueChanged event on the NumericEditor to run the Refresh method in CurrencyEditor11, but this doesn't seem to have any effect. Is there another method I can run to publish the change in CurrencyEditor11?
Thanks,
Paul.
OK Mike, thanks.
Yeah, I found that replacing the NumericEditors with CurrencyEditors made no difference. So I don't think it has anything to do with the particular controls being used. I suspect it's something to do with the formulas themselves. Both CurrencyEditor5 and CurrencyEditor7 rely on the value of CurrencyEditor1. And since CurrencyEditor7 also relies on the value of CurrencyEditor5, I think that may be creating an ambiguity in the order in which the values need to be calculated. That's my best guess after a brief look at the issue. I don't see any way to work around that. Maybe there is some other way to do the calculations you need by introducing some other intermediate steps or something. It's hard to wrap my head around.
Hi Divya,
Thank you for the quick response and for looking into the problem. Ideally I would like to be able to work around the problem. Even replacing the NumericEditors with CurrencyEditors using a Mask format of nnnnnn doesn't seem to work. Perhaps it's something to do with the calculation of CurrencyEditor5?
But it's strange, changing the value of CurrencyEditor1 and CurrencyEditor2 changes the value of CurrencyEditor11. But changing the value of NumericEditor3 (even if I replace this with another CurrencyEditor) has no effect on CurrencyEditor11.
Regards,
Hello Paul,
Thank you for your post. I am able to reproduce the issue you described. I have logged this behavior into our internal bug tracking system for further investigation.
I have opened a private case CAS-212315-M0K6L3 for you so that I can link it to this development issue 272927. This way you will be notified automatically when the dev issue is updated. You can access the private case here: www.infragistics.com/.../support-activity>
Let me know if you have any questions regarding this matter.