We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

NumberFormat of measure field for Pivot Table in Excel

Thread ID:





99465 May 23,2011 03:21 AM May 23,2011 08:53 AM ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On May 23, 2011 03:21 AM

I'm working with Syncfusion.XlsIO (ver
I need to create Pivot Table based on some range of data.
All values in "row" data are formated as well.
I use next code to create and format PivotTable measure fields :
field = pivotSheet.PivotTables[0].Fields[j];
field.NumberFormat = "#,#";
pivotTable.DataFields.Add(field, oMeasure.Name, PivotSubtotalTypes.Sum);
When I open the result excel file, I see that Pivot Table measure values are not formated.

Can somebody help me to solve this problem?
Thanks, Layla


John Bowlin Bosco K [Syncfusion]
Replied On May 23, 2011 08:53 AM

Hi Layla,

Thank you very much for your interest in Syncfusion Products.

We were able to reproduce the issue from our end. Could you please report this issue with a simplified issue reproducing sample or the input template through Direct Trac Developer Support System? So that, we can provide you with the patch for this issue, as well as you can take the advantage of the expertise of a dedicated support engineer and a guaranteed response time and we hope you will take advantage of this system as well.

Direct Trac Link:

Please let us know if you need any further assistance.

Pauline Bosco


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.