Enumerations
2 real typelib enums (11 values) and 20 documented constant groups used across the LiteGrid Turbo ActiveX/COM grid control API
GridLines
Used with the GridLines property.
| Value | Name | Description |
|---|---|---|
| 0 | None | No grid lines |
| 1 | Horizontal | Horizontal lines only |
| 2 | Vertical | Vertical lines only |
| 3 | Both | Both horizontal and vertical |
Theme
Used with the Theme property.
| Value | Name | Description |
|---|---|---|
| 0 | Light | Light theme |
| 1 | Dark | Dark theme |
| 2 | Excel-Classic | Classic Excel appearance |
| 3 | High-Contrast | High-contrast accessibility theme |
SortOrder
Used with the Sort method.
| Value | Name | Description |
|---|---|---|
| 0 | Ascending | Sort A to Z / low to high |
| 1 | Descending | Sort Z to A / high to low |
SortMode
Used with the SortEx method.
| Value | Name | Description |
|---|---|---|
| 0 | Ascending | Ascending (case-sensitive) |
| 1 | Descending | Descending (case-sensitive) |
| 2 | AscendingNoCase | Ascending (case-insensitive) |
| 3 | DescendingNoCase | Descending (case-insensitive) |
| 4 | Natural | Natural sort (File1, File2, File10) |
FilterMode
Text filter modes for SetColumnFilter.
| Value | Name | Description |
|---|---|---|
| 0 | Contains | Text contains pattern |
| 1 | Equals | Text equals pattern exactly |
| 2 | StartsWith | Text starts with pattern |
| 3 | EndsWith | Text ends with pattern |
| 4 | Regex | Regular expression match |
NumericFilterMode
Numeric filter modes for SetColumnNumericFilter.
| Value | Name | Description |
|---|---|---|
| 5 | GreaterThan | Value greater than threshold |
| 6 | LessThan | Value less than threshold |
| 7 | GreaterOrEqual | Value greater than or equal to threshold |
| 8 | LessOrEqual | Value less than or equal to threshold |
| 10 | NotEqual | Value not equal to threshold |
ColumnType
Used with SetColumnType / GetColumnType.
| Value | Name | Description |
|---|---|---|
| 0 | Auto | Automatically detected |
| 1 | String | Text data |
| 2 | Integer | Whole numbers |
| 3 | Double | Floating-point numbers |
| 4 | Date | Date/time values |
| 5 | Boolean | True/False values |
| 6 | Checkbox | Rendered as checkbox |
| 7 | Progress | Rendered as progress bar |
| 8 | Currency | Formatted as currency |
ColumnAutoSize
Used with SetColumnAutoSize.
| Value | Name | Description |
|---|---|---|
| 0 | None | No auto-sizing |
| 1 | Content | Fit to cell content |
| 2 | Header | Fit to header text |
| 3 | Both | Fit to header and content |
| 4 | Fill | Fill remaining grid width |
IconLayout
Used with SetColumnIconLayout.
| Value | Name | Description |
|---|---|---|
| 0 | None | No icon display |
| 1 | IconOnly | Show icon only, no text |
| 2 | IconLeft | Icon to the left of text |
| 3 | IconRight | Icon to the right of text |
LiteGridBuiltinIcon Real Typelib Enum
This is one of the two real typelib enums in LiteGrid Turbo — the other is
LiteGridMatchEntry. Because it is a genuine
VBA-referenceable enum, registered-mode code can use its named constants directly
(lgIconCheck, etc.) once a reference to the LiteGrid Turbo type library exists;
reg-free/late-bound code must use the numeric values below, exactly as for every constant
group on this page. Every table on this page other than those two documents an informal
constant group — a documented value vocabulary that is not a typelib
enum, so VBA can never reference those names, in any mode.
Theme-aware, DPI-aware vector icons drawn without any external image file. Used with SetCellBuiltinIcon, SetColumnBuiltinIcon, SetColumnBuiltinIconMap, AddBuiltinIconThreshold, and SetColumnBuiltinIconDefault.
| Value | Constant | Glyph |
|---|---|---|
| 0 | lgIconCircle | Filled circle |
| 1 | lgIconCheck | Checkmark |
| 2 | lgIconCross | X / cross |
| 3 | lgIconWarning | Warning triangle |
| 4 | lgIconArrowUp | Up arrow |
| 5 | lgIconArrowDown | Down arrow |
| 6 | lgIconStar | Star |
| 7 | lgIconDiamond | Diamond |
LiteGridMatchEntry Real Typelib Enum
This is one of the two real typelib enums in LiteGrid Turbo — the other is
LiteGridBuiltinIcon. Registered-mode code with a
reference to the LiteGrid Turbo type library can use the named constants below directly; reg-free and
late-bound code must use the numeric values, exactly as for every informal constant group on this
page.
Type-ahead search behaviour when the grid has focus. Used with the MatchEntry
property. Type-ahead is separate from the find panel: keystrokes search the focused column and
move the focus row. Default lgMatchEntryComplete (2), which is the behaviour of every
release before the property existed. Changing the mode discards any prefix already typed, and a
value outside 0–2 is rejected.
| Value | Constant | Behaviour |
|---|---|---|
| 0 | lgMatchEntryOff | Off — keystrokes never move the focus row |
| 1 | lgMatchEntryFirstLetter | FirstLetter — only the last key counts, so repeating it cycles through matches |
| 2 | lgMatchEntryComplete | Complete — keystrokes accumulate into a prefix that resets after a short idle (default) |
SparklineType
Used with SetColumnSparkline.
| Value | Name | Description |
|---|---|---|
| 0 | None | No sparkline |
| 1 | Line | Line chart |
| 2 | Bar | Bar chart |
| 3 | WinLoss | Win/Loss chart |
FormatRuleType
Used with AddFormatRule for conditional formatting.
| Value | Name | Description |
|---|---|---|
| 0 | GreaterThan | Value greater than threshold |
| 1 | LessThan | Value less than threshold |
| 2 | Equal | Value equals threshold |
| 3 | Contains | Text contains threshold |
| 4 | Between | Value between two thresholds |
| 5 | Top10Percent | Top 10% of values |
| 6 | Bottom10Percent | Bottom 10% of values |
| 7 | Duplicate | Duplicate values |
| 8 | Unique | Unique values |
ValidationRuleType
Used with AddValidationRule for cell editing validation.
| Value | Name | Description |
|---|---|---|
| 0 | Required | Cell cannot be empty |
| 1 | MinLength | Minimum text length |
| 2 | MaxLength | Maximum text length |
| 3 | Regex | Must match regular expression |
| 4 | NumericRange | Value within numeric range |
| 5 | CustomList | Value must be in allowed list |
AggregateMode
Used with SetColumnAggregate for footer aggregation.
| Value | Name | Description |
|---|---|---|
| 0 | None | No aggregation |
| 1 | Sum | Sum of values |
| 2 | Average | Average of values |
| 3 | Count | Count of non-empty cells |
| 4 | Min | Minimum value |
| 5 | Max | Maximum value |
SelectionMode
Used with the SelectionMode property. Controls how selection highlighting and keyboard navigation behave.
| Value | Name | Description |
|---|---|---|
| 0 | Row | Click selects entire row. Up/Down arrow navigation. Shift+Click extends row range. Focus indicator: left accent bar. |
| 1 | Cell | Click selects single cell. All 4 arrow keys navigate cell-by-cell. Shift+Click/Arrow creates rectangular block selection. Tab moves between cells. Focus indicator: 2px cell border. |
| 2 | Column | Click selects entire column. Left/Right arrow navigation. Shift+Click extends column range. Ctrl+Click toggles columns. Focus indicator: top accent line. |
RowDensity
Used with the RowDensity property.
| Value | Name | Description |
|---|---|---|
| 0 | Compact | Compact row spacing |
| 1 | Normal | Normal row spacing (default) |
| 2 | Comfortable | Comfortable row spacing |
TextVAlign
Used with the TextVAlign property for vertical text alignment.
| Value | Name | Description |
|---|---|---|
| 0 | Top | Align text to top |
| 1 | Center | Center text vertically |
| 2 | Bottom | Align text to bottom |
CellFontStyle
Used with SetCellFontStyle.
| Value | Name | Description |
|---|---|---|
| 0 | Normal | Normal font weight and style |
| 1 | Bold | Bold text |
| 2 | Italic | Italic text |
| 3 | BoldItalic | Bold and italic text |
RendererType
Used with SetColumnRenderer for custom cell rendering.
| Value | Name | Description |
|---|---|---|
| 0 | Default | Standard text rendering |
| 1 | Checkbox | Checkbox control |
| 2 | ProgressBar | Progress bar visualization |
| 3 | Sparkline | In-cell sparkline chart |
| 4 | Button | Clickable button |
| 5 | Star | Star rating |
| 6 | Pill | Rounded status badge; map values to statuses with SetColumnPillMap |
DataMode
Used with the DataMode property.
| Value | Name | Description |
|---|---|---|
| 0 | Embedded | Data stored in the grid (default) |
| 1 | Virtual | Data supplied via callback on demand |
BenchmarkId
Used with RunBenchmark for performance testing.
| Value | Name | Description |
|---|---|---|
| 0 | Load | Data loading benchmark |
| 1 | Sort | Sorting benchmark |
| 2 | Paint | Rendering/painting benchmark |
| 3 | Memory | Memory usage benchmark |
| 4 | All | Run all benchmarks |