Problem with export of column's footer

[Viki]

Hi,
I have a following footer:

in XAML:

<telerik:GridViewColumn.FooterCellStyle>
                        <Style TargetType="telerik:GridViewFooterCell">
                            <Setter Property="ContentTemplate">
                                <Setter.Value>
                                    <DataTemplate>
                                        <TextBlock Text="{Binding Text, ElementName=txtTest}"/>
                                    </DataTemplate>
                                </Setter.Value>
                            </Setter>
                        </Style>
                    </telerik:GridViewColumn.FooterCellStyle>


<TextBlock Grid.Row="3" Grid.Column="1" x:Name="txtTest" Text="Employee name: "/>

============================================================
in C#:

txtTest.Text += m_EmployeeReport.EmployeeName;

that works fine, but when I try to export it to Excel, I don't get it, my export options as follows:

if (dialog.ShowDialog() == true)
                {
                    using (Stream stream = dialog.OpenFile())
                    {
                        GridViewExportOptions exportOptions = new GridViewExportOptions();
                        exportOptions.Format = ExportFormat.ExcelML;
                        exportOptions.ShowColumnFooters = true;
                        exportOptions.ShowColumnHeaders = true;
                        exportOptions.ShowGroupFooters = false;

                        gridEmployeeResult.Export(stream, exportOptions);
                    }

I tried the simple footer, without binding, as follows:

<telerik:GridViewDataColumn.Footer>
           <TextBlock Text="HELLO"/>
</telerik:GridViewDataColumn.Footer>

I see it on the grid, but I don't get it on export to Excel

What I'm doing wrong?

Thanks,
Viki

[Maya]

Hi Viki,

Please take a look at this demo for a reference.
 

Kind regards,
Maya
the Telerik team

[Ryan]

Maya,

I can't get the footer to export to Excel either. I'm actually using the code form the demo you pointed to in your link. The Footer export fine when I use AggregateFunctions. They however do not export when I do either of the following.

1.

<telerik:GridViewDataColumn
     CellStyle="{StaticResource RadGridViewCellStyle}"
     DataMemberBinding="{Binding Tank.Name}"
     Header="Tank"
     IsReadOnly="True"
     Footer="Totals:"
/>

2.

<telerik:GridViewDataColumn CellStyle="{StaticResource RadGridViewCellStyle}" DataMemberBinding="{Binding Tank.Name}" Header="Tank" IsReadOnly="True">
    <telerik:GridViewDataColumn.Footer>
        <TextBlock Text="Totals:" />
    </telerik:GridViewDataColumn.Footer>
</telerik:GridViewDataColumn>

[Vlad]

Hello,

 Have you tried to assign e.Value according to your custom footer in ElementExporting event?

All the best,
Vlad
the Telerik team

[Ryan]

Vlad,

Yes, I have tried to assign it there. When I was looking through e.Context to find the value I wanted to use I didn't see it in context.

Thank you,
Ryan Duclos

[Vlad]

Hi,

You can find an example project attached. 

Regards,
Vlad
the Telerik team

[Ryan]

Vlad,

Thanks, the demo application works perfectly. I think I may have been looking at the wrong ExportElement when parsing through e.Context. Either way I have it working now. Thanks, again.