TimelineState Members (Excel)

Office 2013

The timeline-specific state of a SlicerCache Object (Excel) object.

Name

Description

SetFilterDateRange

Sets the Timeline’s filter.

Name

Description

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

EndDate

Returns the end of the filtering date range (equals to TimelineState.StartDate Property (Excel) if range is a single day). Variant Read-only

FilterType

Returns the type of the date filter. XlPivotFilterType Enumeration (Excel) Read-only

FilterValue1

Returns the 1st value associated with the date filter (semantics vary by filter type). Variant Read-only

FilterValue2

Returns the 2nd value associated with the date filter (semantics vary by filter type). Variant Read-only

Parent

Returns an Object that represents the parent object of the specified TimelineState Object (Excel) object. Read-only.

SingleRangeFilterState

True when the filtering state is a contiguous date range; False otherwise. Boolean Read-only

StartDate

Returns the start of the filtering date range. Variant Read-only

Show:
© 2015 Microsoft