Spread Windows Forms 7.0 Product Documentation
Getting Information of a Clicked Cell
Support Options
Spread Windows Forms 7.0 Product Documentation > Developer's Guide > Customizing Interaction in Cells > Using Visible Indicators in the Cell > Getting Information of a Clicked Cell

Glossary Item Box

You can get row and column index information of 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 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 which have been specified by row and column indexes. When GetCellRectangle method in 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 if those headers are clicked or not. 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.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.