Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ColumnWidthChangingEventArgs Class / Cancel Property
Example


In This Topic
    Cancel Property (ColumnWidthChangingEventArgs)
    In This Topic
    Gets or sets whether to cancel the column width change.
    Syntax
    'Declaration
     
    Public Property Cancel As Boolean
    'Usage
     
    Dim instance As ColumnWidthChangingEventArgs
    Dim value As Boolean
     
    instance.Cancel = value
     
    value = instance.Cancel
    public bool Cancel {get; set;}

    Property Value

    Boolean: true to cancel the change; false otherwise
    Example
    This example cancels the change if the width is less than that specified.
    private void fpSpread1_ColumnWidthChanging(object sender, FarPoint.Win.Spread.ColumnWidthChangingEventArgs e) {
    if (e.Header) {
    int i;
    for (i = 0; (i <= e.ColumnList.Count - 1; i++) 
    {
    e.View.Sheets(e.View.ActiveSheetIndex).RowHeader.Columns(i).BackColor = Color.PowderBlue;
    if ((e.Width <= 60)) 
    {
    e.Cancel = true;
    }
    }
    }
    }
    
    Private Sub FpSpread1_ColumnWidthChanging(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ColumnWidthChangingEventArgs)
    Handles FpSpread1.ColumnWidthChanging
    If e.Header Then
    Dim i As Integer
    For i = 0 To e.ColumnList.Count - 1
    e.View.Sheets(e.View.ActiveSheetIndex).RowHeader.Columns(i).BackColor = Color.PowderBlue
    If e.Width <= 60 Then
    e.Cancel = True
    End If
    Next
    End If
    End Sub
    
    See Also