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.

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: 2766
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: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS