GrapeCity.Documents.Excel.IPivotField.AllItemsVisible

AllItemsVisible Property

AllItemsVisible

Gets whether all items in the PivotField are visible.

Returns false when manual filtering has been applied by hiding one or more items. Use ClearManualFilter() to restore visibility to all items.

Declaration

bool AllItemsVisible { get; }

ReadOnly Property AllItemsVisible As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Product", "Amount"},
    {"Bose 785593-0050", 4270},
    {"Canon EOS 1500D", 8239},
    {"Haier 394L 4Star", 617}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "PivotTable1");
IPivotField productField = pivotTable.PivotFields["Product"];
productField.Orientation = PivotFieldOrientation.RowField;
productField.PivotItems["Canon EOS 1500D"].Visible = false;
bool allItemsVisible = productField.AllItemsVisible;