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);
28 Answers, 1 is accepted
Hi there.
Did you find a solution for this yet?
We are facing the same issue..
Hi Nils,
We haven't got any solution for this. Please let us know if you fiund.
Thanks,
Ruchi Patel
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
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 PatelI 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
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
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"
,
""
);
}
}
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
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.
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
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?
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
Hi,
I'm having the same issue.
Telerik version : 2017.2.711.45
Exporting to Html Excel
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
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
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.
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
Our thoughts here at Progress are with those affected by the outbreak.
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:
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
Our thoughts here at Progress are with those affected by the outbreak.
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
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
Our thoughts here at Progress are with those affected by the outbreak.
Hi Attila Antal,
When we can get this fix. Any update on MultiColumn header export issue ?
Regards,
Vakul
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
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.
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
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
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
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
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.