Change PivotGrid language via ResourceManager

[Paweł]

Hi.
I'd like to know is there any way to change two labels in pivotGrid (actually i found site with resource names and changed that to polish, but some of them are still in english version):

http://puu.sh/5sKXm.png
I need to change Grand Total and I need to change month names (from eng to pl) when user filter data using DateTime.

Thanks in advance!

@EDIT
One more question ;) Is there any way to save user settings and restore them whenever user open window with pivotgrid? I'd like to save somewhere Filter, row, column labels, so it will be everything from there : http://puu.sh/5sL2H.png
Don't need help for @EDIT - found that: http://www.telerik.com/community/forums/wpf/pivotgrid/saving-the-radpivotgrid-localdatasourceprovider.aspx and works great ;)

[Rosen Vladimirov]

Hello Pawel,

You can check this help article, which describes almost all keys used to localize RadPivotGrid. The key for GrandTotal is Pivot_GrandTotal. Unfortunately you are not able to localize the name of the months - this issue is still in our to do list. The only way to use your own names is to create your own implementation of PropertyGroupDescriptionBase and set the names of the months in it.

As for your second question - the forum you have found is not up to date. The project in it contains a workaround for the missing serialization feature. With our 2013 Q2 release we have provided an easier way to achieve this. I suggest you to take a look at the following resources:
 - Serialize LocalDataSourceProvider Settings help article
 - Persist LocalDataSourceProvider Settings via RadPersistenceFramework - help article

The same articles are available within OLAP provides section of our online help. You can also take a look at our samples in XAML SDK.

Hopefully this helps. Feel free to contact us in case you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik

[Кустутинов]

Hi, You decide on the issue by transferring the names of the month and quarter? (April, May and ..., Q1, Q2, ...)

thanks.

[Polya]

Hello Кустутинов,

With our Q2 release of Telerik UI for WPF we included localization of month names and UI culture support for LocalDataSourceProvider.
Setting the LocalDataSourceProvider.Culture property to any desired culture will now apply it to month names, how numeric values are presented ( , or . ), how weeks are calculated.

<pivot:LocalDataSourceProvider x:Key="DataProvider" Culture="pl-PL">
    <pivot:LocalDataSourceProvider.ItemsSource>
        <testData:OrdersSource />
    </pivot:LocalDataSourceProvider.ItemsSource>
    <pivot:LocalDataSourceProvider.RowGroupDescriptions>
        <pivot:PropertyGroupDescription PropertyName="Product" />
    </pivot:LocalDataSourceProvider.RowGroupDescriptions>
    <pivot:LocalDataSourceProvider.AggregateDescriptions>
        <pivot:PropertyAggregateDescription PropertyName="Quantity" />
    </pivot:LocalDataSourceProvider.AggregateDescriptions>
</pivot:LocalDataSourceProvider>

Hopefully this helps.

Regards,
Polya
Telerik