Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
70 views
Hello Folks,

we are having trouble with a specific constellation of the Grid Batch Edit Mode and Read Only Textfields (Gridbound Textcolumns).
Im blocking the Batcheditmode in the OnBatchEditOpening event and with modern browsers everything works as expected.

Though with IE 9 and IE 8 in Compatiblity Mode, we are having issues.

CSS wise, the fields are blocked and readonly, but unfortunatly the user is still able to enter text. Is there any known workaround?
The code is used in a SharePoint Webpart, hence changing the Documentmode is not a viable solution.

We are using the latest 2014 Release: 2014.3.1209.35
Maria Ilieva
Telerik team
 answered on 10 Feb 2015
1 answer
115 views
Hi,

I'm new to  kendo and i was trying to display a treeView using the ASP MVC approach so i followed the exemple you provided :

var employees = from e in db.Employees
                            where (id.HasValue ? e.ReportsTo == id : e.ReportsTo == null)
                            select new
                            {
                                id = e.id,
                                Name = e.FirstName + " " + e.LastName,
                                hasChildren = e.Employees1.Any()
                            };

My question is:  where the Employees1 comes from ? (I guess from the model) but what is the code inside this function ? where's the recursive function to loop on each child ? Can you provide the model and see what is inside ? 

Thanks
Daniel
Telerik team
 answered on 10 Feb 2015
1 answer
140 views
Hi Team,

I want to create a grid where second column is split to 3 rows. could you please give me the layout aspx how to create.

grid view is attached here. The grid is linked to a db

thanks
Sabitri Mohanty


Pavlina
Telerik team
 answered on 10 Feb 2015
1 answer
104 views
I have an OpenAccessLinqDataSource that pulls from some FK linked tables. The FK value is nullable (UInt32?) and while sorting works, I'm having some difficulties filtering.

Here's my LinqDataSource
<telerik:OpenAccessLinqDataSource ID="OA_Promos" Runat="server" ContextTypeName="Flow.ST2_Data" EntityTypeName="" OrderBy="ID desc" ResourceSetName="Promos" Select="new (ID, identifier, descriptor, lastUpdated, notes, startDate, endDate, startTime, endTime, priority, Promo_art.Art, Promo_art.width, Promo_art.height, Promo_art.fileName, Promo_topic.SpotID)" Where="Deleted == @Deleted" >
    <WhereParameters>
        <asp:Parameter DefaultValue="0" Name="Deleted" Type="Int16" />
    </WhereParameters>
</telerik:OpenAccessLinqDataSource>

The Promo_topic.SpotID is the column I'm trying to filter on using the following:
<telerik:GridBoundColumn DataField="Promo_topic.SpotID" AllowFiltering="true" SortExpression="SpotID" CurrentFilterFunction="EqualTo" FilterControlAltText="Filter SpotID Column" AutoPostBackOnFilter="true" ShowFilterIcon="False" UniqueName="SpotID" HeaderText="Spot ID" DataType="System.UInt32"></telerik:GridBoundColumn>

but I get 0 results returned when I filter on a valid Promo_topic.SpotID


I tried custom filtering:
<telerik:GridBoundColumn DataField="Promo_topic.SpotID" AllowFiltering="true" SortExpression="SpotID" CurrentFilterFunction="Custom" FilterControlAltText="Filter SpotID Column" AutoPostBackOnFilter="true" ShowFilterIcon="False" UniqueName="SpotID" HeaderText="Spot ID" DataType="System.UInt32"></telerik:GridBoundColumn>

with the following ItemCommand event:
protected void ItemCommandFired(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
    {
        Pair filterPair = (Pair)e.CommandArgument;
        if (filterPair.First.ToString() == "Custom")
        {
            string colName = filterPair.Second.ToString();
            TextBox tbPattern = (e.Item as GridFilteringItem)[colName].Controls[0] as TextBox;
            e.Canceled = true;
            grid_promos.MasterTableView.FilterExpression = string.Format("(Promo_topic.SpotID.Equals({0})) AND (Promo_topic.SpotID != null)", tbPattern.Text);
            grid_promos.Rebind();
        }
    }
}

but then get the error "Methods on type 'UInt32?' are not accessible"

Before I switch the entire DataLinqSource to reference a custom object, is there something I'm doing wrong?

Thanks.
Marin
Telerik team
 answered on 10 Feb 2015
1 answer
262 views
Can you use RadEditor to upload a pdf, like an image,  and then have the pdf display on the screen and not a link?



Ianko
Telerik team
 answered on 10 Feb 2015
3 answers
229 views
Hi,

When adding content using pasteHtml method, it's adding <br> tag before the text in chrome browser due to which an extra line is appearing. This issue can also be reproduced using existing tool e.g. "Insert Time". The issue will be gone when you switch between HTML view and Design view. Check this screen cast: http://screencast.com/t/liOx9ryeIp1 

Any work-around to fix this issue?

I'm using "ASP.NET AJAX Q2 2014" (2014.2.724.40) version.

Also I'm disabling ConvertToXhtml, ConvertCharactersToEntities, ConvertFontToSpan, and RemoveScripts filters. And NewLineMode = EditorNewLineModes.Div.

Thanks,
Anil

Marin Bratanov
Telerik team
 answered on 10 Feb 2015
2 answers
141 views
Hi,
I've got my drop down lists working with border coloured validation using JQuery.  Now that I am trying to do the same thing with RadComboBoxes I can't seem to get the relevant css classes.  Below is how I am doing this to the drop down lists.  How do I do the same with ComboBoxes?

Regards

Jon

var $ = $telerik.$;
var dropDown = dropDownTree.get_element();
if (eventArgs.IsValid === false) {
    $(dropDown).find(".rddtInner").addClass("RadDropDownTreeFieldErrorHighlight");
} else {
    $(dropDown).find(".rddtInner").removeClass("RadDropDownTreeFieldErrorHighlight");
}
Jon
Top achievements
Rank 1
 answered on 10 Feb 2015
3 answers
402 views
I have a rad grid that populates and pages fine however when I try to filter based on controls in the filtertemplate the page postsback, but no filter is applied.
When debuging, the filterexpression is added to the mastertableview but the column has no filter applied. Using telerik version 2014.3.1209.45
<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Layout/WebPortal.master" CodeBehind="CustomerNotes.aspx.vb" Inherits="Office.CustomerNotes" %>
<asp:Content ID="Content1" ContentPlaceHolderID="PageContentPlaceHolder" runat="server">

    <telerik:RadGrid runat="server" ID="grdNotes"  Width="1024" AllowSorting="true" DataSourceID="sdsNotes" AutoGenerateEditColumn="true" AutoGenerateColumns="false" AllowFilteringByColumn="true" 
                    ShowStatusBar="true" RegisterWithScriptManager="true" EnableLinqExpressions="false">
                    <MasterTableView DataKeyNames="ID" AllowSorting="true" AllowPaging="true" PageSize="30" TableLayout="Fixed" EditMode="InPlace" AllowAutomaticInserts="true" AllowFilteringByColumn="true">
                        <Columns>
                            <telerik:GridBoundColumn DataField="CustomerName" HeaderText="Customer Name" ReadOnly="true" AllowFiltering="true" AllowSorting="true" UniqueName="colCustomer">
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="rcbCustomerName" runat="server" AppendDataBoundItems="true" DataSourceID="sdsCustomer" AutoPostBack="true" 
                                        DataTextField="Name" DataValueField="Name" OnClientSelectedIndexChanged="CustomerIndexChanged"
                                        SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("colCustomer").CurrentFilterValue%>'>
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="rsbCustomer" runat="server">
                                        <script type="text/javascript">
                                            function CustomerIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("colCustomer", args.get_item().get_value(), Telerik.Web.UI.GridFilterFunction.EqualTo);
                                            }
                                        </script>
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="Note" HeaderText="Note" AllowSorting="true" AllowFiltering="false">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="NoteType" HeaderText="Note Type"  AllowSorting="true" AllowFiltering="true" UniqueName="colNoteType" >
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="rcbNoteType" runat="server" AppendDataBoundItems="true" DataSourceID="sdsNoteType" DataTextField="Type" 
                                         DataValueField="Id" OnClientSelectedIndexChanged="NoteTypeIndexChanged" AutoPostBack="true"
                                         SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("colNoteType").CurrentFilterValue%>'>
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All"  />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="rsbNoteType" runat="server">
                                        <script type="text/javascript">
                                            function NoteTypeIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("colNoteType", args.get_item().get_value(), Telerik.Web.UI.GridFilterFunction.EqualTo);
                                            }
                                        </script>
                                    </telerik:RadScriptBlock>

                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="Name" HeaderText="Creator" ReadOnly="true" AllowSorting="true" AllowFiltering="true" UniqueName="colCreator">
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="rcbCreator" runat="server" AppendDataBoundItems="true" DataSourceID="sdsCreator" DataTextField="Creator"
                                         DataValueField="Creator" AutoPostBack="true" OnClientSelectedIndexChanged="CreatorIndexChanged"
                                        SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("colCreator").CurrentFilterValue%>'>
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="rsbCreator" runat="server">
                                        <script type="text/javascript">
                                            function CreatorIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("colCreator", args.get_item().get_value(), Telerik.Web.UI.GridFilterFunction.EqualTo);
                                            }
                                        </script>
                                    </telerik:RadScriptBlock>

                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="CreationDate" HeaderText="Creation Date" ReadOnly="true" DataType="System.DateTime" DataFormatString="{0:d}" AllowSorting="true" AllowFiltering="false"></telerik:GridBoundColumn>
                        </Columns>

                    </MasterTableView>
                </telerik:RadGrid>
    <asp:SqlDataSource runat="server" ID="sdsCreator" SelectCommand="SELECT DISTINCT c.id as ID,c.Name AS Creator FROM cis.CustomerToDoList ctl INNER JOIN cis.Creators c ON c.ID = ctl.CreatorID INNER JOIN cis.Creators c2 ON c2.ID = ctl.AssigneeID INNER JOIN cis.CustomerList cl ON cl.CustomerNo = ctl.CustomerNo WHERE Complete=0 AND ctl.DateDeleted IS NULL ORDER BY c.Name"  />
    <asp:SqlDataSource runat="server" ID="sdsNoteType" SelectCommand="Select id,type from cis.customernotetype order by type"/>
    <asp:SqlDataSource runat="server" id="sdsCustomer" SelectCommand="SELECT DISTINCT cl.CustomerNo,cl.Name FROM cis.CustomerToDoList ctl INNER JOIN cis.Creators c ON c.ID = ctl.CreatorID INNER JOIN cis.Creators c2 ON c2.ID = ctl.AssigneeID INNER JOIN cis.CustomerList cl ON cl.CustomerNo = ctl.CustomerNo WHERE Complete=0 AND ctl.DateDeleted IS NULL ORDER BY name" />
    <asp:SqlDataSource runat="server" ID="sdsNotes" SelectCommand="SELECT cn.id AS ID,cn.Note,cnt.Type AS NoteType,c.Name,cn.CreationDate,cl.Name AS CustomerName FROM cis.CustomerNotes cn INNER JOIN cis.customernotetype cnt ON cn.notetype = cnt.id INNER JOIN cis.CustomerList cl ON cl.CustomerNo = cn.CustomerNo INNER JOIN cis.Creators c ON c.ID = cn.CreatorID WHERE cl.Inactive=0"/>
</asp:Content>


Angel Petrov
Telerik team
 answered on 10 Feb 2015
1 answer
100 views
How I can optimize the styles and scripts in axd files?...
I attached an image of chorme result.
tahnks
Slav
Telerik team
 answered on 10 Feb 2015
5 answers
1.4K+ views
We bought the complete license of Telerik controls, I've been using the Radgrid mainly to do the Export to Excel.

I have two problems that needs to be solved:

1. How do I manually add text or header to Row 1 of the excel file and then start all bound items from the Dataset on Row 2 downwards?
(see attachment1.png)
2. How do I remove the filering/sorting that is automatically added to the columns when the excel file is exported. I need to retain the colors I defined but I don't want the dropdown button for each column.
(see attachment2.png)

Thanks,

Here are my codes:
codebehind
bool isConfigured = false;       
        protected void RadGrid1_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
        {
 
            if (e.RowType == GridExportExcelMLRowType.HeaderRow)
            {
 
                //Add custom styles to the desired cells
                CellElement cell = e.Row.Cells.GetCellByName("Number");
                cell.StyleValue = "normalHeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Name");
                cell.StyleValue = "normalHeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Weight in Grams");
                cell.StyleValue = "normalHeaderStyle";               
 
                cell = e.Row.Cells.GetCellByName("Energie");
                cell.StyleValue = "perTotalHeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Eiweiss");
                cell.StyleValue = "perTotalHeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Fett");
                cell.StyleValue = "perTotalHeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("KH");
                cell.StyleValue = "perTotalHeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Nahrungsfasern, total");
                cell.StyleValue = "perTotalHeaderStyle";
 
 
 
                cell = e.Row.Cells.GetCellByName("Energie1");
                cell.StyleValue = "per100HeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Eiweiss1");
                cell.StyleValue = "per100HeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Fett1");
                cell.StyleValue = "per100HeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("KH1");
                cell.StyleValue = "per100HeaderStyle";
 
                cell = e.Row.Cells.GetCellByName("Nahrungsfasern, total1");
                cell.StyleValue = "per100HeaderStyle";
 
 
 
                cell = e.Row.Cells.GetCellByName("Energie CAL.");
                cell.StyleValue = "perTotalHeaderStyle";
            }
 
 
 
            if (e.RowType == GridExportExcelMLRowType.DataRow)
            {
 
 
                //Add custom styles to the desired cells
                CellElement cell = e.Row.Cells.GetCellByName("Number");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNormalStyle" : "itemNormalStyle";
                
                cell = e.Row.Cells.GetCellByName("Name");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNormalStyle" : "itemNormalStyle";
 
                cell = e.Row.Cells.GetCellByName("Weight in Grams");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNormalStyle" : "itemNormalStyle";
 
                cell = e.Row.Cells.GetCellByName("Energie");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Eiweiss");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Fett");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("KH");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Nahrungsfasern, total");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Energie1");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Eiweiss1");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Fett1");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("KH1");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Nahrungsfasern, total1");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                cell = e.Row.Cells.GetCellByName("Energie CAL.");
                cell.StyleValue = cell.StyleValue == "itemStyle" ? "itemNutrientStyle" : "itemNutrientStyle";
 
                if (!isConfigured)
                {
                    //Set Worksheet name
                    e.Worksheet.Name = "Nährwerte";
 
                    //Set Column widths
                    foreach (ColumnElement column in e.Worksheet.Table.Columns)
                    {
                        if (e.Worksheet.Table.Columns.IndexOf(column) == 1)
                            column.Width = Unit.Point(180); //set width 180 to ProductName column
                        else
                            column.Width = Unit.Point(80); //set width 80 to the rest of the columns
                    }
 
                    //Set Page options
                    PageSetupElement pageSetup = e.Worksheet.WorksheetOptions.PageSetup;
                    pageSetup.PageLayoutElement.IsCenteredVertical = true;
                    pageSetup.PageLayoutElement.IsCenteredHorizontal = true;
                    pageSetup.PageMarginsElement.Left = 0.5;
                    pageSetup.PageMarginsElement.Top = 0.5;
                    pageSetup.PageMarginsElement.Right = 0.5;
                    pageSetup.PageMarginsElement.Bottom = 0.5;
                    pageSetup.PageLayoutElement.PageOrientation = PageOrientationType.Landscape;                   
 
                    //Freeze panes
                    //e.Worksheet.WorksheetOptions.AllowFreezePanes = true;
                    //e.Worksheet.WorksheetOptions.LeftColumnRightPaneNumber = 3;
                    //e.Worksheet.WorksheetOptions.TopRowBottomPaneNumber = 1;
                    //e.Worksheet.WorksheetOptions.SplitHorizontalOffset = 1;
                    //e.Worksheet.WorksheetOptions.SplitVerticalOffest = 1;
 
                    //e.Worksheet.WorksheetOptions.ActivePane = 4;
                    isConfigured = true;
                }
            }
        }
 
        protected void RadGrid1_ExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)
        {
            //Add currency and percent styles
            StyleElement pertotalHeaderStyle = new StyleElement("perTotalHeaderStyle");
            pertotalHeaderStyle.FontStyle.Color = System.Drawing.Color.Black;
            pertotalHeaderStyle.FontStyle.Bold = true;
            pertotalHeaderStyle.FontStyle.FontName = "Calibri";
            pertotalHeaderStyle.FontStyle.Size = 10.0;
            e.Styles.Add(pertotalHeaderStyle);
 
            StyleElement per100HeaderStyle = new StyleElement("per100HeaderStyle");
            per100HeaderStyle.FontStyle.Color = System.Drawing.Color.Black;
            per100HeaderStyle.FontStyle.Bold = true;
            per100HeaderStyle.FontStyle.FontName = "Calibri";
            per100HeaderStyle.FontStyle.Size = 10.0;
            e.Styles.Add(per100HeaderStyle);
 
            StyleElement normalHeaderStyle = new StyleElement("normalHeaderStyle");
            normalHeaderStyle.FontStyle.Color = System.Drawing.Color.Black;
            normalHeaderStyle.FontStyle.Bold = true;
            normalHeaderStyle.FontStyle.FontName = "Calibri";
            normalHeaderStyle.FontStyle.Size = 10.0;
            e.Styles.Add(normalHeaderStyle);
 
            StyleElement itemStyle = new StyleElement("itemNormalStyle");
            itemStyle.FontStyle.Color = System.Drawing.Color.Black;
            itemStyle.FontStyle.Bold = false;
            itemStyle.FontStyle.FontName = "Calibri";
            itemStyle.FontStyle.Size = 10.0;
            e.Styles.Add(itemStyle);
 
            StyleElement itemNutrientStyle = new StyleElement("itemNutrientStyle");
            itemNutrientStyle.FontStyle.Color = System.Drawing.Color.Black;
            itemNutrientStyle.NumberFormat.FormatType = NumberFormatType.Standard;
            itemNutrientStyle.FontStyle.Bold = false;
            itemNutrientStyle.FontStyle.FontName = "Calibri";
            itemNutrientStyle.FontStyle.Size = 10.0;
            e.Styles.Add(itemNutrientStyle);
 
 
            //Apply background colors
            foreach (StyleElement style in e.Styles)
            {
                if (style.Id == "perTotalHeaderStyle")
                {
                    style.InteriorStyle.Pattern = InteriorPatternType.Solid;
                    style.InteriorStyle.Color = System.Drawing.Color.Yellow;
 
                }
 
                if (style.Id == "per100HeaderStyle")
                {
                    style.InteriorStyle.Pattern = InteriorPatternType.Solid;
                    style.InteriorStyle.Color = System.Drawing.Color.YellowGreen;
                }
 
                if (style.Id == "normalHeaderStyle")
                {
                    style.InteriorStyle.Pattern = InteriorPatternType.Solid;
                    style.InteriorStyle.Color = System.Drawing.Color.Gray;
                }
 
                if (style.Id == "itemNormalStyle")
                {
                    style.InteriorStyle.Pattern = InteriorPatternType.None;
                }
 
                if (style.Id == "itemNutrientStyle")
                {
                    style.InteriorStyle.Pattern = InteriorPatternType.None;
                }
            }
 
        }

aspx
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1" ClientEvents-OnRequestStart="requestStart">
            <telerik:RadGrid ID="RadGrid1"                                
                Width="97%"                            
                AllowSorting="False"                
                AllowPaging="True"
                PageSize="30"
                AllowMultiRowSelection="True"
                AllowFilteringByColumn="False"               
                runat="server"
                Gridlines="Horizontal"
                AutoGenerateColumns="false"
                DataSourceID="SqlDataSource1"
                Skin="Vista"
                >
                <MasterTableView DataKeyNames="Number,Name"
                    CommandItemDisplay="Top"
                    AllowFilteringByColumn="false" >
                    <Columns>
                        <telerik:GridBoundColumn UniqueName="Number"
                            SortExpression="Number" HeaderText="Number" DataField="Number">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Name"
                            SortExpression="Name" HeaderText="Name" DataField="Name">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn FooterText="Weight in Grams footer" UniqueName="Weight in Grams"
                            SortExpression="Weight in Grams" HeaderText="Weight in Grams" DataField="Weight in Grams">
                        </telerik:GridBoundColumn>
 
                        <%--Per Serving--%>
                        <telerik:GridBoundColumn UniqueName="Energie"
                            SortExpression="Energie" HeaderText="Energie" DataField="Energie" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Eiweiss"
                            SortExpression="Eiweiss" HeaderText="Eiweiss" DataField="Eiweiss" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Fett"
                            SortExpression="Fett" HeaderText="Fett" DataField="Fett" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="KH"
                            SortExpression="KH" HeaderText="KH" DataField="KH" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Nahrungsfasern, total"
                            SortExpression="Nahrungsfasern, total" HeaderText="Nahrungsfasern, total" DataField="Nahrungsfasern, total" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
 
                        <%--Per 100--%>
                        <telerik:GridBoundColumn UniqueName="Energie1"
                            SortExpression="Energie1" HeaderText="Energie" DataField="Energie1" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Eiweiss1"
                            SortExpression="Eiweiss1" HeaderText="Eiweiss" DataField="Eiweiss1" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Fett1"
                            SortExpression="Fet1" HeaderText="Fett" DataField="Fett1" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="KH1"
                            SortExpression="KH1" HeaderText="KH" DataField="KH1" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Nahrungsfasern, total1"
                            SortExpression="Nahrungsfasern, total1" HeaderText="Nahrungsfasern, total" DataField="Nahrungsfasern, total1" DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
 
                        <telerik:GridBoundColumn UniqueName="Energie CAL."
                            SortExpression="Energie CAL." HeaderText="Energie CAL." DataField="Energie CAL." DataFormatString="{0:N2}">
                        </telerik:GridBoundColumn>
                    </Columns>
                    <CommandItemSettings ShowExportToExcelButton="true"
                        ShowAddNewRecordButton="false" />
                </MasterTableView>               
                <ExportSettings
                    Excel-Format="ExcelML"
                    HideStructureColumns="true"
                    ExportOnlyData="true"
                    IgnorePaging="true"
                    OpenInNewWindow="true">                   
                </ExportSettings>                  
                <PagerStyle Mode="NextPrevAndNumeric" Position="TopAndBottom" />
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>

Kostadin
Telerik team
 answered on 10 Feb 2015
Narrow your results
Selected tags
Tags
+? more
Top users last month
Shiori
Top achievements
Rank 2
Iron
Tien
Top achievements
Rank 1
Iron
Robert
Top achievements
Rank 1
Rob
Top achievements
Rank 4
Bronze
Bronze
Iron
Geoff
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Shiori
Top achievements
Rank 2
Iron
Tien
Top achievements
Rank 1
Iron
Robert
Top achievements
Rank 1
Rob
Top achievements
Rank 4
Bronze
Bronze
Iron
Geoff
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?