Free Support Forum -

Style.Custom question


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?


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.

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


We will update you soon regarding this.

Thanks for being patient!


Please try this fix.

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

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