Exontrol’s
new exGrid control an easy-to-implement grid control, provides swift and
robust performance and a wide range of formatting features that distinguish it
from other grids. It perfectly combines the exTree features with the very
popular exEditors library. The object model is rich, intuitive and flexible.
The exGrid loads, edits and displays your hierarchical or tabular data. Here's
the list of supported properties and methods:
| | Name | Description | |
| | AllowCopyTemplate | Specifies whether the Shift + Ctrl + Alt + Insert sequence copies the control's content to the clipboard, in template form. | |
| | AllowGroupBy | Indicates whether the control supports Group-By view. | |
| | AllowSelectNothing | Specifies whether the current selection is erased, once the user clicks outside of the items section. | |
| | AllowUndoRedo | Enables or disables the Undo/Redo feature. | |
| | AnchorFromPoint | Retrieves the identifier of the anchor from point. | |
| | Appearance | Retrieves or sets the control's appearance. | |
| | ApplyFilter | Applies the filter. | |
| | ASCIILower | Specifies the set of lower characters. | |
| | ASCIIUpper | Specifies the set of upper characters. | |
| | AttachTemplate | Attaches a script to the current object, including the events, from a string, file, a safe array of bytes. | |
| | AutoDrag | Gets or sets a value that indicates the way the component supports the AutoDrag feature. | |
| | AutoEdit | Specifies whether the cell is edited once that it is focused. | |
| | AutoSearch | Enables or disables the incremental searching feature. | |
| | BackColor | Retrieves or sets a value that indicates the control's background color. | |
| | BackColorAlternate | Specifies the background color used to display alternate items in the control. | |
| | BackColorHeader | Specifies the header's background color. | |
| | BackColorLevelHeader | Specifies the multiple levels header's background color. | |
| | BackColorLock | Retrieves or sets a value that indicates the control's background color for the locked area. | |
| | BackColorSortBar | Retrieves or sets a value that indicates the sort bar's background color. | |
| | BackColorSortBarCaption | Returns or sets a value that indicates the caption's background color in the control's sort bar. | |
| | Background | Returns or sets a value that indicates the background color for parts in the control. | |
| | BeginUpdate | Maintains performance when items are added to the control one at a time. This method prevents the control from painting until the EndUpdate method is called. | |
| | CanRedo | Retrieves a value that indicates whether the control can perform a Redo operation. | |
| | CanUndo | Retrieves a value that indicates whether the control can perform an Undo operation. | |
| | CauseValidateValue | Returns or sets a value that determines whether the ValidateValue event occurs before the user changes the cell's value. | |
| | CheckImage | Retrieves or sets a value that indicates the image used by cells of checkbox type. | |
| | ClearFilter | Clears the filter. | |
| | ColumnAutoResize | Returns or sets a value indicating whether the control will automatically size its visible columns to fit on the control's client width. | |
| | ColumnFromPoint | Retrieves the column from point. | |
| | Columns | Retrieves the control's column collection. | |
| | ColumnsAllowSizing | Retrieves or sets a value that indicates whether a user can resize columns at run-time. | |
| | ColumnsFloatBarSortOrder | Specifies the sorting order for the columns being shown in the control's columns floating panel. | |
| | ColumnsFloatBarVisible | Retrieves or sets a value that indicates whether the the columns float bar is visible or hidden. | |
| | ConditionalFormats | Retrieves the conditional formatting collection. | |
| | ContinueColumnScroll | Retrieves or sets a value indicating whether the control will automatically scroll the visible columns by pixel or by column width. | |
| | Copy | Copies the control's content to the clipboard, in the EMF format. | |
| | CopyTo | Exports the control's view to an EMF file. | |
| | CountLockedColumns | Retrieves or sets a value indicating the number of locked columns. A locked column is not scrollable. | |
| | DataSource | Retrieves or sets a value that indicates the data source for object. | |
| | DefaultEditorOption | Specifies a default option for an editor. | |
| | DefaultItemHeight | Retrieves or sets a value that indicates the default item height. | |
| | Description | Changes descriptions for control objects. | |
| | DetectAddNew | Specifies whether the control detects when a new record is added to the bounded recordset. | |
| | DetectDelete | Specifies whether the control detects when a record is deleted from the bounded recordset. | |
| | DiscardValidateValue | Cancels the current validation process, and restores back the modified cells. | |
| | DrawGridLines | Retrieves or sets a value that indicates whether the grid lines are visible or hidden. | |
| | Edit | Edits the focused cell. | |
| | EditClose | Closes the current editor. | |
| | Editing | Specifies the window's handle of the built-in editor while the control is running in edit mode. | |
| | EditingText | Specifies the caption of the editor during editing. | |
| | Enabled | Enables or disables the control. | |
| | EndBlockUndoRedo | Ends recording the UI operations and adds the undo/redo operations as a block, so they all can be restored at once, if Undo method is performed. | |
| | EndUpdate | Resumes painting the control after painting is suspended by the BeginUpdate method. | |
| | EnsureOnSort | Specifies whether the control ensures that the focused item fits the control's client area, when the user sorts the items. | |
| | EnsureVisibleColumn | Scrolls the control's content to ensure that the column fits the client area. | |
| | EventParam | Retrieves or sets a value that indicates the current's event parameter. | |
| | ExecuteTemplate | Executes a template and returns the result. | |
| | ExpandOnDblClick | Specifies whether the item is expanded or collapsed if the user dbl clicks the item. | |
| | ExpandOnKeys | Specifies a value that indicates whether the control expands or collapses a node when user presses arrow keys. | |
| | ExpandOnSearch | Expands items automatically while user types characters to search for a specific item. | |
| | Export | Exports the control's data to a CSV format. | |
| | FilterBarBackColor | Specifies the background color of the control's filter bar. | |
| | FilterBarCaption | Specifies the filter bar's caption. | |
| | FilterBarDropDownHeight | Specifies the height of the drop down filter window proportionally with the height of the control's list. | |
| | FilterBarFont | Retrieves or sets the font for control's filter bar. | |
| | FilterBarForeColor | Specifies the foreground color of the control's filter bar. | |
| | FilterBarHeight | Specifies the height of the control's filter bar. If the value is less than 0, the filterbar is automatically resized to fit its description. | |
| | FilterBarPrompt | Specifies the caption to be displayed when the filter pattern is missing. | |
| | FilterBarPromptColumns | Specifies the list of columns to be used when filtering using the prompt. | |
| | FilterBarPromptPattern | Specifies the pattern for the filter prompt. | |
| | FilterBarPromptType | Specifies the type of the filter prompt. | |
| | FilterBarPromptVisible | Shows or hides the filter prompt. | |
| | FilterCriteria | Retrieves or sets the filter criteria. | |
| | FilterInclude | Specifies the items being included after the user applies the filter. | |
| | FocusColumnIndex | Specifies the index of focused column. | |
| | Font | Retrieves or sets the control's font. | |
| | ForeColor | Retrieves or sets a value that indicates the control's foreground color. | |
| | ForeColorHeader | Specifies the header's foreground color. | |
| | ForeColorLock | Retrieves or sets a value that indicates the control's foreground color for the locked area. | |
| | ForeColorSortBar | Retrieves or sets a value that indicates the sort bar's foreground color. | |
| | FormatABC | Formats the A,B,C values based on the giving expression and returns the result. | |
| | FormatAnchor | Specifies the visual effect for anchor elements in HTML captions. | |
| | FreezeEvents | Prevents the control to fire any event. | |
| | FullRowSelect | Enables full-row selection in the control. | |
| | GetItems | Gets the collection of items into a safe array, | |
| | GridLineColor | Specifies the grid line color. | |
| | GridLineStyle | Specifies the style for gridlines in the list part of the control. | |
| | Group | Forces the control to do a regrouping of the columns. | |
| | GroupUndoRedoActions | Groups the next to current Undo/Redo Actions in a single block. | |
| | HasButtons | Adds a button to the left side of each parent item. The user can click the button to expand or collapse the child items as an alternative to double-clicking the parent item. | |
| | HasButtonsCustom | Specifies the index of icons for +/- signs when the HasButtons property is exCustom. | |
| | HasLines | Enhances the graphic representation of a grid control's hierarchy by drawing lines that link child items to their corresponding parent item. | |
| | HeaderAppearance | Retrieves or sets a value that indicates the header's appearance. | |
| | HeaderEnabled | Enables or disables the control's header. | |
| | HeaderHeight | Retrieves or sets a value indicating the control's header height. | |
| | HeaderSingleLine | Specifies whether the control resizes the columns header and wraps the captions in single or multiple lines. | |
| | HeaderVisible | Retrieves or sets a value that indicates whether the the grid's header is visible or hidden. | |
| | HideSelection | Returns a value that determines whether selected item appears highlighted when a control loses the focus. | |
| | HotBackColor | Retrieves or sets a value that indicates the hot-tracking background color. | |
| | HotForeColor | Retrieves or sets a value that indicates the hot-tracking foreground color. | |
| | HTMLPicture | Adds or replaces a picture in HTML captions. | |
| | hWnd | Retrieves the control's window handle. | |
| | HyperLinkColor | Specifies the hyperlink color. | |
| | Images | Sets the control's image list at runtime. | |
| | ImageSize | Retrieves or sets the size of icons the control displays. | |
| | Indent | Retrieves or sets the amount, in pixels, that child items are indented relative to their parent items. | |
| | IsGrouping | Indicates whether the control is grouping the items. | |
| | ItemFromPoint | Retrieves the item from point. | |
| | Items | Retrieves the control's item collection. | |
| | ItemsAllowSizing | Retrieves or sets a value that indicates whether a user can resize items at run-time. | |
| | Layout | Saves or loads the control's layout, such as positions of the columns, scroll position, filtering values. | |
| | LinesAtRoot | Link items at the root of the hierarchy. | |
| | LoadXML | Loads an XML document from the specified location, using MSXML parser. | |
| | MarkSearchColumn | Retrieves or sets a value that indicates whether the searching column is marked or unmarked | |
| | MarkTooltipCells | Retrieves or sets a value that indicates wheter the control marks the cells that have tooltips. | |
| | MarkTooltipCellsImage | Specifies a value that indicates the index of icon being displayed in the cells that have tooltips. | |
| | OLEDrag | Causes a component to initiate an OLE drag/drop operation. | |
| | OLEDropMode | Returns or sets how a target component handles drop operations | |
| | Picture | Retrieves or sets a graphic to be displayed in the control. | |
| | PictureDisplay | Retrieves or sets a value that indicates the way how the graphic is displayed on the control's background | |
| | PictureDisplayLevelHeader | Retrieves or sets a value that indicates the way how the graphic is displayed on the control's header background. | |
| | PictureLevelHeader | Retrieves or sets a graphic to be displayed in the control's header when multiple levels is on. | |
| | PutItems | Adds an array of integer, long, date, string, double, float, or variant arrays to the control. | |
| | RadioImage | Retrieves or sets a value that indicates the image used by cells of radio type. | |
| | RClickSelect | Retrieves or sets a value that indicates whether an item is selected using right mouse button. | |
| | ReadOnly | Retrieves or sets a value that indicates whether the control is readonly. | |
| | Redo | Redoes the next action in the control's Redo queue. | |
| | RedoListAction | Lists the Redo actions that can be performed in the control. | |
| | RedoRemoveAction | Removes the first redo actions that can be performed in the control. | |
| | Refresh | Refreshes the control's content. | |
| | RemoveSelection | Removes the selected items (including the descendents) | |
| | ReplaceIcon | Adds a new icon, replaces an icon or clears the control's image list. | |
| | RightToLeft | Indicates whether the component should draw right-to-left for RTL languages. | |
| | SaveXML | Saves the control's content as XML document to the specified location, using the MSXML parser. | |
| | Scroll | Scrolls the control's content. | |
| | ScrollBars | Returns or sets a value that determines whether the control has horizontal and/or vertical scroll bars. | |
| | ScrollButtonHeight | Specifies the height of the button in the vertical scrollbar. | |
| | ScrollButtonWidth | Specifies the width of the button in the horizontal scrollbar. | |
| | ScrollBySingleLine | Retrieves or sets a value that indicates whether the control scrolls the lines to the end. If you have at least a cell that has SingleLine false, you have to check the ScrollBySingleLine property.. | |
| | ScrollFont | Retrieves or sets the scrollbar's font. | |
| | ScrollHeight | Specifies the height of the horizontal scrollbar. | |
| | ScrollOrderParts | Specifies the order of the buttons in the scroll bar. | |
| | ScrollPartCaption | Specifies the caption being displayed on the specified scroll part. | |
| | ScrollPartCaptionAlignment | Specifies the alignment of the caption in the part of the scroll bar. | |
| | ScrollPartEnable | Indicates whether the specified scroll part is enabled or disabled. | |
| | ScrollPartVisible | Indicates whether the specified scroll part is visible or hidden. | |
| | ScrollPos | Specifies the vertical/horizontal scroll position. | |
| | ScrollThumbSize | Specifies the size of the thumb in the scrollbar. | |
| | ScrollToolTip | Specifies the tooltip being shown when the user moves the scroll box. | |
| | ScrollWidth | Specifies the width of the vertical scrollbar. | |
| | SearchColumnIndex | Retrieves or sets a value indicating the column's index that is used for auto search feature. | |
| | SelBackColor | Retrieves or sets a value that indicates the selection background color. | |
| | SelBackMode | Retrieves or sets a value that indicates whether the selection is transparent or opaque. | |
| | SelectByDrag | Specifies whether the user selects multiple items by dragging. | |
| | SelectColumnIndex | Retrieves or sets a value that indicates the index of the selected column, if the FullRowSelect property is False. | |
| | SelectColumnInner | Retrieves or sets a value that indicates the index of the inner cell that's selected. | |
| | SelectOnRelease | Indicates whether the selection occurs when the user releases the mouse button. | |
| | SelForeColor | Retrieves or sets a value that indicates the selection foreground color. | |
| | ShowFocusRect | Retrieves or sets a value indicating whether the control draws a thin rectangle around the focused item. | |
| | ShowImageList | Specifies whether the control's image list window is visible or hidden. | |
| | ShowLockedItems | Retrieves or sets a value that indicates whether the locked/fixed items are visible or hidden. | |
| | ShowToolTip | Shows the specified tooltip at given position. | |
| | SingleSel | Retrieves or sets a value that indicates whether the control supports single or multiple selection. | |
| | SingleSort | Returns or sets a value that indicates whether the control supports sorting by single or multiple columns. | |
| | SortBarCaption | Specifies the caption being displayed on the control's sort bar when the sort bar contains no columns. | |
| | SortBarColumnWidth | Specifies the maximum width a column can be in the control's sort bar. | |
| | SortBarHeight | Retrieves or sets a value that indicates the height of the control's sort bar. | |
| | SortBarVisible | Retrieves or sets a value that indicates whether control's sort bar is visible or hidden. | |
| | SortOnClick | Retrieves or sets a value that indicates whether the control sorts automatically the data when the user click on column's caption. | |
| | StartBlockUndoRedo | Starts recording the UI operations as a block of undo/redo operations. | |
| | Statistics | Gives statistics data of objects being hold by the control. | |
| | Template | Specifies the control's template. | |
| | TemplateDef | Defines inside variables for the next Template/ExecuteTemplate call. | |
| | TemplatePut | Defines inside variables for the next Template/ExecuteTemplate call. | |
| | TooltipCellsColor | Retrieves or sets a value that indicates the color used to make the cells that have tooltips. | |
| | ToolTipDelay | Specifies the time in ms that passes before the ToolTip appears. | |
| | ToolTipFont | Retrieves or sets the tooltip's font. | |
| | ToolTipMargin | Defines the size of the control's tooltip margins. | |
| | ToolTipPopDelay | Specifies the period in ms of time the ToolTip remains visible if the mouse pointer is stationary within a control. | |
| | ToolTipWidth | Specifies a value that indicates the width of the tooltip window, in pixels. | |
| | ToTemplate | Generates the control's template. | |
| | TreeColumnIndex | Retrieves or sets a value that indicates the index of column where the hierarchy lines are displayed. | |
| | UnboundHandler | Specifies the control's unbound handler. | |
| | Undo | Performs the last Undo operation. | |
| | UndoListAction | Lists the Undo actions that can be performed in the control. | |
| | UndoRedoQueueLength | Gets or sets the maximum number of Undo/Redo actions that may be stored to the control's queue. | |
| | UndoRemoveAction | Removes the last the undo actions that can be performed in the control. | |
| | Ungroup | Ungroups the columns, if they have been previously grouped. | |
| | UseTabKey | Retrieves or sets a value indicating whether the control uses tab key for changing the searching column. | |
| | UseVisualTheme | Specifies whether the control uses the current visual theme to display certain UI parts. | |
| | Version | Retrieves the control's version. | |
| | ViewMode | Specifies how the data is displayed on the control's view. | |
| | ViewModeOption | Specifies options for the control's view mode. | |
| | VirtualMode | Specifies a value that indicates whether the control is running in the virtual mode. | |
| | VisualAppearance | Retrieves the control's appearance. | |
| | VisualDesign | Invokes the control's VisualAppearance designer. | |
| | WordFromPoint | Retrieves the word from the cursor. | |
