Gets the new width of the column.
Syntax
Visual Basic (Declaration) | |
---|
Public ReadOnly Property Width As Integer |
C# | |
---|
public int Width {get;} |
Property Value
Integer number of pixels in the width of the column
Example
This example cancels the change if the width is less than that specified.
C# | Copy Code |
---|
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;
}
}
}
}
|
Visual Basic | Copy Code |
---|
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
|
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also