Serialization GregorianCalender in the pivot cause to exception

[n/a]

 

Hi,

Our request relates to the solution “LocalDataSourceSerialization_WPF“  on PivotGrid/Serialization/LocalDataSourceProvider in your git examples.

When we run the following scenario, we get an exception (see the attached video) :

1. Run The solution.
2. Click on “Sum of quantity” to open the menu.
3. Click on “More Calculation Options...”.
4. Choose “% Of”.
5. Choose “Date-Month” as the Base field and one of the Base Items for example “June”.
6. Press Ok.
7. Click on “Save”.
8. The system crashed with the following error (attached image).

We would be happy if you would guide us on how we could overcome the problem.

 

[Dilyan Traykov]

Hello Luz,

As discussed in the support ticket you opened, you can resolve the issue by adding the GregorianCalendar to the list of KnownTypes:

    public class LocalDataSourceSerializer : DataProviderSerializer
    {
        public override IEnumerable<Type> KnownTypes
        {
            get
            {
                return PivotSerializationHelper.KnownTypes.Concat(new List<Type>() { typeof(GregorianCalendar) });
            }
        }
    }

This will, however, only work for projects targeting the .NET framework. In .NET Core, there is an issue that prevents the serialization of these fields: DCS/DCJS: CultureInfo is not serializable. With this said - you would need to skip these fields when performing the serialization to avoid the exception.

Regards,
Dilyan Traykov
Progress Telerik