GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > SetActiveCell Method : SetActiveCell(Int32,Int32) Method |
'Declaration Public Overloads Sub SetActiveCell( _ ByVal row As System.Integer, _ ByVal column As System.Integer _ )
'Usage Dim instance As Worksheet Dim row As System.Integer Dim column As System.Integer instance.SetActiveCell(row, column)
gcSpreadSheet1.Sheets[0].SetActiveCell(5, 5); //gcSpreadSheet1.Sheets[0].SetActiveCell(2, 2, true); gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e) { listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveCell().ToString()); listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveColumn.ToString()); listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveColumnIndex); listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveRow.ToString()); listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveRowIndex); gcSpreadSheet1.Invalidate(); } private void gcSpreadSheet1_EnterCell(object sender, GrapeCity.Windows.SpreadSheet.UI.EnterCellEventArgs e) { listBox1.Items.Add(e.Column.ToString()); listBox1.Items.Add(e.Row.ToString()); } private void gcSpreadSheet1_LeaveCell(object sender, GrapeCity.Windows.SpreadSheet.UI.LeaveCellEventArgs e) { listBox1.Items.Add(e.Column.ToString()); listBox1.Items.Add(e.Row.ToString()); }
GcSpreadSheet1.Sheets(0).SetActiveCell(5, 5) 'GcSpreadSheet1.Sheets(0).SetActiveCell(2, 2, True) GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveCell().ToString()) ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveColumn.ToString()) ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveColumnIndex) ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveRow.ToString()) ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveRowIndex) GcSpreadSheet1.Invalidate() End Sub Private Sub GcSpreadSheet1_EnterCell(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EnterCellEventArgs) Handles GcSpreadSheet1.EnterCell ListBox1.Items.Add(e.Column.ToString()) ListBox1.Items.Add(e.Row.ToString()) End Sub Private Sub GcSpreadSheet1_LeaveCell(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.LeaveCellEventArgs) Handles GcSpreadSheet1.LeaveCell ListBox1.Items.Add(e.Column.ToString()) ListBox1.Items.Add(e.Row.ToString()) End Sub
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6