Forums Ultimate UI for Windows Forms
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
Close
Olivier Girard
305
How to use variable ranges in WinCalcManager formulas?
posted

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

Parents
No Data
Reply
  • 469350
    Offline posted

    Hi 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.

Children