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