[Solved] Export to excel - cell background is ignored

[Alexey]

Hi! Even if i do this:

        private void gridViewCalc_ElementExporting(object sender, GridViewElementExportingEventArgs e)
        {
            e.Background = Colors.LightGray;
            e.Foreground = Colors.Black;
            e.FontSize = 20;
        }

        private void calcExport_Click(object sender, RoutedEventArgs e)
        {
            if (gridViewCalc.Visibility == Visibility.Visible)
            {
                SaveFileDialog dialog = new SaveFileDialog();
                dialog.DefaultExt = "xls";
                dialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
                dialog.FilterIndex = 1;


                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 = true;
                        gridViewCalc.Export(stream, exportOptions);
                    }
                }
            }
        }

All cells are white and it seems like default. What is wrong with my code?

[Vlad]

Hi,

 Currently the grid can export styles only in HTML format.

Greetings,
Vlad
the Telerik team

[Alexey]

But in demo it works?:

http://demos.telerik.com/silverlight/#GridView/Exporting

[Vlad]

Hi,

 In the demo the grid with styles is exported in HTML format however with XLS extension. 

Best wishes,
Vlad
the Telerik team