Issue in RadGrid Export to Excel functionality

[Ruchi]

Hi Team,

      We are binding radgrid from server side,  and using default Export to Excel functionality. The problem area is when we export the excel we are getting Extra Words like "Sorted ascSorted desc" in Column Header along with Column Name. We have tried few related properties of export settings but failed to resolve the issue. For your reference attaching problematic excel screenshot and also grid settings below.

Please do needful as soon as possible.

Thanks.

            RadAjaxLoadingPanel RadajaxloadingpanelTestdata = new RadAjaxLoadingPanel();
            RadajaxloadingpanelTestdata.ID = "Radajaxloadingpanel_AccActWidget_" + WidMapID;
            this.Controls.Add(RadajaxloadingpanelTestdata);

            RadAjaxPanel panel_testdata = new RadAjaxPanel();
            panel_testdata.ID = WidMapID;

            RadGrid rgTestData = new RadGrid();
            rgTestData.ID = WidMapID;
            rgTestData.AllowPaging = true;
            rgTestData.AllowSorting = true;
            rgTestData.AutoGenerateColumns = false;
            rgTestData.ExportSettings.IgnorePaging = true;
            rgTestData.ExportSettings.ExportOnlyData = true;
            rgTestData.ExportSettings.Excel.Format.Equals("Biff");
            rgTestData.ExportSettings.HideStructureColumns = true;
            rgTestData.ExportSettings.FileName = "CountsOfTestsLoaded";
            rgTestData.ExportSettings.Pdf.ForceTextWrap = true;
            rgTestData.MasterTableView.DataKeyNames = new string[] { "VerifyDate" };
            rgTestData.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Bottom;
            rgTestData.MasterTableView.ClientDataKeyNames = new string[] { "VerifyDate" };
            rgTestData.MasterTableView.CommandItemSettings.ShowAddNewRecordButton = false;
            rgTestData.MasterTableView.CommandItemStyle.Height.Equals("22px");
            rgTestData.MasterTableView.CommandItemStyle.HorizontalAlign = HorizontalAlign.Right;
            rgTestData.MasterTableView.PagerStyle.AlwaysVisible = true;
            rgTestData.MasterTableView.PagerStyle.Mode.Equals("NextPrevAndNumeric");
            rgTestData.ShowHeader = true;
            rgTestData.ClientSettings.Selecting.AllowRowSelect = true;
            rgTestData.MasterTableView.CommandItemTemplate = new MyCommandItemTemplate() { IsRefresh = true, IsExcel = true, IsPdf = true, IsCsv = true };
            BoundColumns(rgTestData);
            panel_testdata.ClientEvents.OnRequestStart = "onRequestStartTestData";
            panel_testdata.LoadingPanelID = RadajaxloadingpanelTestdata.ClientID;
            this.Controls.Add(panel_testdata);
            panel_testdata.Controls.Add(rgTestData);

[Nils C.]

Hi there.

Did you find a solution for this yet?

We are facing the same issue..

[Ruchi]

Hi Nils,

We haven't got any solution for this. Please let us know if you fiund.

 

Thanks,

Ruchi Patel

[Kostadin]

Hi Ruchi,

We are aware of this issue and I am afraid this is a bug in the binary export formats (Biff, Xlsx and Docx). Nevertheless, our developers already fixed the issue and it will be included in our next official release which will be available till the end of the week. Meanwhile as a workaround you can manually disable the sorting when export the grid.

protected void btnExport_Click(object sender, EventArgs e)
{
    MyRadGrid.AllowSorting = false;
    if (!MyRadGrid.ExportSettings.IgnorePaging)
    {
        MyRadGrid.Rebind();
    }
    MyRadGrid.MasterTableView.ExportToExcel();
}

Regards,
Kostadin
Telerik

[Ruchi]

Hi Kostadin,

Thank you for suggestion the but sorry that didn't work. still I am getting the extra text in the column header.

Thanks,

Ruchi Patel

[Kostadin]

Hi Ruchi,

I tried to replicate the issue on my side but I was unable to. Could you please check out the attached sample and let me know how it differs from your real setup? I would appreciate if you can replicate the issue in the attached sample and let me know how you modified it.

Regards,
Kostadin
Telerik

[David]

You may try to use the InfrastructureExporting Event on the RadGrid.  Not sure about the performance if theres many columns.

01.Dim hrow As Telerik.Web.UI.ExportInfrastructure.Row = e.ExportStructure.Tables(0).Rows(1)
02.        For Each hcell As Telerik.Web.UI.ExportInfrastructure.Cell In hrow.Cells
03.            If hcell.Text.Contains("Sorted asc") Then
04.                hcell.Value = hcell.Text.Replace("Sorted asc", "")
05.            End If
06.            If hcell.Text.Contains("Sorted desc") Then
07.                hcell.Value = hcell.Text.Replace("Sorted desc", "")
08.            End If
09.        Next hcell

[David]

Im sorry for the VB and formatting.  It does look like the newest release fixes this. However, if you still need it.

Telerik.Web.UI.ExportInfrastructure.Row hrow = e.ExportStructure.Tables(0).Rows(1);


foreach (Telerik.Web.UI.ExportInfrastructure.Cell hcell in hrow.Cells) {

    if (hcell.Text.Contains("Sorted asc")) {
        hcell.Value = hcell.Text.Replace("Sorted asc", "");

    }


    if (hcell.Text.Contains("Sorted desc")) {
        hcell.Value = hcell.Text.Replace("Sorted desc", "");

    }

}

[Elena]

I updated to the latest telerik version but I'm still seeing the Sorted ascSorted desc text when I export my document.  I have turned off sorting MasterTableView.AllowSorting = false; when I hit the command but it's not working.  I even tried to overwrite the column name but it's overwriting the name but still adding the extra code.  Please help!

[Kostadin]

Hello Elena,

Could you please verify that you can replicate the issue from my previous reply? Additionally could you please let me know which version you are using in your project?

Regards,
Kostadin
Telerik

[Elena]

I didn't try to replicate your issue but I tried the available fix and it wasn't working.  I tried 2 versions:  Q1 2016

2016 1 113 40
2016 1 315

I ended up re-writing it and using the Spreadsheet dll.

[Kostadin]

Hi Elena,

I ma glad you were able to find a solution for your case. Nevertheless, if you manage to isolate the issue in a small runnable sample we will investigate it locally and provide you with a proper solution.

Regards,
Kostadin
Telerik

[Thomas]

I've been coming across the same issue. Had to replace the column header characters to get the "Sorted ascSorted dec" text removed.

 

Has there been any progress on a potential fix for this problem?

[Kostadin]

Hello Thomas,

Could you please verify that the issue could be observer with the latest version of the Telerik UI for ASP.NET. If you do I would appreciate if you can replicate the issue in a small runnable sample and send it to us for further investigation.

Regards,
Kostadin
Telerik by Progress

[Julien]

Hi,

I'm having the same issue.

Telerik version : 2017.2.711.45

Exporting to Html Excel

[Lars]

Has this ever been fixed? Because I am getting the same headers when exporting to Excel from the grid in version 2019.1.215.45:

DateSorted ascSorted desc TypeSorted ascSorted desc DescriptionSorted ascSorted desc Paid valueSorted ascSorted desc Market valueSorted ascSorted desc Discount%Sorted ascSorted desc

 

[Attila Antal]

Hi Lars,

The issue seems to be available even with the latest version of Telerik controls. For a workaround, please visit the Bug item at When sort a grid with LightWeight render mode and export to Excel Biff format the sort expression is added to the header cells and check out the comments section.

Kind regards,
Attila Antal
Progress Telerik

[Vakul]

Hi Team,

I am getting issue with headers where Sorted AscSorted Desc are appending with headers while exporting. I have used OnCommand="OnGridCommand" client event in RadGrid.

If i remove this event then it works fine, but using this causing above issue. Please help on this.

[Attila Antal]

Hi Vakul,

Please visit the Bug Report I have shared above and check its Comment section to see the workaround for this problem.

Kind regards,
Attila Antal
Progress Telerik

[Vakul]

Attila, Thanks for the Reply.

 

I have checked the workaround you have provided in the link for same problem. It works with the grid headers, But causing issue with the GridColumnGroup used in the group. The headers with group columns works fine, but fails at GridColumnGroup level.

- Sorted ascSorted desc are showing in GridColumnGroup child headers.

- Using GridColumnGroup in the grid is causing another issue. In export, headers used after GridColumnGroup are not showing correct.

 

Please find attachment as below:

[Attila Antal]

Hi Vakul,

Thank you for the screenshot and additional clarification. Those from the screenshot are MultiColumnHeaders and I assumed you were having this problem with the Grouping functionality. Can you please share the Grid markup as well? I would like to take a look at it.

Kind Regards,
Attila Antal
Progress Telerik

[Vakul]

Hi Attila,
Thanks for the Quick reply. Yes, I am using Multi Columns.Headers. I was not able to attach file with zip or txt. So, I am pasting the code here.

 

<telerik:RadGrid ID="radGridScoreResults" runat="server" AllowSorting="True" GridLines="Both" RenderMode="Lightweight"  AllowMultiRowEdit="false" AllowMultiRowSelection="false" AutoGeneScoreColumns="false" AllowPaging="True"  OnNeedDataSource="radGridScoreResults_NeedDataSource" OnItemCommand="radGridScoreResults_ItemCommand" OnItemDataBound="radGridScoreResults_ItemDataBound"
    OnPageSizeChanged="radGridScoreResults_PageSizeChanged" OnPageIndexChanged="radGridScoreResults_PageIndexChanged" OnPreRender="radGridScoreResults_PreRender">
    <PagerStyle Mode="NextPScoreNumericAndAdvanced" AlwaysVisible="true" />
    <MasterTableView AllowMultiColumnSorting="False" CommandItemDisplay="Top" DataKeyNames="Score_Components_Model_Id, Score_Components_User_Id"
        HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" ItemStyle-HorizontalAlign="Left" AllowPaging="True" AllowCustomPaging="true"
        ItemStyle-VerticalAlign="Middle" Name="Detail" CssClass="divitem" ItemStyle-Height="21px" AlternatingItemStyle-Height="21px" Width="100%">
        <ColumnGroups>
            <telerik:GridColumnGroup Name="ghdrMinScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Min Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrRecScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Rec Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrFinalScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Final Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrComponentScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Component Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
        </ColumnGroups>
        <Columns>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdCHK" Visible="true">
                <ItemStyle Width="30px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="30px" Wrap="True" HorizontalAlign="Center" />
                <HeaderTemplate>
                    <asp:CheckBox ID="chk1" runat="server" onclick='javascript:SelectAllCheckboxesFromWorkFlowGrid(this, "radGridScoreResults");' />
                </HeaderTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="chk2" runat="server" onclick="javascript:SelectChildCheckBoxes();" />
                </ItemTemplate>
                <HeaderStyle Width="30px" HorizontalAlign="Center" />
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources: Score, DOW%>" Resizable="false"
                SortExpression="DOW" UniqueName="ghdrAddDOW">
                <ItemStyle Width="100px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="100px" Wrap="True" />
                <ItemTemplate>
                    <asp:Label ID="lblDOW" runat="server" Text='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'
                        ToolTip='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Min_Score" UniqueName="ghdrModelMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelMinScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScoreExp" ColumnGroupName="ghdrMinScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserMinScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserMinScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99" Enabled='<%#Eval("Use_Min_Charge") %>'
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                        <%-- AutoPostBack="true" OnTextChanged="txtUserMinScore_TextChanged"--%>
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Rec_Score" UniqueName="ghdrModelRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelRecScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScoreExp" ColumnGroupName="ghdrRecScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserRecScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserRecScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChk" HeaderText="Use Model">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:CheckBox ID="chk10" runat="server"  />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChkExp" HeaderText="Use Model" Visible="false">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblUseModel" runat="server" Text='<%# Eval("Use_Model") %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Score Band" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorName" Visible="false">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorName" runat="server" Text='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_BAND %>" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorCode">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center" CssClass="NoHoverSelected"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorCode" runat="server" Text='<%# Eval("Color_Code")%>' ToolTip='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="Is Default Score" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrIsDefaultScore" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblIsDefaultScore" runat="server" Text='<%# Eval("Is_Scored_Enabled")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalModelSc" runat="server" Text='<%# Eval("Final_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalModelScore" ForeColor="black" Text='<%#Eval("Final_Model_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalUserSc" runat="server" Text='<%# Eval("Final_User_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalUserScore" ForeColor="black" Text='<%#Eval("Final_User_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScoreExp" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeDenModelScore" runat="server" Text='<%# Eval("Relative_Density_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeDensityScore" ForeColor="black" Text='<%#Eval("Relative_Density_Model_Score")%>' Enabled='<%# Eval("Is_Scored_Enabled")%>'
                        runat="server" CommandName="RelDensityModel" ToolTip='<%# Eval("Relative_Density_Model_Scale")%>' CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Score"
                UniqueName="ghdrRelScoreModelScoreExp" Visible="false" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeScoreModelScore" runat="server" Text='<%# Eval("Relative_Score_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Relative_Score_Model_Score"
                UniqueName="ghdrRelScoreModelScore" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeScoreScore" ForeColor="black" Text='<%#Eval("Relative_Score_Model_Score")%>'
                        runat="server" CommandName="RelScoremodel" ToolTip='<%#Eval("Relative_Score_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, YIELD %>" Resizable="false" SortExpression="Yield_Model_Score"
                UniqueName="ghdrYieldModelScore" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblComponentYield" runat="server" Text='<%# Eval("Yield_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, PAYMENT %>" Resizable="false" SortExpression="Payment_Model_Score"
                UniqueName="ghdrPaymentModelScoreExp" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblPaymentModelSc" runat="server" Text='<%# Eval("Payment_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScoreExp" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeUsgeModelScore" runat="server" Text='<%# Eval("Relative_Usage_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeUsageModelScore" ForeColor="black" Text='<%#Eval("Relative_Usage_Model_Score")%>'
                        runat="server" CommandName="RelAllotmentUsageModel" ToolTip='<%#Eval("Relative_Usage_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScoreExp" Visible="false">
                <ItemStyle Width="90px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="90px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFMSModelScore" runat="server" Text='<%# Eval("Flight_Market_Share_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScore" Visible="true">
                <ItemStyle Width="115px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="115px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFMSModelScr" ForeColor="black" Text='<%#Eval("Flight_Market_Share_Model_Score")%>'
                        runat="server" CommandName="FMS" ToolTip="Details" CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
        <EditFormSettings>
            <EditColumn UniqueName="EditCommandColumn1">
            </EditColumn>
        </EditFormSettings>
        <CommandItemTemplate>
            <table style="height: 3px;">
                <tr>
                    <td>
                        <asp:LinkButton ID="lbExportToExcel" Class="link margin_right_nav" runat="server" OnClick="btnExportToExcel_Click" ToolTip="<%$ Resources:Common , EXPORT_EXCEL %>" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_excel.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToPDF" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_PDF %>" OnClick="btnExportToPDF_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_pdf.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToCSV" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_CSV %>" OnClick="btnExportToCSV_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_csv.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbPrint" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , PRINT %>" OnClick="btnPrint_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/print.png">
                        </asp:LinkButton>
                    </td>
                </tr>
            </table>
        </CommandItemTemplate>
        <EditFormSettings>
            <EditColumn Visible="false">
            </EditColumn>
        </EditFormSettings>
    </MasterTableView>
    <ClientSettings AllowColumnHide="True" AllowColumnsReorder="False" ReorderColumnsOnClient="False"
        EnableRowHoverStyle="true">
        <Selecting AllowRowSelect="True" />
        <Scrolling AllowScroll="true" UseStaticHeaders="True" />
        <ClientEvents OnGridCreated="radGrid_OnGridCreated" OnCommand="OnGridCommand" />
    </ClientSettings>
    <ExportSettings>
        <Pdf AllowPrinting="true" PageWidth="450mm" PageHeight="210mm" Title="Report Title" ForceTextWrap="true"
            PageFooterMargin="10mm" PageHeaderMargin="10mm" PageLeftMargin="10mm" PageRightMargin="10mm" />
    </ExportSettings>
</telerik:RadGrid>

<telerik:RadGrid ID="radGridScoreResults" runat="server" AllowSorting="True" GridLines="Both" RenderMode="Lightweight"
    AllowMultiRowEdit="false" AllowMultiRowSelection="false" AutoGeneScoreColumns="false" AllowPaging="True"
    OnNeedDataSource="radGridScoreResults_NeedDataSource" OnItemCommand="radGridScoreResults_ItemCommand" OnItemDataBound="radGridScoreResults_ItemDataBound"
    OnPageSizeChanged="radGridScoreResults_PageSizeChanged" OnPageIndexChanged="radGridScoreResults_PageIndexChanged" OnPreRender="radGridScoreResults_PreRender">
    <PagerStyle Mode="NextPScoreNumericAndAdvanced" AlwaysVisible="true" />
    <MasterTableView AllowMultiColumnSorting="False" CommandItemDisplay="Top" DataKeyNames="Score_Components_Model_Id, Score_Components_User_Id"
        HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" ItemStyle-HorizontalAlign="Left" AllowPaging="True" AllowCustomPaging="true"
        ItemStyle-VerticalAlign="Middle" Name="Detail" CssClass="divitem" ItemStyle-Height="21px" AlternatingItemStyle-Height="21px" Width="100%">
        <ColumnGroups>
            <telerik:GridColumnGroup Name="ghdrMinScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Min Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrRecScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Rec Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrFinalScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Final Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrComponentScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Component Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
        </ColumnGroups>
        <Columns>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdCHK" Visible="true">
                <ItemStyle Width="30px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="30px" Wrap="True" HorizontalAlign="Center" />
                <HeaderTemplate>
                    <asp:CheckBox ID="chk1" runat="server" onclick='javascript:SelectAllCheckboxesFromWorkFlowGrid(this, "radGridScoreResults");' />
                </HeaderTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="chk2" runat="server" onclick="javascript:SelectChildCheckBoxes();" />
                </ItemTemplate>
                <HeaderStyle Width="30px" HorizontalAlign="Center" />
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources: Score, DOW%>" Resizable="false"
                SortExpression="DOW" UniqueName="ghdrAddDOW">
                <ItemStyle Width="100px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="100px" Wrap="True" />
                <ItemTemplate>
                    <asp:Label ID="lblDOW" runat="server" Text='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'
                        ToolTip='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Min_Score" UniqueName="ghdrModelMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelMinScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScoreExp" ColumnGroupName="ghdrMinScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserMinScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserMinScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99" Enabled='<%#Eval("Use_Min_Charge") %>'
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                        <%-- AutoPostBack="true" OnTextChanged="txtUserMinScore_TextChanged"--%>
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Rec_Score" UniqueName="ghdrModelRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelRecScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScoreExp" ColumnGroupName="ghdrRecScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserRecScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserRecScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChk" HeaderText="Use Model">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:CheckBox ID="chk10" runat="server"  />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChkExp" HeaderText="Use Model" Visible="false">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblUseModel" runat="server" Text='<%# Eval("Use_Model") %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Score Band" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorName" Visible="false">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorName" runat="server" Text='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_BAND %>" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorCode">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center" CssClass="NoHoverSelected"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorCode" runat="server" Text='<%# Eval("Color_Code")%>' ToolTip='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="Is Default Score" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrIsDefaultScore" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblIsDefaultScore" runat="server" Text='<%# Eval("Is_Scored_Enabled")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalModelSc" runat="server" Text='<%# Eval("Final_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalModelScore" ForeColor="black" Text='<%#Eval("Final_Model_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalUserSc" runat="server" Text='<%# Eval("Final_User_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalUserScore" ForeColor="black" Text='<%#Eval("Final_User_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScoreExp" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeDenModelScore" runat="server" Text='<%# Eval("Relative_Density_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeDensityScore" ForeColor="black" Text='<%#Eval("Relative_Density_Model_Score")%>' Enabled='<%# Eval("Is_Scored_Enabled")%>'
                        runat="server" CommandName="RelDensityModel" ToolTip='<%# Eval("Relative_Density_Model_Scale")%>' CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Score"
                UniqueName="ghdrRelScoreModelScoreExp" Visible="false" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeScoreModelScore" runat="server" Text='<%# Eval("Relative_Score_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Relative_Score_Model_Score"
                UniqueName="ghdrRelScoreModelScore" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeScoreScore" ForeColor="black" Text='<%#Eval("Relative_Score_Model_Score")%>'
                        runat="server" CommandName="RelScoremodel" ToolTip='<%#Eval("Relative_Score_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, YIELD %>" Resizable="false" SortExpression="Yield_Model_Score"
                UniqueName="ghdrYieldModelScore" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblComponentYield" runat="server" Text='<%# Eval("Yield_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, PAYMENT %>" Resizable="false" SortExpression="Payment_Model_Score"
                UniqueName="ghdrPaymentModelScoreExp" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblPaymentModelSc" runat="server" Text='<%# Eval("Payment_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScoreExp" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeUsgeModelScore" runat="server" Text='<%# Eval("Relative_Usage_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeUsageModelScore" ForeColor="black" Text='<%#Eval("Relative_Usage_Model_Score")%>'
                        runat="server" CommandName="RelAllotmentUsageModel" ToolTip='<%#Eval("Relative_Usage_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScoreExp" Visible="false">
                <ItemStyle Width="90px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="90px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFMSModelScore" runat="server" Text='<%# Eval("Flight_Market_Share_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScore" Visible="true">
                <ItemStyle Width="115px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="115px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFMSModelScr" ForeColor="black" Text='<%#Eval("Flight_Market_Share_Model_Score")%>'
                        runat="server" CommandName="FMS" ToolTip="Details" CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
        <EditFormSettings>
            <EditColumn UniqueName="EditCommandColumn1">
            </EditColumn>
        </EditFormSettings>
        <CommandItemTemplate>
            <table style="height: 3px;">
                <tr>
                    <td>
                        <asp:LinkButton ID="lbExportToExcel" Class="link margin_right_nav" runat="server" OnClick="btnExportToExcel_Click" ToolTip="<%$ Resources:Common , EXPORT_EXCEL %>" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_excel.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToPDF" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_PDF %>" OnClick="btnExportToPDF_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_pdf.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToCSV" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_CSV %>" OnClick="btnExportToCSV_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_csv.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbPrint" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , PRINT %>" OnClick="btnPrint_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/print.png">
                        </asp:LinkButton>
                    </td>
                </tr>
            </table>
        </CommandItemTemplate>
        <EditFormSettings>
            <EditColumn Visible="false">
            </EditColumn>
        </EditFormSettings>
    </MasterTableView>
    <ClientSettings AllowColumnHide="True" AllowColumnsReorder="False" ReorderColumnsOnClient="False"
        EnableRowHoverStyle="true">
        <Selecting AllowRowSelect="True" />
        <Scrolling AllowScroll="true" UseStaticHeaders="True" />
        <ClientEvents OnGridCreated="radGrid_OnGridCreated" OnCommand="OnGridCommand" />
    </ClientSettings>
    <ExportSettings>
        <Pdf AllowPrinting="true" PageWidth="450mm" PageHeight="210mm" Title="Report Title" ForceTextWrap="true"
            PageFooterMargin="10mm" PageHeaderMargin="10mm" PageLeftMargin="10mm" PageRightMargin="10mm" />
    </ExportSettings>
</telerik:RadGrid>

 

Thanks

Vakul

[Attila Antal]

Hi Vakul,

Thank you for sharing the markup, we managed to replicate the problem. Since the structure of the MultiColumn header is different from the basic structure, the workaround provided in the bug article will not work and we are unable to provide one at this time.

Kind regards,
Attila Antal
Progress Telerik

[Vakul]

Hi Attila Antal,

When we can get this fix. Any update on MultiColumn header export issue ?

 

Regards,

Vakul

[HrMeibom]

Hi Telerik Support,

As many others, I'm also experiencing the same issue, now using the latest shiny version of Telerik.Web.UI.dll (version 2020.2.617). The issue exists for both Excel and PDF exports.
Please, Telerik Support staff, could you give an update about this issue? When can we expect it to be fixed?

Looking forward hearing from you.

Best regards,

Jannik

[HrMeibom]

Just a few supplementing details.

• The issue exists for both RenderMode="Lightweight" and RenderMode="Auto".
• For Excel, I'm exporting in .xlsx format.
• The issue started after implementing support for showing the RadAjaxLoadingPanel1, by following the solution presented here: https://www.telerik.com/support/code-library/show-loading-panel-when-exporting-radgrid
• Specifically, the introduction of this code snippet in the OnItemCommand event:
  
  if (e.CommandName.StartsWith("Export"))
  {
  if (!String.IsNullOrEmpty(Request["_downloadToken"]))
  {
  Response.Cookies.Add(new HttpCookie("_downloadToken", Request["_downloadToken"]));
  System.Threading.Thread.Sleep(5000);
  }
  }

I hope this may help identifying the issue.

[Attila Antal]

Hi HrMeibom,

Thank you for sharing your feedback. We are aware of the issue and the cause, but the developer team has their roadmap scheduled ahead. As popularity increases for this particular bug, its priority is changing, therefore, we may take this issue and process it earlier than planned. We can't provide an ETA for the fix at the moment.

Thank you for your understanding and patience!

Regards,
Attila Antal
Progress Telerik

[Roger]

Has it been fixed in newest version? If not, I would be happy to vote for it.

[Attila Antal]

Hi Roger,

I am afraid this issue has not been fixed yet. Items with the status "Unplanned" are waiting in the queue and will be processed as soon as our developers finish the ones they have planned on their roadmap. Once an item is being worked on, its status will change to "In Development" and an ETA will be shared.

Please feel free to Vote up for the public item at: When sort a grid with LightWeight render mode and export to Excel Biff format the sort expression is added to the header cells

The more votes an item received, will increase the popularity and thus changing its priority.

Regards,
Attila Antal
Progress Telerik

[Diane Wilson]

This is still happening in 2022.1.302.45. We have a hundred or more RadGrids in our product that support export, and the "Sort ascSort desc" problem occurs in exactly one grid. I've tried the export infrastructure fix described earlier in this forum, and I've also applied the fix described in the referenced bug report to the page PreRender handler. In PreRender, I've set a breakpoint to look at the column Header text, and the Header Text is correct at the point it is rendered to Telerik's export code. The error occurs in both Excel and PDF exports.

I've added my vote on the bug report, and I really hope to see a fix.