Skip to main content

XlsxExportOptionsEx.GroupState Property

Gets or sets data groups’ expanded state in the exported document. Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

[DefaultValue(GroupState.Default)]
public GroupState GroupState { get; set; }

Property Value

Type Default Description
GroupState Default

A value that specifies the expanded state of data groups in the output document.

Available values:

Name Description
Default

Data groups are collapsed and expanded as they are in the source control.

ExpandAll

Expand all data groups.

CollapseAll

Collapse all data groups.

Remarks

Use the GroupState property to specify whether or not information from collapsed rows (Grid) or nodes (Tree List) should be printed in Data-Aware Export mode (set the XlsExportOptionsEx.ExportType property to DataAware to enable this mode).

Value Versions 16.2 and older Versions 17.1 and newer
ExpandAll Print all content Print all content
Default Export only those groups (nodes) that are already expanded Specified by a control

Control-level options mentioned in the table above include the following:

If updating your project to v17.1 or higher, you can choose to keep the previous behavior using the WindowsFormsSettings.DefaultSettingsCompatibilityMode option. See Version Compatibility: Default Property Values to learn more.

See Also