PivotTable Font.Size

Aspose.Cells Product Family
1

Hello,

I am using Aspose.Cells for .NET 8.6.3.0.
I am trying to change the FonSize used in my pivot tables which seems to be 10 by default on my Excel.

I found that one could change the default style by using:
WorkBook.DefaultStyle.Font.Size = 14;
over the entire workbook.
Regular cells values are then created by using the new size 14.

Nevertheless the pivot fields still are created with the old Font.Size= 10.
Creating a range around the pivot table and setting the font size to 14 didn’t work either.

Thanks,
Regards
Jacques

2

Hi,

Thanks for providing us some details.

I think you may try to specify your desired font attributes (e.g font name, size etc.) to your pivot table before saving the Excel file, see the sample code snippet below for your reference:
e.g
Sample code:

…

Style style = workbook.CreateStyle();

//style.Font.Name = "Calibri";

style.Font.Size = "14";

pivot.FormatAll(style);
…

Let us know if you still have any issue.

Thank you.

3

Fast, simple, efficient and working solution.
Thank you.
Jacques

4

Hi,


Good to know that your issue is sorted out by the suggested code. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.