你想在点击列头和行头时选中哪些单元格呢,你可以在CellClick事件中来控制这一行为:
- Private Sub FpSpread1_CellClick(sender As System.Object, e As FarPoint.Win.Spread.CellClickEventArgs) Handles FpSpread1.CellClick
- Dim hitinfo As FarPoint.Win.Spread.HitTestInformation = FpSpread1.HitTest(e.X, e.Y)
- If hitinfo.Type = FarPoint.Win.Spread.HitTestType.ColumnHeader Then
- FpSpread1.ActiveSheet.ActiveColumnIndex = e.Column
- FpSpread1.ActiveSheet.ActiveRowIndex = 0
- e.Cancel = True
- ElseIf hitinfo.Type = FarPoint.Win.Spread.HitTestType.RowHeader Then
- FpSpread1.ActiveSheet.ActiveColumnIndex = 0
- FpSpread1.ActiveSheet.ActiveRowIndex = e.Row
- e.Cancel = True
- End If
- End Sub
复制代码 |