Exemple #1
0
        /// <summary>
        /// Refreshes the slicer cache's values.
        /// </summary>
        internal void Refresh(ExcelPivotCacheDefinition cacheDefinition, List <CacheItem> previouslySelectedItems)
        {
            // If all are selected and a new value is added, it is selected.
            // Otherwise new values are added as deselected.
            bool isFiltered      = this.TabularDataNode.Items.Any(i => !i.IsSelected);
            var  cacheFieldIndex = cacheDefinition.GetCacheFieldIndex(this.SourceName);
            var  cacheField      = cacheDefinition.CacheFields[cacheFieldIndex];
            var  cacheItems      = cacheDefinition.GetCacheItemsForSlicer(cacheField);

            this.TabularDataNode.Items.Clear();

            if (isFiltered)
            {
                for (int i = 0; i < cacheItems.Count; i++)
                {
                    var  sharedItem = cacheItems[i];
                    bool isSelected = previouslySelectedItems.Any(si => si.Value == sharedItem.Value && si.Type == sharedItem.Type);
                    this.TabularDataNode.Items.Add(i, isSelected);
                }
            }
            else
            {
                cacheItems.ForEach((c, i) => this.TabularDataNode.Items.Add(i, true));
            }
        }
Exemple #2
0
        /// <summary>
        /// Applies the sort and hide settings to the slice values. This must be called after
        /// pivot tables are refreshed in order to work properly.
        /// </summary>
        /// <param name="cacheDefinition">The backing cache definition.</param>
        internal void ApplySettings(ExcelPivotCacheDefinition cacheDefinition)
        {
            var cacheFieldIndex = cacheDefinition.GetCacheFieldIndex(this.SourceName);
            var cacheField      = cacheDefinition.CacheFields[cacheFieldIndex];
            var cacheItems      = cacheDefinition.GetCacheItemsForSlicer(cacheField);
            var sortedItems     = this.Sort(cacheField, cacheItems);

            sortedItems = this.ApplyNoDataSettings(sortedItems, cacheDefinition, cacheFieldIndex, cacheField, cacheItems);
            this.TabularDataNode.Items.Clear();
            this.TabularDataNode.Items.AddRange(sortedItems);
        }