This is a migrated thread and some comments may be shown as answers.

Date Formatting

11 Answers 193 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Alexandre
Top achievements
Rank 1
Alexandre asked on 17 Apr 2014, 07:43 AM
Hi,

When I use my date format on my RadGrid dd-MMM-yy i have on English 17-Apr-14 it's perfect when i export on Excel, he recognizes my date. But when i'm on French i have 17-Avr.-14 and Excel don't regcognized this date.

I want have 17-Avr-14 for have a good export.

Have you got a solution ?

Regards,
Alexandre

11 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 17 Apr 2014, 10:36 AM
Hi Alexander,

Please take a look at the sample code snippet. I was able to get the required output. Please provide your code snippet if this doesn't help.

ASPX:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridLocalisation.aspx.cs"
    Culture="fr-FR" Inherits="RadGrid8_GridLocalisation" %>
. . .
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadComboBox ID="RadComboBox1" runat="server" AutoPostBack="true" OnSelectedIndexChanged="RadComboBox1_SelectedIndexChanged">
        <Items>
            <telerik:RadComboBoxItem Text="Select" Value="" />
            <telerik:RadComboBoxItem Text="English - USA" Value="en-US" />
            <telerik:RadComboBoxItem Text="Bulgarian - Bulgaria" Value="bg-BG" />
            <telerik:RadComboBoxItem Text="French - France" Value="fr-FR" />
        </Items>
    </telerik:RadComboBox>
    <telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" AllowSorting="True" AutoGenerateColumns="false" AllowPaging="True" runat="server" GridLines="None">
        <ExportSettings Excel-Format="Html">
        </ExportSettings>
        <MasterTableView TableLayout="Fixed" CommandItemDisplay="Top" CommandItemSettings-ShowExportToExcelButton="true">
            <Columns>
                <telerik:GridBoundColumn DataField="OrderID" HeaderText="OrderID" UniqueName="OrderID">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="ShipName" HeaderText="ShipName" UniqueName="ShipName">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="ShipCity" HeaderText="ShipCity" UniqueName="ShipCity">
                </telerik:GridBoundColumn>
                <telerik:GridDateTimeColumn DataField="OrderDate" DataFormatString="{0:dd-MMM-yy}" HeaderText="OrderDate" UniqueName="OrderDate">
                </telerik:GridDateTimeColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    <br />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT [OrderID],[ShipCity],[OrderDate],[ShipName] FROM [Orders]">
    </asp:SqlDataSource>

C#:
protected void RadComboBox1_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
  Page.Culture = new CultureInfo(e.Value).ToString();
  RadGrid1.Culture = new CultureInfo(e.Value.ToString());   
  RadGrid1.Rebind();
}

Thanks,
Princy
0
Alexandre
Top achievements
Rank 1
answered on 17 Apr 2014, 12:17 PM

I use the same code than you but he doesn't work :(

this is my code (line 135 for my formated date)

 

001.<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/PageMaitre.Master" CodeBehind="Backlog.aspx.vb" Inherits="LOSCOM.Backlog" %>
002.<%@ MasterType VirtualPath="~/PageMaitre.Master"  %>
003.<%@ Register TagPrefix="custom" Namespace="AcbClasses" Assembly="AcbClasses"%>
004. 
005.<asp:Content ID="Content1" ContentPlaceHolderID="CPH_HTML_HEAD" runat="server">
006.</asp:Content>
007.<asp:Content ID="Content2" ContentPlaceHolderID="CPH_Menu" runat="server">
008.</asp:Content>
009.<asp:Content ID="Content3" ContentPlaceHolderID="CPH_Page" runat="server">
010.    <script type="text/javascript">
011.            function pageLoad() {
012.                var filter = $find("<%=RadFilter1.ClientID %>");
013.                filter.get_contextMenu().add_showing(function (sender, args) {
014.                    var currentExpandedItem = sender.get_attributes()._data.ItemHierarchyIndex;
015.                    var fieldName = filter._expressionItems[currentExpandedItem];                   
016.                    if (fieldName == "DAR") {
017.                        sender.findItemByValue("Contains").set_visible(false);
018.                        sender.findItemByValue("DoesNotContain").set_visible(false);
019.                        sender.findItemByValue("StartsWith").set_visible(false);
020.                        sender.findItemByValue("EndsWith").set_visible(false);
021.                    }
022.                    if (fieldName == "DAR_Transport") {
023.                        sender.findItemByValue("Contains").set_visible(false);
024.                        sender.findItemByValue("DoesNotContain").set_visible(false);
025.                        sender.findItemByValue("StartsWith").set_visible(false);
026.                        sender.findItemByValue("EndsWith").set_visible(false);
027.                    }                   
028.                });
029.            }
030.        </script>
031.         
032.<%--Gestion des erreurs de saisie--%> 
033.    <div ID="Erreur" class="erreur_div" runat="server">
034.        <asp:Label ID="lbl_err" runat="server" Text="" CssClass="erreur_texte" meta:resourcekey="lbl_err"></asp:Label>
035.    </div>   
036.<%--sources de données--%>
037.    <asp:SqlDataSource ID="dsBacklog" runat="server"
038.        ConnectionString="<%$ ConnectionStrings:CsParam %>"        
039.        SelectCommand="SELECT [CodeClient], [CodeClientLivraison], [NomClient], [DteLigne], [DDemCli], [DAR], [DAR_Transport], [NumCmd], [NumLigne], [Base_MFG], [Site], [Statut], [CodeArticle], [Description], [HPL], [GroupeArticle], [LivraisonPartielle], [NumCmdClient], [NumLigneClient], [CodeArticleClient], [CodeControle], [CodeMarquage], [QteCmd], [QteExped], [QteRestante], [QtePrelevee], [NumLCS], [Statut_LCS], [SousStatut], [DateModifSSStatut], [NomITC], [Nom_CSR], [Ship_date], [MajShipDate], [Receipt_date], [CSR_comments], [Porteur_client], [Porteur_produit], [Porteur_produit2], [Magasin], [Root_Cause], [MtHT], [MtHTDevise],  [MtLigne], [QteLigne] ,PUEuro, PUdevise, Devise FROM [Portefeuilles_csr]"></asp:SqlDataSource>
040.     
041.<%--gestion des favoris--%>
042. <favo:Favoris ID="Favoris1" runat="server" />
043.    <asp:Button ID="btn_parametre" runat="server" Text="Parametrage CSR" CssClass="ButtonFiltre"
044.        meta:resourcekey="btn_parametre" />
045. <%--gestion des filtres--%>      
046.    <br />
047.     <div class="wrapper">
048.    <telerik:RadFilter ID="RadFilter1" runat="server" Skin="Metro" CssClass="wrpleft">       
049.        <FieldEditors>                
050.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Customer account" FieldName="CodeClient" meta:resourcekey="CodeClientF"/>
051.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Delivery customer account" FieldName="CodeClientLivraison" meta:resourcekey="CodeClientLivraisonF"/>
052.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Customer name" FieldName="NomClient" meta:resourcekey="NomClientF"/>
053.            <telerik:RadFilterDateFieldEditor DataType="System.DateTime" DisplayName="Order placement date" FieldName="DteLigne" meta:resourcekey="DteLigneF"/>
054.            <telerik:RadFilterDateFieldEditor DataType="System.DateTime" DisplayName="Requested date" FieldName="DDemCli" meta:resourcekey="DDemCliF"/>                                         
055.            <custom:DateFiltre DataType="System.String" DisplayName="Acknowledged date" FieldName="DAR" meta:resourcekey="DARF"/>
056.            <custom:DateFiltre DataType="System.String" DisplayName="Ack.Date-T" FieldName="DAR_Transport" meta:resourcekey="DAR_TransportF"/>
057.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Souriau order" FieldName="NumCmd" meta:resourcekey="NumCmdF"/>
058.            <telerik:RadFilterNumericFieldEditor DataType="System.Int32" DisplayName="Souriau line" FieldName="NumLigne" meta:resourcekey="NumLigneF"/>
059.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Basis" FieldName="Base_MFG" meta:resourcekey="Base_MFGF"/>
060.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Site" FieldName="Site"/>
061.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Status" FieldName="Statut" meta:resourcekey="StatutF"/>
062.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Souriau PN" FieldName="CodeArticle" meta:resourcekey="CodeArticleF"/>
063.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Description" FieldName="Description"/>
064.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="HPL" FieldName="HPL"/>
065.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="PN group" FieldName="GroupeArticle" meta:resourcekey="GroupeArticleF"/>
066.            <telerik:RadFilterBooleanFieldEditor DisplayName="Partial delivery" FieldName="LivraisonPartielle" meta:resourcekey="LivraisonPartielleF"/>           
067.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="PO number" FieldName="NumCmdClient" meta:resourcekey="NumCmdClientF"/>
068.            <telerik:RadFilterNumericFieldEditor DataType="System.Int32" DisplayName="PO line" FieldName="NumLigneClient" meta:resourcekey="NumLigneClientF"/>
069.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Customer PN" FieldName="CodeArticleClient" meta:resourcekey="CodeArticleClientF"/>
070.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Control code" FieldName="CodeControle" meta:resourcekey="CodeControleF"/>
071.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Marking code" FieldName="CodeMarquage" meta:resourcekey="CodeMarquageF"/>
072.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Quantity ordered" FieldName="QteCmd" meta:resourcekey="QteCmdF"/>
073.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Quantity delivered" FieldName="QteExped" meta:resourcekey="QteExpedF"/>
074.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Remaining quantity" FieldName="QteRestante" meta:resourcekey="QteRestanteF"/>
075.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Quantity picked" FieldName="QtePrelevee" meta:resourcekey="QtePreleveeF"/>
076.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Souriau PL number" FieldName="NumLCS" meta:resourcekey="NumLCSF"/>
077.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Souriau PL status" FieldName="Statut_LCS" meta:resourcekey="Statut_LCSF"/>
078.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="PL sub-status" FieldName="SousStatut" meta:resourcekey="SousStatutF"/>
079.            <telerik:RadFilterDateFieldEditor DataType="System.DateTime" DisplayName="PL last modif dte" FieldName="DateModifSSStatut" meta:resourcekey="DateModifSSStatutF"/>
080.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="ITC name" FieldName="NomITC" meta:resourcekey="NomITCF"/>
081.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="CSR name" FieldName="Nom_CSR" meta:resourcekey="Nom_CSRF"/>
082.            <telerik:RadFilterDateFieldEditor DataType="System.DateTime" DisplayName="Ship date" FieldName="Ship_date"/>
083.            <telerik:RadFilterDateFieldEditor DataType="System.DateTime" DisplayName="Last update" FieldName="MajShipDate" meta:resourcekey="MajShipDateF"/>
084.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Receipt date" FieldName="Receipt_date" />
085.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="CSR comments" FieldName="CSR_comments" />
086.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Customer owner" FieldName="Porteur_client" meta:resourcekey="Porteur_clientF"/>
087.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Product owner" FieldName="Porteur_produit" meta:resourcekey="Porteur_produitF"/>
088.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Product owner 2" FieldName="Porteur_produit2" meta:resourcekey="Porteur_produit2F"/>
089.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Shipping dock" FieldName="Magasin" meta:resourcekey="MagasinF"/>
090.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Mt HT" FieldName="MtHT" meta:resourcekey="MtHTF"/>
091.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Mt HT Devise" FieldName="MtHTDevise" meta:resourcekey="MtHTDeviseF"/>
092.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Mt Ligne" FieldName="MtLigne" meta:resourcekey="MtLigneF"/>          
093.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="Qte Ligne" FieldName="QteLigne" meta:resourcekey="QteLigneF"/>
094.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="PU Devise" FieldName="PUDevise" meta:resourcekey="PUDeviseF"/>
095.            <telerik:RadFilterNumericFieldEditor DataType="System.Double" DisplayName="PU Euro" FieldName="PUEuro" meta:resourcekey="PUEuroF"/>
096.            <telerik:RadFilterTextFieldEditor DataType="System.String" DisplayName="Devise" FieldName="Devise" meta:resourcekey="DeviseF"/>
097.        </FieldEditors>
098.    </telerik:RadFilter>
099.  <asp:CheckBox ID="cbxRadFilter" runat="server" AutoPostBack="True" Text="Masquer la gestion des filtres"
100.            CssClass="wrpright" meta:resourcekey="cbxRadFilter" />
101.    </div>      
102.<%--définition de l'affichage--%>
103.    <telerik:RadGrid ID="RGBacklog" runat="server" AllowFilteringByColumn="True"
104.        PagerStyle-Mode="NextPrevNumericAndAdvanced" PageSize="50"
105.        AllowMultiRowSelection="True" Height="770px" Width="1200px"
106.        AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"
107.        Culture="fr-FR" DataSourceID="dsBacklog" ShowGroupPanel="True" Skin="Metro">      
108.        <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True" ColumnsReorderMethod="Reorder">
109.            <Selecting CellSelectionMode="None" AllowRowSelect="True"></Selecting>
110.            <Scrolling AllowScroll="True" UseStaticHeaders="True" FrozenColumnsCount="0"/>
111.            <Resizing AllowColumnResize="true" AllowRowResize="true" ShowRowIndicatorColumn="true" EnableRealTimeResize="true" ResizeGridOnColumnResize="False" AllowResizeToFit="true"/>
112.        </ClientSettings>
113.        <GroupingSettings CaseSensitive="false"/>
114.        <ExportSettings ExportOnlyData="true" OpenInNewWindow="true" IgnorePaging="true" FileName="Backlog" HideStructureColumns="True"></ExportSettings>
115.        <MasterTableView DataSourceID="dsBacklog" AllowMultiColumnSorting="true" CommandItemDisplay="Top" EnableHeaderContextMenu="true">
116.            <CommandItemTemplate>
117.                <table>
118.                    <tr>
119.                        <td> </td>                       
120.                        <td>
121.                            <asp:ImageButton runat="server" ID="ImageButton1" CommandName="ExportToExcel" ImageUrl="../Gen_Images/export.jpg" />                           
122.                        </td>
123.                        <td> </td>                       
124.                        <td>
125.                            <asp:ImageButton runat="server" ID="Actualiser" CommandName="ReBindGrid" ImageUrl="../Gen_Images/refresh.gif" />                           
126.                        </td>
127.                        <td>
128.                            <asp:Button ID="Button1" runat="server" Text="Actualiser" CommandName="ReBindGrid" BackColor="Transparent" ForeColor="White" BorderColor="Transparent"></asp:Button>
129.                        </td>                                                                       
130.                    </tr>
131.                </table>
132.            </CommandItemTemplate>           
133.                <Columns>
134.                    
135.                    <telerik:GridDateTimeColumn DataField="DteLigne" DataType="System.DateTime" DataFormatString="{0:dd-MMM-yy}"  Display="true"
136.                        FilterControlAltText="Filter DteLigne column" HeaderText="Order placement date" meta:resourcekey="DteLigneG"
137.                        SortExpression="DteLigne" UniqueName="DteLigne" FilterDelay="20000">
138.                    </telerik:GridDateTimeColumn>
139.                     
140.                </Columns>           
141.        </MasterTableView>
142.    </telerik:RadGrid>
143.</asp:Content>
144.<asp:Content ID="Content4" ContentPlaceHolderID="CPH_Footer" runat="server">
145.</asp:Content>


I attach my result

0
Princy
Top achievements
Rank 2
answered on 21 Apr 2014, 09:26 AM
Hi Alexandre,

Try setting the page culture while exporting as shown below:

VB:
Protected Sub RGBacklog_ItemCommand(sender As Object, e As GridCommandEventArgs)
    If e.CommandName = "ExportToExcel" Then
        Page.Culture = New CultureInfo("fr-FR").ToString()
    End If
End Sub

Thanks,
Princy
0
Alexandre
Top achievements
Rank 1
answered on 22 Apr 2014, 09:01 AM
Hi,

I have the same problem when i set the page culture ...

Maybe is a Telerik's Problem, he doesn't make a good formatting ?
0
Kostadin
Telerik team
answered on 25 Apr 2014, 07:12 AM
Hello Alexandre,

A possible solution is to set a date format by using the mso-number-format style attribute. Please check out the  following help article for additional details.

Regards,
Kostadin
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Alexandre
Top achievements
Rank 1
answered on 25 Apr 2014, 08:05 AM
Hi Kostadin,

I have try to set my date format by using the mso-number-format before your reply and i have try again when i have read your answer

Same problem ...
0
Alexandre
Top achievements
Rank 1
answered on 29 Apr 2014, 07:09 AM
Maybe it's a Telerik problem ?
0
Kostadin
Telerik team
answered on 30 Apr 2014, 07:57 AM
Hello Alexandre,

I prepared a small sample where I set a date format OnExportCellFormatting and the format is applied properly in the exported file. Please give it a try and let me know how it differs from your real setup.

Regards,
Kostadin
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Alexandre
Top achievements
Rank 1
answered on 30 Apr 2014, 08:51 AM
Hello Kostadin,

Thx for your answer, i have try but the format isn't applied.

I attach you my result.
0
Accepted
Kostadin
Telerik team
answered on 07 May 2014, 07:09 AM
Hi Alexandre,

It looks like the format set by the DataFormatString property of the column overrides the one set by the mso-number-format attribute. In order to apply the format set in the code behind you have to suppress the format of the column by enabling the SuppressColumnDataFormatStrings property. Please check out the following code snippet.
<ExportSettings ExportOnlyData="true" OpenInNewWindow="true" IgnorePaging="true" SuppressColumnDataFormatStrings="true" FileName="Backlog" HideStructureColumns="True">
</ExportSettings>

Regards,
Kostadin
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Alexandre
Top achievements
Rank 1
answered on 27 May 2014, 12:22 PM
Hi,

Export works ! Thank you !

Regards,
Alexandre
Tags
Grid
Asked by
Alexandre
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Alexandre
Top achievements
Rank 1
Kostadin
Telerik team
Share this question
or