This is a migrated thread and some comments may be shown as answers.
PivotGrid - Grand total translation, Group date cell format, Click event
1 Answer 52 Views
This is a migrated thread and some comments may be shown as answers.
Peter
Top achievements
Rank 1
Peter asked on 23 Apr 2013, 07:21 PM
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.

1 Answer, 1 is accepted

Sort by
0
Accepted
Peter
Telerik team
answered on 25 Apr 2013, 01:09 PM
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
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
Asked by
Peter
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or