Back to Devexpress

DxPivotTable.VirtualScrollingMode Property

blazor-devexpress-dot-blazor-dot-pivottable-dot-dxpivottable-50ae5a5c.md

latest2.9 KB
Original Source

DxPivotTable.VirtualScrollingMode Property

Specifies the virtual scrolling mode for the Pivot Table.

Namespace : DevExpress.Blazor.PivotTable

Assembly : DevExpress.Blazor.PivotTable.v25.2.dll

NuGet Package : DevExpress.Blazor.PivotTable

Declaration

csharp
[DefaultValue(PivotTableVirtualScrollingMode.Default)]
[Parameter]
public PivotTableVirtualScrollingMode VirtualScrollingMode { get; set; }

Property Value

TypeDefaultDescription
PivotTableVirtualScrollingModeDefault

An enumeration value.

|

Available values:

NameDescription
Default

Both is used. Renders only visible rows and columns, loads additional data when users scroll vertically and horizontally.

| | Vertical |

Renders only visible rows, loads additional data when users scroll through rows (vertically).

| | Horizontal |

Renders only visible columns, loads additional data when users scroll through columns (horizontally).

| | Both |

Renders only visible rows and columns, loads additional data when users scroll vertically and horizontally.

|

Remarks

You can activate column/row virtualization to optimize DevExpress Blazor Pivot Table performance when working with large datasets. Once virtual scrolling is activated, the component renders only columns/rows within the viewport (and a small buffer area). Other cells are loaded dynamically as users scroll the Pivot Table.

Use the following API members to configure virtual scrolling:

VirtualScrollingEnabledSpecifies whether virtual scrolling is active.VirtualScrollingModeSpecifies the virtual scrolling mode:

  • Vertical: Only rows are virtualized.
  • Horizontal: Only columns are virtualized.
  • Both or Default: Rows and columns are virtualized.

The following code activates horizontal virtual scrolling in the Pivot Table:

razor
<DxPivotTable Data="SalesData"
              VirtualScrollingEnabled="true"
              VirtualScrollingMode="PivotTableVirtualScrollingMode.Horizontal">
    <Fields>
        @*...*@
    </Fields>
</DxPivotTable>

The Pivot Table renders skeleton items while it retrieves data during scrolling operations.

Run Demo: Virtual Scrolling

Implements

VirtualScrollingMode

See Also

DxPivotTable Class

DxPivotTable Members

DevExpress.Blazor.PivotTable Namespace