Free Support Forum - aspose.com

Style.Custom question

Aspose.Cells Product Family
#1

Hi,

I've created a custom style...

Style currencyFormat = wb.Styles[wb.Styles.Add()];
currencyFormat.Custom = "$#,##0.0000";

And I don't have any problems applying this to a data sheet range or cell but I need to apply it to a pivot table column. I hoped that the pivot table column would inherit the style of the underlying column but that is not the case. How do I apply this style to a my pivot column?

Thanks,
Justin

#2

Hi Justin,

We will support Custom formattings for pivot fields data soon. Currenlty you may only apply standard Number formats using....pivotField.Number property.

Thank you.

#3

Thanks for the response. Do you have an idea of when that release will be?

#4

Hi,

We will update you soon regarding this.

Thanks for being patient!

#5

Hi,

Please try this fix.

Please use PivotField.NumberFormat property to set custom number format.

#6

You guys are awesome! Thanks, it works like a charm.