2.1.696 Part 4 Section 3.3.2.8, filters (Filter Criteria)

a.   The standard states that the filter and dateGroupItem child elements should be sequenced.

Excel requires these child elements to be a choice of one or the other.

b.   The standard defines the calendarType attribute for date grouped items.

Office ignores the calendarType attribute.

Show: