Advanced

Use cases and scenarios for the GEN::LST (List Views) area that leverage AG Grid Enterprise features. These behaviors extend the base List View Behaviors — Basic contract with capabilities available only under the AG Grid Enterprise license: export, clipboard, cell range selection, row grouping, pivoting, tool panels, context menu, status bar, master/detail, row pinning, and the server-side row model.

All use cases in this document have status Proposed — they represent recommended additions, not yet implemented.

GEN::LST::0011 — Export Entity List

Export the current list view to a file. AG Grid Enterprise provides native Excel (xlsx) export with styling, formulas, and multi-sheet support beyond the basic CSV export available in Community.

Persona	All list-view personas
Depends	GEN::LST::0001 (rendered list), GEN::LST::0010 (cell type serialization)
AG Grid	Excel Export module (Enterprise)
Priority	High
Status	Proposed

GEN::LST::0011::0001.US — Export to Excel

The user triggers an Excel export from the toolbar or context menu. The system generates an xlsx file containing the currently visible rows (respecting active filters, sort order, and column visibility). Column headers, data types, and locale formatting are preserved in the export.

GEN::LST::0011::0002.US — Export to CSV

The user triggers a CSV export. The system generates a CSV file with the same row/column scope as the Excel export. This serves as a lightweight alternative when spreadsheet formatting is not needed.

GEN::LST::0011::0003.FS — Export Respects Current View State

The exported file reflects the grid’s current state: active filters, sort order, visible columns, and column order. Hidden columns are excluded. Pinned rows (if any) are included in their pinned position.

GEN::LST::0011::0004.FS — Styled Excel Export

The Excel export applies visual styling that mirrors the grid’s appearance: header background colors, cell alignment, number formatting, and date formatting. Entity-type-specific styling rules (e.g., currency columns formatted as currency in Excel) are applied automatically based on the column type definitions in GEN::LST::0010.

GEN::LST::0011::0005.US — Export Selected Rows Only

When one or more rows are selected, the user can choose to export only the selected rows. When no rows are selected, the full filtered dataset is exported.

GEN::LST::0012 — Clipboard Operations

Copy, cut, and paste cell data using keyboard shortcuts or context menu, with Excel-compatible formatting. This enables rapid data transfer between the grid and external spreadsheets.

Persona	All list-view personas
Depends	GEN::LST::0001 (rendered list), GEN::LST::0007 (inline editing for paste/cut), GEN::LST::0010 (cell type serialization/deserialization)
AG Grid	Clipboard module (Enterprise)
Priority	High
Status	Proposed

GEN::LST::0012::0001.US — Copy Cells to Clipboard

The user selects one or more cells and presses Ctrl+C (Cmd+C on macOS). The cell values are copied to the system clipboard in a tab-separated format compatible with Excel and Google Sheets. When a single cell is focused, only that cell’s value is copied.

GEN::LST::0012::0002.US — Copy with Headers

The user copies cells with column headers included. This is available via the context menu (“Copy with Headers”) or Ctrl+Shift+C. The first row of the clipboard content contains the column names.

GEN::LST::0012::0003.US — Paste from Clipboard

The user pastes clipboard content into the grid (Ctrl+V). Pasted values populate editable cells starting from the focused cell, proceeding left-to-right and top-to-bottom. Non-editable cells are skipped. Validation rules from GEN::LST::0009 apply to pasted values.

GEN::LST::0012::0004.FS — Cut Cells

The user cuts selected cells (Ctrl+X). The values are copied to the clipboard and the source cells are cleared. Cut is only available for editable cells; read-only cells are copied but not cleared. Cut requires the inline editing pipeline from GEN::LST::0007.

GEN::LST::0012::0005.FS — Paste Validation and Rejection

When pasted data fails cell-level validation defined in GEN::LST::0009, the system rejects the invalid cells and displays error indicators. Valid cells in the same paste operation are accepted. The user receives feedback indicating which cells were rejected and why.

GEN::LST::0013 — Cell Range Selection

Select rectangular ranges of cells for aggregation display, clipboard operations, and bulk editing. This extends the row-only selection model from GEN::LST::0006 with a more granular, Excel-like interaction.

Persona	All list-view personas
Depends	GEN::LST::0001 (rendered list), GEN::LST::0007 (inline editing for bulk edit), GEN::LST::0010 (cell type awareness)
AG Grid	Cell Selection module (Enterprise)
Priority	Medium
Status	Proposed

GEN::LST::0013::0001.US — Select Cell Range by Drag

The user clicks a cell and drags to another cell. All cells within the rectangular region are selected and visually highlighted. The selection is independent of row selection.

GEN::LST::0013::0002.US — Extend Range with Shift+Click

The user holds Shift and clicks a cell to extend the current selection from the previously focused cell to the clicked cell, forming a rectangular range.

GEN::LST::0013::0003.US — Select Multiple Ranges

The user holds Ctrl (Cmd on macOS) and drags to add a second range without losing the first. Multiple non-contiguous ranges can coexist.

GEN::LST::0013::0004.FS — Status Bar Aggregation on Range

When a cell range is selected, the status bar displays aggregation values (sum, average, count, min, max) computed over the selected numeric cells. Non-numeric cells in the range are excluded from numeric aggregations. The count always reflects the total number of selected cells.

GEN::LST::0013::0005.US — Bulk Edit via Range

The user selects a range of editable cells, types a value, and presses Ctrl+Enter. The typed value is applied to all selected editable cells. Validation rules from GEN::LST::0009 apply to each cell independently.

GEN::LST::0013::0006.US — Clear Range with Delete

The user selects a range and presses Delete. All editable cells in the range are cleared. Read-only cells are unaffected. Cell clearing uses the inline editing pipeline from GEN::LST::0007.

GEN::LST::0014 — Row Grouping and Aggregation

Group rows by one or more columns and display aggregated summary values in group headers. This transforms a flat entity list into an analytical view without leaving the list context.

Persona	Irene Itemsworth (Inventory Manager), David Dealsworth (Purchasing Manager), Owen Ownerton (Business Principal)
Depends	GEN::LST::0001 (rendered list), GEN::LST::0010 (column type determines valid aggregation functions)
AG Grid	Row Grouping module, Aggregation module (Enterprise)
Priority	High
Status	Proposed

GEN::LST::0014::0001.US — Group by Single Column

The user groups the list by a column via the column menu, context menu, or by dragging a column to the Row Group Panel. Rows sharing the same value in the grouped column are collapsed under a parent group row. The group row displays the shared value and an expand/collapse chevron.

GEN::LST::0014::0002.US — Group by Multiple Columns

The user adds additional grouping levels. A secondary group creates nested sub-groups within each primary group. Group hierarchy is displayed with indentation. The user can reorder grouping levels by dragging columns in the Row Group Panel.

GEN::LST::0014::0003.FS — Display Aggregated Values in Group Rows

When row grouping is active, columns with an aggregation function configured (sum, avg, min, max, count) display computed values in the group row. For example, grouping Items by Supplier shows the total quantity and average unit cost per supplier in the group header.

GEN::LST::0014::0004.FS — Grand Total Row

When grouping is active, a pinned grand total row displays aggregated values across the entire (filtered) dataset. The grand total row remains visible at the top or bottom of the grid regardless of scroll position.

GEN::LST::0014::0005.US — Expand and Collapse Groups

The user clicks the chevron on a group row to expand or collapse it. The keyboard shortcut Enter or arrow-right expands; arrow-left collapses. An “expand all / collapse all” control in the toolbar sets the expansion state for all groups simultaneously.

GEN::LST::0014::0006.FS — Sticky Group Rows

When the user scrolls within a large expanded group, the group header row sticks to the top of the viewport so the user always knows which group they are viewing. The sticky row updates as the user scrolls past group boundaries.

GEN::LST::0014::0007.FS — Persist Group State

The system persists the user’s grouping configuration (grouped columns and their order) alongside column preferences in GEN::LST::0002::0003. The grouping state is restored on subsequent visits.

GEN::LST::0015 — Pivot Table View

Rotate data so that values from a column become column headers, creating a cross-tabulation. Pivoting combines row grouping, column pivoting, and aggregation to produce summary tables similar to Excel PivotTables.

Persona	Owen Ownerton (Business Principal), David Dealsworth (Purchasing Manager)
Depends	GEN::LST::0014 (row grouping and aggregation infrastructure), GEN::LST::0010 (aggregated value rendering)
AG Grid	Pivoting module (Enterprise)
Priority	Medium
Status	Proposed

GEN::LST::0015::0001.US — Enter Pivot Mode

The user activates pivot mode via the toolbar toggle or the Columns Tool Panel in the side bar. In pivot mode, non-grouped and non-aggregated columns are hidden. The grid transitions from a flat row display to a cross-tabulation layout.

GEN::LST::0015::0002.US — Configure Pivot Columns

The user drags a column to the “Column Labels” area in the Columns Tool Panel. The unique values of that column become new column headers. Each generated column displays the aggregated value for the intersection of the row group and the pivot value.

GEN::LST::0015::0003.US — Exit Pivot Mode

The user deactivates pivot mode. The grid returns to the standard flat-list display, restoring column visibility and order from the saved preferences in GEN::LST::0002::0003.

GEN::LST::0016 — Side Bar and Tool Panels

Provide a collapsible side panel containing the Columns Tool Panel and Filters Tool Panel, giving users a persistent interface for column management, grouping configuration, and filter control.

Persona	All list-view personas
Depends	GEN::LST::0002 (column configuration), GEN::LST::0003 (filter model)
AG Grid	Side Bar, Columns Tool Panel, Filters Tool Panel (Enterprise)
Priority	Medium
Status	Proposed

GEN::LST::0016::0001.US — Open and Close Side Bar

The user clicks a toolbar button or keyboard shortcut to toggle the side bar. The side bar opens on the right side of the grid. Clicking the active tab’s icon collapses the side bar. The open/closed state is persisted per entity type.

GEN::LST::0016::0002.US — Manage Columns via Tool Panel

The user opens the Columns Tool Panel tab and toggles column visibility by clicking column names. Columns can be dragged to reorder them. The panel also exposes Row Group, Values (aggregation), and Column Labels (pivot) drop zones for drag-and-drop configuration of GEN::LST::0014 and GEN::LST::0015.

GEN::LST::0016::0003.US — Manage Filters via Tool Panel

The user opens the Filters Tool Panel tab to view and modify all active column filters in a single scrollable list. Expanding a filter reveals the same filter control available in the column menu. Active filters defined in GEN::LST::0003 display a visual indicator.

GEN::LST::0017 — Context Menu

Right-click any cell to access a context-sensitive menu with actions relevant to the clicked cell, row, and current grid state. This consolidates access to clipboard, export, row actions, and column operations in a single interaction.

Persona	All list-view personas
Depends	GEN::LST::0001 (rendered list), GEN::LST::0006 (action enablement model)
AG Grid	Context Menu module (Enterprise)
Priority	High
Status	Proposed

GEN::LST::0017::0001.US — Open Context Menu

The user right-clicks a cell. A context menu appears at the cursor position with items grouped into sections: clipboard operations (from GEN::LST::0012 when available), row actions (domain-specific), export options (from GEN::LST::0011 when available), and column operations.

GEN::LST::0017::0002.FS — Context-Sensitive Menu Items

Menu items are enabled or disabled based on the clicked cell and current selection state per GEN::LST::0006::0005. For example: “Paste” is disabled on read-only cells; domain-specific actions (e.g., “Convert to PO”) appear only when the row’s data state permits them; “Export Selected” appears only when rows are selected.

GEN::LST::0017::0003.FS — Domain-Specific Menu Extension

Each entity type can inject domain-specific menu items into the context menu. The extension point receives the clicked row data and returns additional menu item definitions. This is the mechanism for surfacing domain actions like “View Receiving History” or “Duplicate Item” without dedicated toolbar buttons.

GEN::LST::0018 — Status Bar

Display a status bar below the grid showing row counts, selection counts, and aggregation summaries. The status bar provides at-a-glance feedback without requiring the user to scroll or count manually.

Persona	All list-view personas
Depends	GEN::LST::0001 (rendered list)
AG Grid	Status Bar module (Enterprise)
Priority	Medium
Status	Proposed

GEN::LST::0018::0001.FS — Display Row Counts

The status bar displays the total row count and, when filters from GEN::LST::0003 are active, the filtered row count (e.g., “Showing 42 of 1,204 rows”).

GEN::LST::0018::0002.FS — Display Selection Count

When rows or cell ranges are selected, the status bar displays the selection count (e.g., “3 rows selected” or “12 cells selected”).

GEN::LST::0018::0003.FS — Display Range Aggregations

When a cell range containing numeric values is selected via GEN::LST::0013, the status bar displays sum, average, min, max, and count for the selected cells. Values update in real time as the selection changes. This scenario is functional only when cell range selection is available.

GEN::LST::0019 — Master/Detail View

Expand a row to reveal a nested detail grid showing related child entities inline. This eliminates navigation to a separate page for one-to-many relationships — for example, expanding a Purchase Order row to see its Order Lines.

Persona	David Dealsworth (Purchasing Manager), Keisha Clerkson (Receiving Clerk)
Depends	GEN::LST::0001 (rendered list), GEN::LST::0010 (cell rendering for detail grid columns)
AG Grid	Master/Detail module (Enterprise)
Priority	Medium
Status	Proposed

GEN::LST::0019::0001.US — Expand Row to Show Detail Grid

The user clicks the expand chevron on a master row. A detail grid appears below the row, displaying child entities (e.g., Order Lines for a Purchase Order). The detail grid supports its own column configuration, sorting, and filtering independently from the master grid.

GEN::LST::0019::0002.US — Collapse Detail Grid

The user clicks the collapse chevron. The detail grid is hidden. Optionally, the detail grid state (scroll position, filters) is preserved so that re-expanding restores the previous view.

GEN::LST::0019::0003.FS — Detail Grid Actions

The detail grid supports its own set of row actions (single-row and multi-row per GEN::LST::0006). Actions in the detail grid operate on the child entity type. For example, “Receive Line” on an Order Line within the PO detail grid.

GEN::LST::0019::0004.FS — Lazy Load Detail Data

Detail grid data is fetched on demand when the user expands the row, not pre-loaded. This avoids unnecessary API calls for rows the user never expands.

GEN::LST::0020 — Row Pinning

Pin important rows to the top or bottom of the grid so they remain visible while scrolling. Pinned rows act as reference points — for example, pinning a “target” row while scanning inventory to compare against it.

Persona	Irene Itemsworth (Inventory Manager)
Depends	GEN::LST::0001 (rendered list)
AG Grid	Row Pinning (Enterprise context menu integration via GEN::LST::0017)
Priority	Low
Status	Proposed

GEN::LST::0020::0001.US — Pin Row to Top or Bottom

The user right-clicks a row and selects “Pin to Top” or “Pin to Bottom” from the context menu. The row moves to the pinned area and remains visible regardless of scroll position.

GEN::LST::0020::0002.US — Unpin Row

The user right-clicks a pinned row and selects “Unpin.” The row returns to its natural position in the sorted/filtered dataset.

GEN::LST::0021 — Server-Side Row Model

Delegate sorting, filtering, grouping, and aggregation to the backend so the grid can handle datasets of arbitrary size without loading all rows into the browser. The Server-Side Row Model (SSRM) replaces the client-side row model with a lazy-loading architecture where the grid requests only the rows it needs, when it needs them.

Persona	All list-view personas
Depends	GEN::LST::0003 (filter model contract — serialized to server), GEN::LST::0004 (sort model contract — serialized to server), GEN::LST::0005 (pagination interaction model — subsumed by SSRM block loading), GEN::LST::0010 (cell rendering of server responses)
AG Grid	Server-Side Row Model module (Enterprise)
Priority	High
Status	Proposed

GEN::LST::0021::0001.FS — Lazy-Load Row Blocks on Scroll

The grid requests rows from the backend in configurable block sizes (e.g., 100 rows). As the user scrolls, additional blocks are fetched and cached. Previously fetched blocks are retained in a configurable cache so that scrolling back does not re-fetch. The user experiences seamless infinite scroll identical to the current GEN::LST::0005::0001 behavior, but the backend controls the result window.

GEN::LST::0021::0002.FS — Server-Side Sorting

When the user clicks a column header to sort per GEN::LST::0004, the grid sends the sort model (column, direction) to the backend. The backend returns rows in the requested order. The grid purges its row cache and fetches fresh blocks starting from the top. Multi-column sort is supported by sending the full sort model array.

GEN::LST::0021::0003.FS — Server-Side Filtering

When the user applies a filter (global, column, or advanced per GEN::LST::0003), the grid sends the filter model to the backend. The backend applies the filter criteria to the query and returns matching rows. The grid purges its row cache and fetches fresh blocks. The filter UI remains unchanged; only the execution location changes.

GEN::LST::0021::0004.FS — Server-Side Row Grouping

When row grouping is active per GEN::LST::0014, the grid requests only the top-level group rows from the backend. Each group row includes the aggregated values computed by the backend. When the user expands a group, the grid requests the child rows (or nested sub-groups) for that group. This avoids loading the entire dataset to compute groups client-side. This scenario is functional only when GEN::LST::0014 is available.

GEN::LST::0021::0005.FS — Server-Side Aggregation

Aggregation values displayed in group rows and the grand total row per GEN::LST::0014::0004 are computed by the backend query rather than in the browser. This ensures accurate aggregations over the full dataset even when only a subset of rows is loaded. The aggregation functions (sum, avg, min, max, count) are sent as part of the request model. This scenario is functional only when GEN::LST::0014 is available.

GEN::LST::0021::0006.FS — Server-Side Pivot

When pivot mode is active per GEN::LST::0015, the grid sends the pivot column, row group columns, and aggregation functions to the backend. The backend returns the pivoted result set with dynamically generated columns. The grid renders the pivot columns based on the response metadata. This scenario is functional only when GEN::LST::0015 is available.

GEN::LST::0021::0007.FS — Cache Management and Refresh

The grid maintains a block cache with a configurable maximum size. When the cache limit is reached, the least recently accessed blocks are purged. The user can trigger a full cache refresh via a toolbar button or pull-to-refresh gesture, which purges all cached blocks and re-fetches from the backend. Programmatic refresh is available for use after create/update/delete operations.

GEN::LST::0021::0008.FS — Retry on Network Failure

When a block fetch fails due to a network error or server error, the grid displays an error indicator in the affected row area with a “Retry” affordance. The user clicks to retry the failed block fetch. The grid does not silently swallow fetch failures or display empty rows as if no data exists.

GEN::LST::0021::0009.FS — Row Count and Progress Indication

The backend may return a total row count or indicate that the total is unknown (open-ended). When the total is known, the status bar and scroll thumb reflect the true dataset size. When unknown, the grid uses a “last row unknown” mode where the scroll thumb approximates position and the status bar displays “Loading…” until the final block is fetched.

Summary

Use Case	Scenarios	US	FS	UC	Priority
GEN::LST::0011 Export Entity List	5	3	2	0	High
GEN::LST::0012 Clipboard Operations	5	3	2	0	High
GEN::LST::0013 Cell Range Selection	6	4	2	0	Medium
GEN::LST::0014 Row Grouping and Aggregation	7	3	4	0	High
GEN::LST::0015 Pivot Table View	3	3	0	0	Medium
GEN::LST::0016 Side Bar and Tool Panels	3	3	0	0	Medium
GEN::LST::0017 Context Menu	3	1	2	0	High
GEN::LST::0018 Status Bar	3	0	3	0	Medium
GEN::LST::0019 Master/Detail View	4	2	2	0	Medium
GEN::LST::0020 Row Pinning	2	2	0	0	Low
GEN::LST::0021 Server-Side Row Model	9	0	9	0	High
Total	50	24	26	0

Dependency Graph

The dependency graph below shows which use cases must be available before others can be implemented. Solid arrows indicate hard functional dependencies between new use cases; dashed arrows indicate dependencies on existing base use cases (0001—0010).

Implementation Tiers

Based on the dependency graph, implementation can proceed in the following tiers. All use cases within a tier can be implemented in parallel.

Tier 0 — Already covered: GEN::LST::0001 through GEN::LST::0010.

Tier 1 — No dependencies on other new use cases (can be implemented in parallel):

• GEN::LST::0011 Export Entity List
• GEN::LST::0012 Clipboard Operations
• GEN::LST::0013 Cell Range Selection
• GEN::LST::0014 Row Grouping and Aggregation
• GEN::LST::0016 Side Bar and Tool Panels
• GEN::LST::0017 Context Menu
• GEN::LST::0018 Status Bar
• GEN::LST::0019 Master/Detail View
• GEN::LST::0020 Row Pinning

Tier 2 — Depends on Tier 1 use cases:

• GEN::LST::0015 Pivot Table View (requires GEN::LST::0014)
• GEN::LST::0021 Server-Side Row Model (basic sort/filter/paginate is Tier 1; server-side grouping/aggregation/pivot requires GEN::LST::0014 and GEN::LST::0015)

---