Thank You Plamen.

Is there an alternative to this?

Thanks

Sangeetha

Hello Sangeetha,

I have been looking into your issue and there doesn’t seem to be a built-in functionality for that at this time. If you want I can create a Feature Request on your behalf so this can appear in a future release of ours.

Looking forward to hearing from you.

Hi Petar,

Why can't I use the approach in the following link where a Style is set for each cell and a converter is defined:

http://blogs.infragistics.com/forums/p/49331/297530.aspx

The only problem is, my converter does not seem to be working properly. Could you please tell me what I am doing wrong?

Here is my code:

My converter:

public class PivotGridDateConverter : IValueConverter
    {
        #region IValueConverter Members

        public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            string formattedDate = "";
            if (value != null)
            {
                try
                {
                    IMember member = value as Member;
                    DateTime dateTime = DateTime.Parse(member.Caption);
                    formattedDate = dateTime.ToString("dd-MMM-yyyy");                  
                }
                catch (Exception e)
                {
                    Microsoft.Windows.Controls.MessageBox.Show(e.Message);
                }
            }
            return formattedDate;

        }


        public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            return "";
        }

        #endregion
    }

Here is the template I use in my style

<local:PivotGridDateConverter x:Key="DateConverter" />
    <DataTemplate x:Key="DateTemplate" >
        <StackPanel Orientation="Horizontal">
            <TextBlock Name="dateCellPresenter" Text="{Binding Converter={StaticResource DateConverter}}" />           
        </StackPanel>
    </DataTemplate>

Thanks

Sangeetha

Hello Sangeetha,

Excuse me for the late reply. I have been looking into your issue for some time now and finally managed to come up with a custom approach that does what you want. I have put it into a sample project you can test out (PivotGrid_2.zip) where I have used a MultiValueConverter which would detect the different ContextMenu selections.

Please look through the sample and let me know if you require any further clarification on the matter.

Hi Petar,

Replacing IValueConverter with IMultiValueConverter did the trick. It works perfectly now.

Thanks

Sangeetha

Hi Sangeetha,

You can see how I have managed to get the format to come from the ComboBox in the top right corner through the binding in the sample I last sent. I used a MultiValueConverter in order to have a non-static format value. Now since the binging comes from it and from the cell values if there is a change in any of those the values are reconfigured.

Please let me know if you require any further clarification on the matter.

Hi Petar,

Thank You for your great solution. I used it to figure out what was wrong with mine - it works perfectly now. I had been setting the style to the PivotHeadercellControl instead of the PivotHeaderCell itself. Setting it to the PivotHeaderCell does not fire LayoutUpdated when the format is updated.

There is one other small thing that needs to be fixed. Right now I hardcode the format in the converter. I would like to set this format through the Converter's parameter.  In other words I want to see the format coming through in the following function. How can I do this?

public object Convert(object value, Type targetType, object parameter,  CultureInfo culture)

{ }

Thanks

Sangeetha

Hi Sangeetha,

Here is a new sample approach (PivotGrid_formatting_HeaderCells.zip). Please look into it and let me know if this is what you were looking for.

Looking forward to hearing from you.