Spread Windows Forms 12.0 Product Documentation
Cancel Property (RowHeightChangingEventArgs)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > RowHeightChangingEventArgs Class : Cancel Property
Gets or sets whether to cancel the row height change.
Syntax
'Declaration
 
Public Property Cancel As Boolean
'Usage
 
Dim instance As RowHeightChangingEventArgs
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 event if the size of the row is less than the specified value.
private void fpSpread1_RowHeightChanging(object sender, FarPoint.Win.Spread.RowHeightChangingEventArgs e) {
if (e.Header) 
{
int i;
for (i = 0; (i <= (e.RowList.Count - 1)); i++) 
{
e.View.Sheets(e.View.ActiveSheetIndex).ColumnHeader.Rows(i).BackColor = Color.PowderBlue;
if ((e.Height <= 60)) 
{
e.Cancel = true;
}
}
}
}
Private Sub FpSpread1_RowHeightChanging(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.RowHeightChangingEventArgs)
Handles FpSpread1.RowHeightChanging
If e.Header Then
Dim i As Integer
For i = 0 To e.RowList.Count - 1
e.View.Sheets(e.View.ActiveSheetIndex).ColumnHeader.Rows(i).BackColor = Color.PowderBlue
If e.Height <= 60 Then
e.Cancel = True
End If
Next
End If
End Sub
See Also

Reference

RowHeightChangingEventArgs Class
RowHeightChangingEventArgs Members