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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

NumberFormat of measure field for Pivot Table in Excel

Thread ID:





99465 May 23,2011 07:21 AM UTC May 23,2011 12:53 PM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On May 23, 2011 07:21 AM UTC

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 12:53 PM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon