I need to add a border for the Grand Totals row in a pivot table that uses filters on the primary column. PivotTable.Format() works as long as no filters are applied, but as soon as filter items are selected another partial border appears below the pivot table as shown in the attachment.Grand Totals Border.jpg (40.6 KB)
Thanks for the screenshot.
Could you please provide us sample files (input Excel file (if any) and output Excel file by Aspose.Cells) and sample code (runnable) that you are currently using to produce problematic file (regarding borders). Also, share a sample Excel file having your expected results (pivot table with borders intact when filters applied), you may create/update your desired file in MS Excel manually. We will check your issue soon.
PS. please zip the files prior attaching here.