How to add currency format to Data Row in AspxPivotGrid by Programmatically?

Question

I want to add currency format to Data Row in AspxPivotGrid table. You can see the below picture,how it is displaying now. So I just want to display currency format to 3 fields (ExtendedPrice,ExtendedCost,Profit)

This is my c# code:

if (i == 8 || i == 9 || i == 10 || i == 11)
{
    DevExpress.Web.ASPxPivotGrid.PivotGridField newF = new DevExpress.Web.ASPxPivotGrid.PivotGridField(names[i], PivotArea.DataArea);
    newF.ID = "field" + newF.FieldName;
    //newF.ValueFormat.FormatType=
    ASPxPivotGrid1.Fields.Add(newF);
}

Mohit S · Answer 1 · 2017-01-23T09:55:38.337

0

This might do the trick for you

newF.ValueFormat-FormatString = "c2";
newF.ValueFormat-FormatType = "Numeric";

edited Jan 23 '17 at 09:55

answered Jan 23 '17 at 06:56

Mohit S

13,723
6
34
69

score 0 · Accepted Answer · answered Jan 23 '17 at 11:37

0

Per this doc (FormatInfo) I think it should be set like that:

newF.ValueFormat.FormatType = FormatType.Numeric;
newF.ValueFormat.FormatString = "c2";

answered Jan 23 '17 at 11:37

andrews

2,173
2
16
29

How to add currency format to Data Row in AspxPivotGrid by Programmatically?

2 Answers2