Hi,
I have a ultragrid that has a summary row. I also implemented hide/unhide row functionality as part of requirement. Now here the issue - when i hide the rows on gird it also affecting the summary row at the bottom i.e. .Sum is ignoring the values of hidden row its only calculating what’s visible on grid.
I also tried implementing ICustomSummaryCalculator but there also i'm not getting reference of hidden row!
Is there any setting/property to through i can tell summary field to consider hidden rows for sum?
Thanks
Venkatesh
I'm not sure exactly what you mean by "current" column. There is no "current" column in the grid. There's an ActiveCell and an ActiveRow. So maybe you want the column associated with the ActiveCell? If so, then you would get it like this:
this.ultraGrid1.ActiveCell.Column
Hi Mike,
How do I get a reference of current column? As I said in my previous post i've dynamic columns in grid.
To sum a column, you add a summary (of SummaryType.Formula) and the formula for that summary would look something like this:
"Sum([columnName])"
Thanks Mike, for your quick response!
While using CalcManager i landed into another issue :( - On my screen i've dynamic columns (i mean "Price0", "Price1" etc) -- How do i specify column in formula?
e.Layout.Bands[0].Columns["ColName"].Formula = "10 * [Col2]";
andalso I want formula to calculate the sum of same column.
Hi Venkatesh,
You could use a Formula summary instead of the built-in summary types.
Place an UltraCalcManager component on the form with the grid in order to use formulas.