I have added a blank row in top of the grid, which is fixed. I am using this to update all rows on cellchange. My problems are
- I want to exclude this top row from count in calcmanager formula
- I want to exclude this top row from sum in calcmanager formula
- Need to put an if condition to sum and count only checked rows (there is a checkbox column"select" )
Please suggest me, may i achive this useing WinCalcManager.
Thanks
There's no way to exclude asingle row like this from a CalcManager calculation. What you could do, though, is add a hidden, unbound column to the grid and populate this column with values copied from the "real" column, and just leave the one cell blank. Then perform your calculations on the hidden column so that the fixed row value is left out.
If I do the summary and/or count on a hidden column, where would it show (under which column) in the summary row?
Also, when doing calculations using CalcManager, can I specify some condition whithin the formulat to not include that row? If I need some way of identifying whether this row is the "New" row, I can add a hidden column for that.
shmuly said:If I do the summary and/or count on a hidden column, where would it show (under which column) in the summary row?
When you add the summary, you have the option to align it left, right, middle, or line it up with a column. This is independent of the formula or which column the sumary is actualyl calculating from.
shmuly said:Also, when doing calculations using CalcManager, can I specify some condition whithin the formulat to not include that row? If I need some way of identifying whether this row is the "New" row, I can add a hidden column for that.
No, there's no way for the CalcManager to ignore specific rows.