FlexGrid features cover how the grid freezes, merges, reshapes, filters, summarizes, exports and localizes data. This overview gives a quick snapshot of each feature and when to use it.
Layout and Structure
Topic | Use Case |
|---|
Cell Freezing | Use to keep rows and columns visible while users scroll large data sets, through FrozenRows and FrozenColumns. Frozen cells stay editable and selectable. |
Column Freezing | Use to freeze columns on the left (FrozenColumns) or right (FrozenRightColumns), including a custom Pin/Unpin item in the column menu. |
Cell Merging | Use to merge adjacent cells with the same value across rows, columns or headers, through AllowMerging and the GridAllowMerging values. |
Drag Drop | Use to let users reorder columns, rows or both, through AllowDragging. |
Transposed Grid | Use to show each item as a column and each property as a row, through TransposedGridBehavior. This suits wide records. |
TreeGrid | Use to show hierarchical data, such as tasks and sub-tasks, as an expandable tree through ChildItemsPath. It also covers expand modes, tree lines, node icons, and sorting and filtering in trees. |
Sorting, Filtering and Summarizing
Topic | Use Case |
|---|
Sorting | Use to sort by clicking column headers, on the whole grid or per column, through AllowSorting. Ctrl or Shift enables multi-column sorting. |
Custom Sort Icon | Use to change the sort icon’s position (SortIconPosition) and appearance (SortAscendingIconTemplate, SortDescendingIconTemplate). |
Filtering | Start here for an introduction to filtering, which links to Full Text Filtering and Filter Row. |
|
|
|
|
|
Grouping | Use GroupAsync on a C1DataCollection to group rows, and column Aggregate values (Sum, Average, Count and others) for group summaries. |
Summary Row | Use GridSummaryRow to show totals and other aggregates as a footer row, or position group summaries with GroupSummariesPosition. |
Paging | Use C1PagedDataCollection with the C1DataPager control to split data into pages. It needs the C1.Blazor.DataPager NuGet package. |
Interaction and Menus
Topic | Use Case |
|---|
Clipboard Support | Use for cut, copy and paste with keyboard shortcuts, and choose whether headers are copied through ClipboardCopyMode. Copying does not support merged cells. |
Selection Menu | Use the built-in right-click menu for clipboard and selection actions. It changes with the selection mode, and ShowSelectionMenu turns it off. |
Context Menu | Use ShowSelectionMenu="false" to show the browser’s native context menu instead. It applies to the whole grid and cannot be scoped to cells. |
Formatting, Output and Localization
Topic | Use Case |
|---|
Conditional Formatting | Use a custom GridCellFactory (PrepareCellStyle) to highlight cells based on their values, for example temperature ranges. |
Exporting Data | Use Save for HTML, CSV and TXT files, and SaveAsync for Excel (XLSX) on server-side Blazor, preserving freezing, grouping, merging and styles. |
Localization | Use culture-specific .resx files embedded in your app to add or override translations, including strings from related ComponentOne assemblies. |
