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.v24.2.Core.dll

Declaration

C#

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

VB.NET

<DefaultValue(GroupState.Default)>
Public Property GroupState As GroupState

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:

• GridOptionsPrint.ExpandAllGroups
• TreeListOptionsPrint.PrintAllNodes

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.