Free Support Forum - aspose.com

Hide Page Filters


#1

Hello,

I Created a pivot table with filters but I want to hide them from the worksheet and still applying data filtering.

pivotTable.AddFieldToArea(PivotFieldType.Page, “LockedPtf”);
pivotTable.AddFieldToArea(PivotFieldType.Page, “ExcludedOstType”);
pivotTable.AddFieldToArea(PivotFieldType.Page, “DiffExDate”);
pivotTable.AddFieldToArea(PivotFieldType.Page, “Message”);

I tried to delete the range which correspond to the filters but still see them.

pivotWorksheet.Cells.ClearRange(1, 1, 5, 2);
pivotWorksheet.Cells.ClearContents(1, 1, 5, 2);
pivotWorksheet.Cells.DeleteRange(1, 1, 5, 2, ShiftType.None);

Thanks.


#2

@Oussama_Mokni,
You may please try to set

PivotTable.ShowRowHeaderCaption = false

and share feedback. It shall produce results similar to the one shown in the attached image.

If it does not fulfill your requirement, please provide us two sample workbooks generated by MS Excel where one is with page filter and the second one is without page filters along with the images showing the difference. Also, share the steps in Excel to show/hide these options. We will analyze the information and provide feedback accordingly.
FilterOptions.png (9.1 KB)