Table of Contents

Options reference

TTMSFNCDataGrid groups most behavior switches under Options. Use the task guides for workflow-level setup, and use this page when you need to find the option group that controls a specific part of the grid.

Option groups

Use task guides for workflow setup; use this reference when you need to locate the option group that controls a specific behavior.

// Typical multi-feature setup: filtering + sorting + clipboard
Grid.Options.Filtering.Enabled          := True;
Grid.Options.Sorting.Enabled            := True;
Grid.Options.Clipboard.AllowRowGrow     := True;
Grid.Options.Banding.Enabled            := True;
Grid.Options.Banding.NormalRowCount     := 1;
Grid.Options.Banding.BandRowCount       := 1;
Option path API class Use for
Options.Banding TTMSFNCDataGridBandingOptions Alternating row bands with configurable normal and band row counts.
Options.Clipboard TTMSFNCDataGridClipboardOptions Copy, cut, paste, row/column growth, read-only paste handling, and paste actions.
Options.Column TTMSFNCDataGridColumnOptions Column-level defaults such as stretching and fixed-cell check behavior.
Options.Row TTMSFNCDataGridRowOptions Row-level defaults, including stretching behavior.
Options.Column.Stretching, Options.Row.Stretching TTMSFNCDataGridStretchingOptions Stretch enablement, stretch mode, range, range type, and target index for column and row stretching.
Options.Selection TTMSFNCDataGridSelectionOptions Selection mode, range style, fixed-cell selection display, and AutoFill.
Options.Keyboard TTMSFNCDataGridKeyboardOptions Arrow, Enter, Tab, Home, End, Insert, Delete, find, replace, merge, and page-scroll keyboard behavior.
Options.Mouse TTMSFNCDataGridFixedCellSelection Fixed-cell selection modes such as row, column, range, and disjunct fixed-cell selection.
Options.Lookup TTMSFNCDataGridLookupOptions Type-ahead and incremental lookup, including case sensitivity and reset interval.
Options.Editing.AutoComplete TTMSFNCDataGridAutoCompleteOptions Auto-complete items, matching mode, and case sensitivity while editing.
Options.IO TTMSFNCDataGridIOOptions Import/export limits, offsets, delimiters, quote behavior, trim behavior, and export scale.
Data.Options.IO TTMSFNCDataGridDataIOOptions Headless data-layer import/export limits, offsets, delimiter, quote behavior, trim behavior, and export scale.
Options.IO.HTML TTMSFNCDataGridIOHTMLOptions HTML export colors, images, table attributes, header/footer text or files, image folder, XHTML, and special-character handling.
Options.Filtering TTMSFNCDataGridDataFilteringOptions Filter dropdowns, filter row, advanced filter dialog, multi-column filtering, trim behavior, and filter actions.
Options.Sorting TTMSFNCDataGridDataSortingOptions Sort enablement, direction, case sensitivity, format, and row.
Options.Grouping TTMSFNCDataGridDataGroupingOptions Grouping summaries, grouping headers, summary placement, merge behavior, auto-sort, and hidden columns.
Options.Calculations TTMSFNCDataGridDataCalculationOptions Whether hidden rows or hidden columns participate in calculations.
Options.Find TTMSFNCDataGridDataFindOptions Default starting row and column for find operations.
Options.URL TTMSFNCDataGridDataURLOptions URL auto-detection and automatic URL opening.

Older references to TTMSFNCDataGridFilteringOptions map to the current Options.Filtering group, whose public type is TTMSFNCDataGridDataFilteringOptions.

Data adapter

TTMSFNCDataGridDataAdapter is the base adapter class that connects a grid-facing adapter to a TTMSFNCDataGridData instance. Most applications use a concrete adapter such as the database adapter, but the base adapter is useful when building a custom data bridge.

Member Purpose
Active Enables or disables the adapter.
DataInstance Points the adapter at the data instance it should serve.

The grid exposes header and footer objects for visual grouping and paging.

API class Use for
TTMSFNCDataGridHeader Accessing visual grouping and the header button bar.
TTMSFNCDataGridHeaderVisualGrouping Group headers, drag/drop grouping, sorting from group headers, close indicators, and level indication styling.
Header.Bar Header bar visibility, size, fill, stroke, and buttons.
TTMSFNCDataGridButtons Header/footer button collections.
TTMSFNCDataGridButton Button text, hint, bitmap, width, state, hosted control, data fields, and click handling.
TTMSFNCDataGridFooter Footer visibility, size, fill, stroke, and paging area.
TTMSFNCDataGridFooterPaging Page selector, page info, navigation buttons, widths, and paging visibility.

Configuring common option groups

Use BeginUpdate and EndUpdate when changing several option groups together. This keeps the visual update predictable and avoids repeated layout work.

procedure TForm1.ConfigureGridOptions;
begin
  TMSFNCDataGrid1.BeginUpdate;
  try
    TMSFNCDataGrid1.Options.Banding.Enabled := True;
    TMSFNCDataGrid1.Options.Banding.NormalRowCount := 1;
    TMSFNCDataGrid1.Options.Banding.BandRowCount := 1;

    TMSFNCDataGrid1.Options.Selection.AutoFill := True;
    TMSFNCDataGrid1.Options.Clipboard.AllowRowGrow := True;
    TMSFNCDataGrid1.Options.Clipboard.AllowColumnGrow := True;

    TMSFNCDataGrid1.Options.Filtering.Enabled := True;
    TMSFNCDataGrid1.Options.Filtering.MultiColumn := True;
    TMSFNCDataGrid1.Options.Filtering.DropDownWidth := 280;
    TMSFNCDataGrid1.Options.Filtering.DropDownHeight := 220;

    TMSFNCDataGrid1.Options.Sorting.Enabled := True;
    TMSFNCDataGrid1.Options.Lookup.Enabled := True;

    TMSFNCDataGrid1.Options.IO.Delimiter := ';';
    TMSFNCDataGrid1.Options.IO.HTML.ExportImages := True;
  finally
    TMSFNCDataGrid1.EndUpdate;
  end;
end;

See also