Format Decimal Value & Export Data

4 posts, 0 answers
  1. Antje
    Antje avatar
    9 posts
    Member since:
    Oct 2012

    Posted 29 Jan 2013 Link to this post

    Hello Telerik-Team,

    i tried the Pivot Grid and it ist really nice and easy to use.

    But I have two questions:

    1. Is there any possibility to use different currencies when formatting a decimal value? When I use "C" in "StringFormat" my current culture is used...

    2. Can i export the data that is displayed in the control to use in excel or to print?

    Thanks for your help.
  2. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 29 Jan 2013 Link to this post


    Thank you for choosing RadPivotGrid. You can use StringFormat property to set another currency, for example:
    <pivot:PropertyAggregateDescription PropertyName="Price" StringFormat="#.##$" AggregateFunction="Average" />

    You may also use the integrated dialog in our RadPivotFieldList to change the String Format at runtime - just click on your aggregate description in the "Values" section and from the dropdown menu select Number format.
    For your second question - currently you are not able to export the data to excel or to print it. This feature is in our to-do list and it will be available in the near future. We are sorry for the caused inconvenience.

    Do not hesitate to contact us if you have any problems or concerns.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. Ryan
    Ryan avatar
    4 posts
    Member since:
    Jul 2014

    Posted 25 Jul 2014 in reply to Rosen Vladimirov Link to this post

    Hi Rosen

    Has there been any progress on this issue as it is rather an important feature.

    If not are there any work arounds available.

  4. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 28 Jul 2014 Link to this post

    Hi Ryan,

    Export to Excel is available with RadPivotGrid for more than a year. You can check this article for more details how to achieve it. You can download a runnable example from our SDK repository.

    Hope this helps.

    Rosen Vladimirov
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
Back to Top