| FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > ComboBoxCellType Class : AutoSearch Property |
'Declaration Public Property AutoSearch As AutoSearch
'Usage Dim instance As ComboBoxCellType Dim value As AutoSearch instance.AutoSearch = value value = instance.AutoSearch
public AutoSearch AutoSearch {get; set;}
This property allows the user to type one or more characters to scroll to an item in the list of a combo box.
When set, the control automatically searches through the items in the drop-down list for an item that matches the user input based on the setting for the search. For example, if you set it to single character, it finds the item based on the first character the user types. When it finds a matching item, it scrolls to that item and places that value in the cell. Refer to the FarPoint.Win.AutoSearch enumerations for more details on the possible settings for this property. Typing a character initiates a search for the first item that begins with that character. If the item found is not visible in the list, the control scrolls to the first item that matches that character or characters. The control highlights the found item.
The search is case insensitive.
If the search character is not found and the setting is SingleCharacter, no item is highlighted.
If the setting is MultipleCharacter, the selection highlighting moves to the closest available match for the search string as the characters are entered (for example, to highlight "Variegated" type "var"). If none of the items begin with the first character entered, the control does not scroll the list.
If the setting is SingleGreaterThan, the control highlights the next greater item if the search character is not found. For example, the first item starting with the letter "g" will be highlighted if the user searched for the letter "f" and none of the items begin with "f". If there is a match, and you type the key repeatedly, the search iterates through all the items that match.
For example, assume the control displays five rows and this property is set to MultipleCharacter. List item "Willow Springs" is in row 10 and "Wilmington" is in row 20. When you type the letter "w", the list scrolls to "Willow Springs". When you type the letters "i" and then "l", nothing changes. If the fourth letter you type is "m", the list will scroll to "Wilmington". If the fourth letter you type is "z" (no match is found), the list scrolls so that the first row is the top row in the list.
FarPoint.Win.Spread.CellType.ComboBoxCellType cmbocell = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); cmbocell.Items = (new String[] {"January", "February", "March", "April", "May", "June"}); cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows; cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter; cmbocell.Editable = true; cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left; cmbocell.ListOffset = 20; cmbocell.ListWidth = 0; cmbocell.MaxDrop = 4; fpSpread1.Sheets[1].Cells[2,2].CellType = cmbocell;
Dim cmbocell As New FarPoint.Win.Spread.CellType.ComboBoxCellType() cmbocell.Items = (new String() {"January", "February", "March", "April", "May", "June"}) cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter cmbocell.Editable = True cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left cmbocell.ListOffset = 20 cmbocell.ListWidth = 0 cmbocell.MaxDrop = 4 fpSpread1.Sheets(1).Cells(2,2).CellType = cmbocell
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10