Hi
I would like to use the WinCalcManager to compute formulas containing (long) sequences of number values as input.
e.g. the sum of the items of <channel1> containing 300 items:SUM(//channel1) meaning SUM(//[C0], //[C1], ..., //[C300])
Is there a simple way to define named references refferring to sequences or at least to define [C0] ... [C300] explicitely and use some kind of range notation in the formula (e.g. SUM(//[C0]://[C300]) )?
Thanks for help!olivier
Hi Olivier,
Olivier Girard said:is this already supported in 2007.2?
No, I'm pretty sure it was not supported in that version. So you will need to use the WinGrid or else upgrade to a newer version of NetAdvantage.
Also, you can't actually mix formulas from an Excel sheet and also controls on the form. The excel WorkSheet creates it's own calculation network and it's not the same network as the controls or an UltraCalcManager component. So any interaction between the two would need to be handled in code if you decide to go that route.
It would probably be pretty easy for us to add range reference support to the CalcManager component at some point in the future. So you might want to Submit a feature request to Infragistics
Hi Mike
thanks for the quick response!
Could you please provide an example, how the Excel references can be added to the CalcManager?I was not able to link the references so far - is this already supported in 2007.2?
olivier
The easiest way to do this would be to put all of the values in the range in a column in the WinGrid. Then you could refer to the WinGrid column as one entity.
There are no other range references available at this time.
Actually... after I posted this, I remember that there are also range references in in the Infragistics.Excel Worksheet. So you could do the same thing using an Worksheet in code instead of a grid.