Row fields and column fields Color issue

Aspose.Cells Product Family
1

Dear Aspose support team,

My requirement is that, i need to change the appearance of the pivot table. I need to fix some color for the Row fields and column fields.

I tried PivotTable.AutoFormatType method, but i'm not satisfied with the appearance. I need the color changes and align changes in the following functionality: pivotTable.AutoFormatType = PivotTableAutoFormatType.Classic;. Can you advise me if there is any other method to fix the colors for the Column headers of a pivot table.

Also, i need to align the data fields in the centre of the cell, with thin borders for all the cell. Please let me know how to achieve this feature.

Thankyou.

Saravanan

2

Hi Saravanan,

Well, I am afraid, currently you have to use only the predefined Formats using PivotTableAutoFormatType enum. The main reason is that Aspose.Cells for .NET does not support to manipulate Pivot Table at the moment, it does not support to change color formattings, it only forces MS Excel to create the pivot table in predefined manner at runtime when opening the generated file into MS Excel.

We may support this feature in our future versions.

Thank you.