FarPoint.Win.Spread
MaxLength Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > ComboBoxCellType Class : MaxLength Property


Gets or sets the maximum number of characters allowed in the combo box cell.

Syntax

Visual Basic (Declaration) 
Public Property MaxLength As Integer
Visual Basic (Usage)Copy Code
Dim instance As ComboBoxCellType
Dim value As Integer
 
instance.MaxLength = value
 
value = instance.MaxLength
C# 
public int MaxLength {get; set;}

Return Value

Integer number of characters

Example

This example limits the number of characters the user can enter when in edit mode.
C#Copy Code
FarPoint.Win.Spread.CellType.ComboBoxCellType cb = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
cb.Items = new string[] {"OneHundredThousand", "TwoHundredThousand", "ThreeHundredThousand"};
cb.ListWidth = 0;
cb.MaxLength = 10;
cb.Editable = true;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = cb;
fpSpread1.ActiveSheet.Columns[0].Width = 120;
Visual BasicCopy Code
Dim cb As New FarPoint.Win.Spread.CellType.ComboBoxCellType
cb.Items = New String() {"OneHundredThousand", "TwoHundredThousand", "ThreeHundredThousand"}
cb.ListWidth = 0
cb.MaxLength = 10
cb.Editable = True
FpSpread1.ActiveSheet.Cells(0, 0).CellType = cb
FpSpread1.ActiveSheet.Columns(0).Width = 120

Remarks

By default, the text in the edit field is limited to 255 characters and is left aligned. You can change the maximum number of characters allowed by setting this property.

See Also