Change PivotGrid language via ResourceManager

4 posts, 0 answers
  1. Paweł
    Paweł avatar
    46 posts
    Member since:
    May 2013

    Posted 25 Nov 2013 Link to this post

    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):
    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!

    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 :
    Don't need help for @EDIT - found that: and works great ;)
  2. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 25 Nov 2013 Link to this post

    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.

    Rosen Vladimirov
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. Кустутинов
    Кустутинов avatar
    1 posts
    Member since:
    Nov 2014

    Posted 27 Nov 2014 in reply to Rosen Vladimirov Link to this post

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

  4. Polya
    Polya avatar
    238 posts

    Posted 01 Dec 2014 Link to this post

    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">
            <testData:OrdersSource />
            <pivot:PropertyGroupDescription PropertyName="Product" />
            <pivot:PropertyAggregateDescription PropertyName="Quantity" />

    Hopefully this helps.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top