Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

PosNameTypeDescription
<2, 1>Columns ListMultivalue@TM delimited list of column headings
<2, 2>Column Settings ListMultivalue@TM delimited list of column settings
<2, 3>DataMultivalueCombo box data in ARRAY format; @TM delimited columns of data with @STM delimited rows
<2, 4>Master ColumnIntegerThe column containing the return values
<2, 5>AutofillBooleanIf true, then autofill is enabled
<2, 6>Case Sensitive AutofillBooleanIf true, then autofill is case sensitive
<2, 7>Number of Visible RowsIntegerThe number of viewable rows at a time
<2, 8>Fire OnOptionClickBooleanIf true, fire the OnOptionClick when user presses dropdown button
<2, 9>Filtered AutofillBooleanIf true, reduce the list to only those items that partially match the current contents
<2, 10>Show Dropdown ImmediatelyBoolean If true, shows the dropdown as soon as user enters edit mode
<2, 11>LIST FormatBooleanIf true, then the data is in LIST format and not ARRAY format
<2, 12>Autofill Column(s)IntegerThe column(s) against which autofill is performed
<2, 13>Hide When EmptyBooleanIf true, then the dropdown hides when the user clears the cell
<2, 14>Normal NavigationBooleanIf true, then the up/down/pgup/pgdown keys navigate to other cells when the drop down is hidden
<2, 15>Show Only When EmptyBooleanIf true and Show Immediately is true, then the dropdown only shows immediately when the cell's contents are empty
<2, 16>No Show AutofillBooleanIf true, then the drop down does not appear during autofill
<2, 17>Clear Selection on Backspace or DeleteBooleanIf true, then the currently selected drop down item will be deselected when the user presses backspace or delete
<2, 18>Show Popup While Read OnlyBooleanIf true, then the user can click the drop down button and select an item but still cannot type in the cell
<2, 19>Show Popup While NavigatingBooleanIf true and Normal Navigation is false, then pressing up/down/pgup/pgdown shows the popup
<2, 20>Always Tab Out on EnterBooleanIf true, then pressing Enter will tab out of the cell even if the drop down was visible
<2, 21>Dropdown ThresholdInteger The number of rows, at minimum, that must be visible within the dropdown for it to appear below the cell
<2, 22>Dropdown FontFontThe font used to render the drop down items
<2, 23>Limit to ListBooleanDetermines if the cell's contents must be limited to the values in the dropdown.
<2, 24>Match AnywhereBooleanDetermines if autofill will also match what you type to any substrings within text, instead of just at the beginning of it.
<2, 25>Row HeightInteger The height of each row in the dropdown
<2, 26>Force Cell UpdateBooleanDetermines if the cell should be updated immediately after the user clicks an item in the dropdown (Added in 4.1.20)

The Combo cell type can be used for quickly selecting from a list of values. This style will show a dropdown list when the user edits the cell or presses the drop down button. Set the Columns List parameter if you want headers above your columns or omit it to have no headers.

...

The Match Anywhere value modifies autofill behavior slightly. Normally, as the user types, the typed text is matched against all autofill columns (See value <2, 12> above) to find any strings that begin with the same text. When this is set to 1, however, the typed text is allowed to be found anywhere within a string. When this is enabled, note that autofill will only help the user find matching rows but will not autofill the text in the cell unless the match is at the beginning of a string.

The Row Height value customizes the height of each row in the combo dropdown.

The Force Cell Update value determines if the table should immediately force the cell to update when the user clicks an item in the combo box dropdown. This feature is only available in version 4.1.20 or later.

Button Backgrounds

Fields <3> - <7> establish custom colors for Option Buttons, Combo Box buttons, and Push Buttons. Therefore, they only apply to cell's of type "Option", "Combo", and "Push Button". The backgrounds can be set to any valid Color Fill value. The foreground colors can be set to any valid Color value.

...