Free Support Forum - aspose.com

Total rows and Total Col

Aspose.Cells Product Family
#1

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
#2

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: http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/ProtectingWorksheet.html

Thank you.