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
85
Calculated rows in ultragrid
posted

 

I understand that we can have calculated columns in ultragrid. Using the CalcManager can we have a calculated row without adding summary rows???

E.g. Rows 3 and 5 are calculated. I do not want to flip the rows and columns in the grid (the schema is a bit more complicated)


1 2 3 4
Data 1 0 3 5 6
Data 2 4 3 1 2
Data 3 (Data 1 + Data 2) 4 6 6 8
Data 4 1 4 2 8
Data 5 (Ave(Data 1, Data4)) 0.5 3.5 3.5 7
Parents
No Data
Reply
  • 469350
    Offline posted

    Hi,

    You can allow a formula to a grid column (the whole column) or to a summary. You cannot apply a formula to a specific cell, so you cannot do what you want here with UltraCalcmanager formulas.

    But what you could do is use add a couple of extra rows into your data source with no values and then populate those values in the InitializeRow event of the grid and perform the calculations yourself in code.

Children
No Data