2.4.709 brtModelTimeGroupingCalcCol

The brtModelTimeGroupingCalcCol record specifies properties of a single time grouping calculated column in the spreadsheet data model (as specified in [MS-XLDM]).


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

FRTHeader

A

contentType

B

irstColumnName (variable)

...

irstColumnId (variable)

...

FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the future record (section 2.1.6) information for this record.

A - fIsSelected (1 bit):  A bit that specifies whether this time grouping granularity was applied in the last time grouping selection.

contentType (5 bits): An unsigned integer that specifies the time grouping granularity. This value MUST be a value from the following table.

contentType

Meaning

0x00

Years.

0x01

Quarters.

0x02

Months Index.

0x03

Months.

0x04

Days Index.

0x05

Days.

0x06

Hours.

0x07

Minutes.

0x08

Seconds.

B - reserved (2 bits):  This value MUST be 0, and MUST be ignored.

irstColumnName (variable): An XLWideString (section 2.5.169) that specifies the name of the spreadsheet data model column name for a specific time grouping granularity.

irstColumnId (variable): An XLWideString (section 2.5.169) that specifies the name of the spreadsheet data model column immutable identifier for a specific time grouping granularity.