PivotGrid - Grand total translation, Group date cell format, Click event

[Peter]

Hi,

I am using PivotGrid (Q1 2013 SP1) and I have some questions about it:

1) Is possible to translate "Grand Total" header text?
2) I am grouping table data using of DateTimeGroupDescription. Is possible to format date as dd.MM.yyyy (now it is Apr-22, but I want 22.04.2013) in group cell?
3) How can I react on user clicked on cell? I can not find some CellClick or DoubleCellClick event.

[Peter]

Hello Peter,

Directly to your questions:

1) For the time being this functionality is not supported by our RadPivotGrid and this text cannot be changed. A request for such is already logged. Feel free to add your vote for it here: http://www.telerik.com/support/pits.aspx#/details/Issue=14307

2) You cannot change the Date format. I have logged this as a feature request in our Public Issue Tracking System - PITS. You can track its progress, subscribe for status changes and add your vote/comment to it on the following link - http://www.telerik.com/support/pits.aspx#/public/winforms/14891 

3) You should handle the pivot grid Click event and get the cell under mouse:

void radPivotGrid1_Click(object sender, EventArgs e)
{
    PivotCellElement cell = this.radPivotGrid1.ElementTree.GetElementAtPoint(((MouseEventArgs)e).Location) as PivotCellElement;
    if (cell!=null)
    {
        MessageBox.Show("Clicked " + cell.FormattedValue);
    }
}

Should you have any other questions or suggestions, do not hesitate to contact us.

Kind regards,
Peter
the Telerik team