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.

DataGrid with overlay and option-driven rendering

Option groups

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

Inline example 1PascalC++

// 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;

// 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.

Header and footer classes

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.

Configure common grid optionsPascalC++

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;

void __fastcall TForm1::ConfigureGridOptions()
{
  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 = L';';
    TMSFNCDataGrid1->Options->IO->HTML->ExportImages = true;
  }
  __finally
  {
    TMSFNCDataGrid1->EndUpdate();
  }
}

Combining option groups

Most real grids enable several option groups at once, and they interact: banding colors rows that filtering and sorting then reorder, clipboard growth decides what pasted data does, and the IO options decide how the result is exported. Set them together inside one update block so the grid lays out only once. The example below configures banding, filtering, sorting, lookup, and clipboard growth in a single pass, and then adjusts the CSV delimiter and HTML export options so the same grid can be exported with matching settings.

Combining option groupsPascalC++

procedure TForm1.ConfigureCombinedOptions;
begin
  Grid.BeginUpdate;
  try
    // Appearance and data handling
    Grid.Options.Banding.Enabled := True;
    Grid.Options.Banding.NormalRowCount := 1;
    Grid.Options.Banding.BandRowCount := 1;
    Grid.Options.Filtering.Enabled := True;
    Grid.Options.Sorting.Enabled := True;
    Grid.Options.Lookup.Enabled := True;

    // Clipboard behavior
    Grid.Options.Clipboard.AllowRowGrow := True;
    Grid.Options.Clipboard.AllowColumnGrow := True;

    // Matching export settings
    Grid.Options.IO.Delimiter := ';';
    Grid.Options.IO.HTML.ExportImages := True;
  finally
    Grid.EndUpdate;
  end;
end;

void __fastcall TForm1::ConfigureCombinedOptions()
{
  Grid->BeginUpdate();
  try
  {
    // Appearance and data handling
    Grid->Options->Banding->Enabled = true;
    Grid->Options->Banding->NormalRowCount = 1;
    Grid->Options->Banding->BandRowCount = 1;
    Grid->Options->Filtering->Enabled = true;
    Grid->Options->Sorting->Enabled = true;
    Grid->Options->Lookup->Enabled = true;

    // Clipboard behavior
    Grid->Options->Clipboard->AllowRowGrow = true;
    Grid->Options->Clipboard->AllowColumnGrow = true;

    // Matching export settings
    Grid->Options->IO->Delimiter = L';';
    Grid->Options->IO->HTML->ExportImages = true;
  }
  __finally
  {
    Grid->EndUpdate();
  }
}