This is a migrated thread and some comments may be shown as answers.

Format Decimal Value & Export Data

3 Answers 178 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Antje
Top achievements
Rank 1
Antje asked on 29 Jan 2013, 12:25 PM
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.

3 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 29 Jan 2013, 01:25 PM
Hi,

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.

0
Ryan
Top achievements
Rank 1
answered on 25 Jul 2014, 12:22 PM
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.

Regards
Ryan
0
Rosen Vladimirov
Telerik team
answered on 28 Jul 2014, 05:31 AM
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.

Regards,
Rosen Vladimirov
Telerik
 
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.
 
Tags
PivotGrid
Asked by
Antje
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Ryan
Top achievements
Rank 1
Share this question
or