format cell in PivotGrid

Hi Kobus,

Thank you for the image.

To format the separators in the RadPivotGrid you have to subscribe to the CellFormatting event , which fires when the cell element is updated and allows you to customize its appearance. In addition for the alignment, you need to use the TextAlignement property of the CellElement and for the GradientStyle, you have to set two other properties - DrawFill and BackColor.

this.radPivotGrid1.CellFormatting += RadPivotGrid1_CellFormatting;
private void RadPivotGrid1_CellFormatting(object sender, PivotCellEventArgs e)
{
    e.CellElement.TextAlignment = ContentAlignment.MiddleRight;
    e.CellElement.DrawFill = true;
    e.CellElement.BackColor = Color.Black;
    e.CellElement.GradientStyle = Telerik.WinControls.GradientStyles.Solid;
    e.CellElement.ForeColor = Color.LightGreen;
}

I am sending you a link to the documentation as well: Properties, Methods, Events

For the String.Format error you have to change your code like this because the provided code snippet doesn't seem to be valid, I am giving you an example:

decimal number = 123;
string element = e.CellElement.Text = String.Format("{0:N3}", number);

Regards,
Maria
Progress Telerik