set Number format for data fields

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

set Number format for data fields

Postby chaitanya » 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

Re: set Number format for data fields

Postby amy.zhao » 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: 2251
Joined: Wed Jun 27, 2012 8:50 am

Re: set Number format for data fields

Postby amy.zhao » 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: 2251
Joined: Wed Jun 27, 2012 8:50 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests

cron