Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Feb 13, 2014 4:16 pm

HI, is possible background color for subtotals pivot ??
thanks
Last edited by ict@sogedin.it on Mon Apr 07, 2014 7:36 am, edited 1 time in total.

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Fri Feb 14, 2014 7:20 am

Hello,

You can try this line of code:
pt.BuiltInStyle = PivotBuiltInStyles.PivotStyleDark24;
(pt is a PivotTable instance.)
If you have any questions, welcome to get it back to us.

Regards,
Benjamin
E-iceblue support team
User avatar

Benjamin Du
 
Posts: 82
Joined: Thu Jul 25, 2013 2:38 am

Fri Feb 14, 2014 7:53 am

yes, but i've two subtotal
and the istruction color only one
other solution ??

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Fri Feb 14, 2014 8:34 am

Hello,

I don’t know what kind of effect that you need. Could you please provide us the result file that meets your need.
Thank you very much.
If there are any questions, welcome to tell us.

Regards,
Benjamin
E-iceblue support team
User avatar

Benjamin Du
 
Posts: 82
Joined: Thu Jul 25, 2013 2:38 am

Fri Feb 14, 2014 10:01 am

This Example
thanks
Attachments
Immagine.JPG
Immagine.JPG (517.56 KiB) Viewed 11415 times

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Mon Feb 17, 2014 3:22 am

Hello,

I'm afraid that it's impossible to set the background color of subtotal pivot at present. We are very sorry for the inconvenience caused by ours. And I have added it as a new feature to the schedule of our dev team.
If we have any progress, we will tell you immediately.

Regards,
Benjamin
E-iceblue support team
User avatar

Benjamin Du
 
Posts: 82
Joined: Thu Jul 25, 2013 2:38 am

Mon Feb 17, 2014 9:38 am

Thanks, I hope the new release will come soon saw that
I have three unsolved problems and I have already bought the product.
The new version gifted to me since I'm a beta tester
(joke obviously co ..)
hello

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Tue Feb 18, 2014 6:15 am

Hello,

Our duty is to meet the need of our customers. And the dev team is working on your issues. We are trying our best to solve your issues sooner. Once there is any progress, we will tell you immediately.
If you have any questions, welcome to get it back to us.

Thanks and Regards,
Benjamin
E-iceblue support team
User avatar

Benjamin Du
 
Posts: 82
Joined: Thu Jul 25, 2013 2:38 am

Tue Mar 18, 2014 4:50 pm

News ??

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Wed Mar 19, 2014 1:28 am

Hello,

We are very sorry that your issue has not been fixed. Our dev team is working on that now. Once there is any progress, we will tell you immediately.
If you get any questions, welcome to get it back to us.

Regards,
Benjamin
E-iceblue support team
User avatar

Benjamin Du
 
Posts: 82
Joined: Thu Jul 25, 2013 2:38 am

Sun Apr 06, 2014 7:41 am

HELLO News ??
for problem ??
Thank

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Mon Apr 07, 2014 3:57 am

Hello,

We have added the corresponding feature, but there are still some issues after testing, and our Dev team is fixing, once the feature works fine, we will let you know immediately. So sorry for inconvenience.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri May 23, 2014 10:27 am

Hi
News for this problem ??

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Mon May 26, 2014 2:45 am

Hello,

Sorry for late reply as weekend.
Please download the newest SPire.Office and try the following method.
Code: Select all
Workbook wb = new Workbook();
wb.LoadFromFile(@"sample.xlsx");
XlsPivotTable pivotTable = wb.Worksheets["Pivot Table"].PivotTables[0] as XlsPivotTable;

//custom the style
string styleName = "newone";
pivotTable.CustomTableStyleName = styleName;
PivotTableStyle pivotTableStyle = new PivotTableStyle(styleName);
PivotStyle pivotStyle = wb.CreatePivotStyle();
pivotStyle.Fill.PatternColorObject.SetKnownColor(ExcelColors.Blue);

//apply the style where you need to add
pivotTableStyle.Styles.Add(PivotTableElement.thirdSubtotalRow, pivotStyle);
wb.AddPivotTableStyle(pivotTableStyle);
wb.SaveToFile("result.xlsx", ExcelVersion.Version2007);

If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Thu May 29, 2014 9:09 am

Hello,

Have you tested the method? Does it fulfill your need? Could you please give us some feedback if convenience?

Thanks,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS