Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Tue Jun 04, 2013 12:00 pm

could you please let me know how to set number format for below if a data field is created like below :

pt.DataFields.Add(pt.PivotFields("OnHand"), "SUM of OnHand", SubtotalTypes.Sum)

chaitanya
 
Posts: 12
Joined: Thu May 16, 2013 10:42 am

Wed Jun 05, 2013 6:45 am

Dear chaitanya,

Thanks for your inquiry.
Pleae try the code below.

Code: Select all
 pt.PivotFields("OnHand").NumberFormat = "0.00";


Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2328
Joined: Wed Jun 27, 2012 8:50 am

Fri Jun 07, 2013 8:59 am

Dear chaitanya,

Has this issue been resolved?
Please give us a feedback at your early convenience.

Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2328
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS