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

2 posts, 1 answers
  1. Peter
    Peter avatar
    2 posts
    Member since:
    Sep 2012

    Posted 23 Apr 2013 Link to this post


    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.
  2. Answer
    Peter avatar
    1153 posts

    Posted 25 Apr 2013 Link to this post

    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,
    the Telerik team
    WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
Back to Top