GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class : ActiveRowIndex Property |
'Declaration Public Property ActiveRowIndex As System.Integer
'Usage Dim instance As Worksheet Dim value As System.Integer instance.ActiveRowIndex = value value = instance.ActiveRowIndex
public System.int ActiveRowIndex {get; set;}
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