StringFormat Documentation

[Jens]

Hey,

is there any documentation about the "StringFormat" property used by the PropertyAggregateDescription?

Only useful resource i found was for Kendo UI (http://docs.telerik.com/kendo-ui/framework/globalization/numberformatting​).

I have no clue how to set the Format to n0 and add a postfix string (the result should look like 10,045 FOO$). I've tried "n0 'FOO$'", but it keeps ignoring the n (so i dont get any separators). "0 'FOO$'" works, but does not give me the desired number format.

Cheers,

Jens

 

[Dess | Tech Support Engineer, Principal]

Hello Jens,

Thank you for writing back.

You can find useful information about specifying a format for numeric cells in the following help article: Standard Numeric Format Strings. In order to add a specific text next to the numeric value it is appropriate to use the CellFormatting event and set the Text property:
  

private void radPivotGrid1_CellFormatting(object sender, Telerik.WinControls.UI.PivotCellEventArgs e)
{
    if (e.CellElement.Row.Name.Contains("Freight") && e.CellElement.Text != string.Empty)
    {
        e.CellElement.Text = string.Format("{0:n3} FOO$", e.CellElement.Value);
    }
}

I hope this information helps. If you have any additional questions, please let me know.

Regards,
Dess
Telerik