Returning Information for a Clicked Cell

You can get row and column index information for cells that are clicked by accessing the CellClick event parameter e in the CellClickEventArgs class. You can get x- and y-coordinates as well from this parameter. You can implement a MouseDown event and from the x- and y-coordinates you can obtain row and column index information of the clicked cell. With the GetCellFromPixel method in the FpSpread class, you can get target cell information in the CellRange class format. You can obtain row and column information from respective members.

You can obtain cell information such as positions and sizes that have been specified by row and column indexes. When the GetCellRectangle method in the FpSpread class is called, specify the target row and column indexes. The cell coordinate information is returned in the .NET framework Rectangle format.

For headers, you can get row and column index information of clicked header cells by accessing CellClick event parameter e in the CellClickEventArgs class. You can detect whether the headers have been clicked. You can get x- and y-coordinates as well from this parameter. You can implement a MouseDown event and from the x- and y-coordinates you can obtain row and column index information of the clicked header cell.

With the GetColumnHeaderCellFromPixel method in the SpreadView class, you can get target cell information in the CellRange class format for column cells. You can obtain row and column information in column headers from respective members. In the case of row header cells, call the GetRowHeaderCellFromPixel method.