Abreviate month for 'fr-FR' not compatible with Excel

[Anne]

Hi,

The data format string 'MMM' display a point (janv.) with culture 'fr-FR'.
But when whe export data in Excel, it is not recognize like a date and user can't change display for another date format.

Can you help me to display abreviate month without point like 'en-GB', for compatibility with Excel date format.
Anne

Precisions :

DataFormatString

 

="{0:dd-MMM-yy}" = 03-janv.-11 (fr-FR)

 

DataFormatString="{0:dd-MMM-yy}" = 03-jan-11 (en-GB)

 

[Daniel]

Hello Anne,

You shouldn't change the number format directly as Microsoft Excel won't recognize the dates properly. Instead, leave the values in their default format and use mso-number-format style to set it to French.
For more information, please examine the following link:
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team

[Anne]

Hello Daniel,

Thanks for your anwer.

I add this code :

Private Sub MyRadGrid_ExportCellFormatting(ByVal sender As Object, ByVal e As Telerik.Web.UI.ExportCellFormattingEventArgs) Handles MyRadGrid.ExportCellFormatting
        Select Case e.FormattedColumn.UniqueName
           Case "MyDate"
                If sculture = "fr-FR" Then
                    e.Cell.Style("mso-number-format") = "dd-MMM-yy"
                End If
                Exit Select
             End Select
    End Sub

And in Excel, it is the same result : 03-janv.-11

Why Telerik Grid display a point ?

Regards,
Anne

[Daniel]

Hello Anne,

Please test the attached project and let me know whether it works properly at your side.

Regards,
Daniel
the Telerik team

[Anne]

Hello Daniel,

I tested your project which works properly on my PC (VS2008).

On my owner project, I delete the DataFormatString on a datetime column of my RadGrid. The Format of excel export is good
dd-MMM-yy = 03-janv-11

But I don't want delete the DataFormatString of my RadGrid.

Regards,
Anne

[Daniel]

Hello Anne,

You don't have to drop the DataFormatString properies. The solution is simple - in the export button's handler (when using external button) or in the ItemCommand event (when using the built-in buttons) traverse all columns and clear the aforementioned property. This setup won't break the existing functionality of your website.

Regards,
Daniel
the Telerik team