Format Decimal Value & Export Data

[Antje]

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.

[Rosen Vladimirov]

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

[Ryan]

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

[Rosen Vladimirov]

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