I am looking for a grid that will allow me to have a total row, and a total col values.
The catch is that the grid will vary in how many rows and cols it has, but the last row, and the last col, must always be a self calculating total value.
I would also need to be able to 'lock' the first and last cols and the last row. This would mean that the user could scroll the grid, but those cols/row would be locked and always visible.
Please use MaxDataRow, MaxDataColumn, MaxDataRowInColumn() members of Cells class. they will give you the farthest (the last) row/column index, so that you may get the crieteria of your matrix and put your summary rows/columns to it.