GrapeCity.Documents.Excel.IDataOptions.AutomaticGroupDateTimeInPivotTable

AutomaticGroupDateTimeInPivotTable Property

AutomaticGroupDateTimeInPivotTable

Gets or sets whether Date/Time columns are grouped automatically in PivotTables.

This option controls whether Date/Time fields are grouped automatically when they are used in PivotTables.

Declaration

bool AutomaticGroupDateTimeInPivotTable { get; set; }

Property AutomaticGroupDateTimeInPivotTable As Boolean

Examples

IDataOptions dataOptions = workbook.Options.Data;
dataOptions.AutomaticGroupDateTimeInPivotTable = false;
bool automatic = dataOptions.AutomaticGroupDateTimeInPivotTable;