When i export a Kendo UI Grid to Excel (xlsx) file, it also exports the group footer template which in my case included hidden fields (<input type=hidden id="test"></input>)

Is there a way we can suppress the export of the group footer template and the group header template.

The header template also gets exported in the output xlsx file.

In my case the group header template looks like the following:

<script id="productCodeTemplate" type="text/x-kendo-tmpl">
    # var product = value; productArr = product.split(";"); #
    <span class="name" style="display: inline-block;width:500px;">Product Code: #: productArr[0]# </span>
</script>

The group footer template is as follows 

groupFooterTemplate: "<input type='hidden' class='totalFooter' value='#=count#'></input><span class='totalFooterSpan'>Total</span>"

Kindly see attached zip file for a sample of the exported excel.

Hi there,

I know we can always access a grid like $("#grid").data("kendoGrid"), but this doesn't work for my situation.

Let's say I have a grid with 2 pages, 10 rows each. And each master row has a details row(.k-detail-row) below. So what I want to do is to export the grid's data with all the sorters applied. For the main columns it is pretty simple, I can get the data (a json with 20 length) and the sorter grid.dataSource.sort() and use kendo.data.Query to do the sorting. However this only works for the main grid. The inner grid's data is still unsorted. Could you help? I don't see anything in the API to access the details row programmatically.

Best regards,

Yajing

Hi!

Im getting an "invalid template" exception when initializing a grid.

This is the JS code:

jQuery("#uipoc_readwrite_messagelist_table").kendoGrid();

This is the complete exception message:

Invalid template:'<tr><td>#=Betreff#</td><td>#=Absender#</td><td>#=Erhalten#</td><td>#=#</td><td>#=#</td></tr>' Generated code:'var o,e=kendo.htmlEncode;with(data){o='<tr><td>'+(Betreff)+'</td><td>'+(Absender)+'</td><td>'+(Erhalten)+'</td><td>'+()+'</td><td>'+()+'</td></tr>';}return o;'

This is the html at the time the code is executed:

<TABLE id=uipoc_readwrite_messagelist_table>
<THEAD>
<TR>
<TH>Betreff</TH>
<TH>Absender</TH>
<TH>Erhalten</TH>
<TH></TH>
<TH></TH></TR></THEAD>
<TBODY>
<TR>
<TD><A id=uipoc_readwrite_messagelist_b0ca6719-1984-4f3f-8be4-9d4c5eaba774 href="#uipoc_readwrite_messagelist_b0ca6719-1984-4f3f-8be4-9d4c5eaba774" jQuery171046139815295798753="5">dad about ship hot light ill keys something smoke

something</A></TD>
<TD>Karen Mayer</TD>
<TD>07.02.2012 02:58:22</TD>
<TD><BUTTON id=uipoc_readwrite_messagelist_answerMessage_b0ca6719-1984-4f3f-8be4-9d4c5eaba774 type=button jQuery171046139815295798753="6">Antworten</BUTTON></TD>
<TD></TD></TR>
<TR>
<TD><A id=uipoc_readwrite_messagelist_08dda71c-e777-4436-82c8-634a779bfed0 href="#uipoc_readwrite_messagelist_08dda71c-e777-4436-82c8-634a779bfed0" jQuery171046139815295798753="7">out worn wicket on generated rabbit many ball to

rescue</A></TD>
<TD>Karen Mayer</TD>
<TD>09.03.2012 20:50:01</TD>
<TD><BUTTON id=uipoc_readwrite_messagelist_answerMessage_08dda71c-e777-4436-82c8-634a779bfed0 type=button jQuery171046139815295798753="8">Antworten</BUTTON></TD>
<TD></TD></TR>
<TR>
<TD><A id=uipoc_readwrite_messagelist_e7d8b8f6-708d-4547-bd31-8c05d3be2a2e href="#uipoc_readwrite_messagelist_e7d8b8f6-708d-4547-bd31-8c05d3be2a2e" jQuery171046139815295798753="9">library are words always plane days to computer

will</A></TD>
<TD>Lindsey Craft</TD>
<TD>11.01.2012 14:40:45</TD>
<TD><BUTTON id=uipoc_readwrite_messagelist_answerMessage_e7d8b8f6-708d-4547-bd31-8c05d3be2a2e type=button jQuery171046139815295798753="10">Antworten</BUTTON></TD>
<TD></TD></TR>
<TR>
<TD><A id=uipoc_readwrite_messagelist_5e64f31f-9cf1-413f-ae47-33816435e655 href="#uipoc_readwrite_messagelist_5e64f31f-9cf1-413f-ae47-33816435e655" jQuery171046139815295798753="11">smoke much many window this text of suspense died

of</A></TD>
<TD>Karen Mayer</TD>
<TD>17.12.2011 17:26:42</TD>
<TD><BUTTON id=uipoc_readwrite_messagelist_answerMessage_5e64f31f-9cf1-413f-ae47-33816435e655 type=button jQuery171046139815295798753="12">Antworten</BUTTON></TD>
<TD></TD></TR>
<TR>
<TD><A id=uipoc_readwrite_messagelist_eb2b1d0b-6071-456b-a675-bed1a3055fd6 href="#uipoc_readwrite_messagelist_eb2b1d0b-6071-456b-a675-bed1a3055fd6" jQuery171046139815295798753="13">rescue asked leader pique to handled always

captain</A></TD>
<TD>Chasity Conway</TD>
<TD>03.03.2012 19:41:40</TD>
<TD><BUTTON id=uipoc_readwrite_messagelist_answerMessage_eb2b1d0b-6071-456b-a675-bed1a3055fd6 type=button jQuery171046139815295798753="14">Antworten</BUTTON></TD>
<TD></TD></TR>
<TR>
<TD><A id=uipoc_readwrite_messagelist_311625ac-6b95-4c35-a6e0-79dbad0f62b3 href="#uipoc_readwrite_messagelist_311625ac-6b95-4c35-a6e0-79dbad0f62b3" jQuery171046139815295798753="15">others had constantly smoke will should worn when

ending</A></TD>
<TD>Nancy Stevens</TD>
<TD>18.02.2012 07:47:57</TD>
<TD><BUTTON id=uipoc_readwrite_messagelist_answerMessage_311625ac-6b95-4c35-a6e0-79dbad0f62b3 type=button jQuery171046139815295798753="16">Antworten</BUTTON></TD>
<TD></TD></TR></TBODY></TABLE>

Hi,

Just wanting to ask where we could find documentation related to KendoTemplates that are rendered via server side code.

For example, I have the following mark-up:

I can't seem to find relevant documentation for the server side components, and how to specify values for the markup.

I see a lot of KendoUI docs, but it is mostly focused on JS/HTML client side rendering.

Thanks.

Hello,

We have an MVC web app and have a kendo grid with batch editing.  One of the columns is a dropdownlist. (using columns.ForeignKey())

It works perfectly in FireFox.  However, it doesn't work at all in Chrome, and you have to double click in Internet Explorer (shows a textbox on first click, then ddl after second click).

To demonstrate the behavior, I created a new telerik MVC project with a grid.  I noticed that the template uses jQuery version 1.10.2.  Our project is using jQuery version 3.1.1.  So I tried switching our project to use 1.10.2 -- and the grid dropdownlist starting working fine in all browsers.

1. Does kendo require you to use a specific (old) version of jQuery?

2. Any suggestions?  I hate switching the jQuery version and regression testing the entire app...

* I tried to reproduce in a simple application, but could not.  I'm not sure what it is about our grid that causes the issue - but I do know when I toggle between the 2 versions of jQuery, it works with 1.10.2, and not with 3.1.1.

Thanks

This is solved and doesn't need to be answered. I just put it here in case someone runs into the same problem.

A treeview item says it has children altough there are no children by using "hasChildren":

You can run this code and click on the treeview entry "No child entry". It will tell you it has children! Why? The problem is on the predefinition in the datasource: ... ,"items": []

Remove that and it will work fine. I thought the Treeview Widget would take that over or replace it. But since it outputs wrong result, don't use it that way.

This code is driving me insane I have a click event that fires upon a radio button selection. It then executes jquery that should hide the row, however it doesn't. The code is as follow:

 document.getElementById("showSubOrgs").addEventListener("click", function () {
        ShowSubOrganisations();
    });

 function HideSubOrganisations() {
        var grid = $("#gridOrganizations").data("kendoGrid");
        var gridData = grid.dataSource.view();
        for (var i = 0; i < gridData.length; i++) {
           var currentOrgid = gridData[i]._OrganisationID;
            var ParentOrgID = gridData[i]._ParentOrganisationID;
            if (currentOrgid != ParentOrgID) {
               debugger;
               grid.table.find("tr[_OrganisationID='" + currentOrgid + "']").hide();
            }
        }
    };

    //show server errors if any
    function error_handler(e) {
        if (e.errors) {
            var message = "Errors:\n\n";
            $.each(e.errors, function (key, value) {
                if ('errors' in value) {
                    $.each(value.errors, function () {
                        message += this + "\n\n";
                    });
                }
            });
            alert(message);
        }
    }

@(Html.Kendo().Grid(Model)
    .Name("SchoolGrid")
    .Columns(columns =>
    {
        columns.Bound(p => p.SchoolID).Width("80px");
        columns.Bound(p => p.Name);
        columns.Bound(p => p.Campus).Width("90px");
        columns.Bound(p => p.StateCode).Width("90px");
        columns.Bound(p => p.SectorCode).Width("95px");
        columns.Bound(p => p.MDISurveyStartDate).ClientTemplate("#= (MDISurveyStartDate == null) ? 'Not Set' : kendo.toString(MDISurveyStartDate, 'dd/MM/yyyy') #").Width("90px");
        columns.Bound(p => p.MDISurveyEndDate).ClientTemplate("#= (MDISurveyEndDate == null) ? 'Not Set' : kendo.toString(MDISurveyEndDate, 'dd/MM/yyyy') #").Width("90px");
        columns.Command(command => { command.Edit(); command.Destroy(); }).Width("190px").HtmlAttributes(new { style = "text-align:center" });
    })
    .ToolBar(tb => tb.Create().Text("Add New School"))
    .Editable(ed => ed.Mode(GridEditMode.PopUp).TemplateName("EditSchool").Window(w => w.Title("Add/Edit School Details").Name("editWindow").Width(600)))
    .DataSource(dataSource => dataSource
        .Ajax()
        .Model(model => model.Id(p => p.ClientID))
        .Events(e => e.Error("error_handler"))
        .Read("Read_Schools", "School")
        .Update("Update", "School")
        .Create("Create", "School")
        .Destroy("Destroy", "School")
    )
)

        [HttpPost]
        public ActionResult Update([DataSourceRequest] DataSourceRequest request, School school)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    string errMsg = "";
                    if (!_Service.UpdateSchool(school, out errMsg))
                        ModelState.AddModelError("UpdateSchool", errMsg);
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError("UpdateSchool", ex.Message);
            }
 
            return Json(ModelState.ToDataSourceResult());
        }

Hello 

The KendoUI Splitter would be the perfect solution for what I want to do. I ran into the follow three style problems you may know the answer:

1. The default color of the panes is white. I need to have them transparent what is ignored by the Splitter. How can I remove the defaulted white?

2. How can I change the color of the most outer frame border? (the one surrounding both panes)

3. On hovering the splitter an arrow is coming up. This is imho missleading. The arrow has only one head, should have two since you can move the splitter in two directions. How can I change that?

Greetings