NumberFormat of measure field for Pivot Table in Excel

[Layla]

I'm working with Syncfusion.XlsIO (ver 9.2.0.137)
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





zbk5jlk4_a2685a70.zip

[John Bowlin Bosco K]

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:
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Please let us know if you need any further assistance.

Thanks,
Pauline Bosco