SSpread.TypeComboBoxAutoSearch Property
Set the search type when searching for list items by character input in a combo box type cell.
Only valid for cells with the CellType property set to $CellTypeComboBox (combo box type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.
Specify the following values. The initial value is $TypeComboBoxAutoSearchSingleChar .
| Constant | Value | Explanation |
|---|---|---|
| $TypeComboBoxAutoSearchNone | 0 | Not specified |
| $TypeComboBoxAutoSearchSingleChar | 1 | specify 1 character The list item of "1 entered character = the first character of the list item" is selected. If there is no matching item in the list, it will not be selected. |
| $ TypeComboBoxAutoSearchMultipleChar | 2 | Specify multiple characters A list item that matches with frontwards multiple characters input will be selected. If there is no matching item in the list, it will not be selected. |
| $ TypeComboBoxAutoSearchSingleCharGreater | 3 | Specify one character (search for subsequent characters as well) The list item of "1 entered character = the first character of the list item" is selected. If there is no match in the list, search for the next character ( b for a ). |
Setting this property to something other than $TypeComboBoxAutoSearchNone allows the user to select a combo box list item by typing on the keyboard.
This feature is enabled only if the TypeComboBoxEditable property is $FALSE .
This property is subject to property inheritance of combo box type cells. Notes on property inheritance of combo box type cells
Example of searching buy character input
list item
| aaa |
|---|
| abc |
| bbb |
| bcd |
| xyz |
$TypeComboBoxAutoSearchSingleChar - single character
| Key to enter | Selected item |
|---|---|
| a | aaa |
| b | bbb |
| c | not selected |
| a → a | aaa → abc |
| a → b | aaa → bbb |
$TypeComboBoxAutoSearchMultipleChar - specify multiple characters
| Key to enter | Selected item |
|---|---|
| a | aaa |
| b | bbb |
| c | not selected |
| a → a | aaa |
| a → b | aaa → abc |
$TypeComboBoxAutoSearchSingleCharGreater - specify one character (also search for subsequent characters)
| Key to enter | Selected item |
|---|---|
| a | aaa |
| b | bbb |
| c | xyz |
| a → a | aaa → abc |
| a → b | aaa → bbb |
This is an example of operation from the unselected state. When an item is selected, search after it.
Example of use
Col = 3;
Row = 2;
CellType = $ CellTypeComboBox;
TypeComboBoxAutoSearch = $ TypeComboBoxAutoSearchSingleChar;
TypeComboBoxList = "aaa \ tabc \ tbbb \ tbcd \ txyz";
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeComboBox;
TypeComboBoxAutoSearch = $TypeComboBoxAutoSearchMultipleChar;
BlockMode = $FALSE;
Related item
CellType , TypeComboBoxEditable property