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

In This Topic
    Cancel Property (ColumnWidthChangingEventArgs)
    In This Topic
    Gets or sets whether to cancel the column width change.
    Public Property Cancel As Boolean
    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
    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
    End If
    End Sub
    See Also