ActiveSheetChanging Event (GcSpreadSheet)

Occurs when the user changes the active sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Event ActiveSheetChanging As EventHandler(Of CancelEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of CancelEventArgs)
 
AddHandler instance.ActiveSheetChanging, handler

public event EventHandler<CancelEventArgs> ActiveSheetChanging

Event Data

The event handler receives an argument of type CancelEventArgs containing data related to this event. The following CancelEventArgs properties provide information specific to this event.

Property	Description
Cancel

Example

This example uses the ActiveSheetChanging event.

C#
VB.NET

gcSpreadSheet1.SheetCount = 2;

private void gcSpreadSheet1_ActiveSheetChanged(object sender, EventArgs e)
        {
            listBox1.Items.Add("ActiveSheetChanged");
        }

        private void gcSpreadSheet1_ActiveSheetChanging(object sender, System.ComponentModel.CancelEventArgs e)
        {
            listBox1.Items.Add("ActiveSheetChanging");
        }

gcSpreadSheet1.SheetCount = 2

Private Sub gcSpreadSheet1_ActiveSheetChanged(sender As Object, e As EventArgs) Handles gcSpreadSheet1.ActiveSheetChanged
        ListBox1.Items.Add("ActiveSheetChanged")
    End Sub

    Private Sub gcSpreadSheet1_ActiveSheetChanging(sender As Object, e As CancelEventArgs) Handles gcSpreadSheet1.ActiveSheetChanging
ListBox1.Items.Add("ActiveSheetChanging")
    End Sub

Requirements

Target Platforms: Windows Server 2012, Windows RT

Reference

GcSpreadSheet Class
GcSpreadSheet Members