Total rows and Total Col

[hpd71]

Hi,

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.

Thanks

---

This message was posted using Aspose.Live 2 Forum

[amjad.sahi]

Hi,

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.

For locking cells, row or column, please check:

Protecting Worksheets

Thank you.