Greetings!  I have a set of grids to export to Excel.  I completed the first, with the help of your fine demo apps.

I have quite a bit of code for the OnExcelExport(e) event to set Excel column widths, cell colors, etc.  For example:

My question is :Is there a way to store metadata in the column definition of the grid that I can read in OnExcelExport(e) so that I can create shared, generic functions to set the Excel attributes or must I code each grid like this (referencing column order, etc.)?  I tried stuffing attributes in the clientTemplate but this always seemed to affect my HTML grid...

Best,
Scott

If I have a treelist or grid with "popup" editing and an autosync datasource, how can I have the popup editor appear immediately for the new record?

It seems that with autosync, the create action is called immediately and no popup editor appears.

Ideally I would like the popup before going to the create action (same as without autosync).

It would be acceptable for the popup to appear after calling the create action on the server, so that it is editing a record filled with defaults.

Hi,

I have a chart which shows 3 lines. My client asks whether it is possible to have a background color between the lowest and highest line inside the area.
See the attachment for my example. The red lines mark the area which should be a light, gray color.

Any ideas?

Best,
Daniel

 I have a combobox as a wrapper in MVC within a cshtml page.  I need to modify the read.URL to build my url and supply the appropriate search criteria.  I found a similar question and provided a link below to the answer, however this is using pure javascript and doesn't really fit my situation. How do i create a custom function in the .Read of the datasource so that i can build my url but do it with the MVC Wrapper?  Also is there more detailed documentation with comments etc the api just shows you a very slim example for a feature and doesn't really document what is going on.  Any help would be appreciated.

 Link to answer that answers my exact question but i need the answer for the MVC Wrapper not javascript:

http://www.telerik.com/forums/how-do-i-specify-a-variable-in-the-middle-of-data-source-read#BPwmciunhUyELOSvZKBqIQ

The master grid is not recognized as a master grid.

Detail Template

Master grid code. Grid is populated by the model.

JavaScript

Screenshot of the results

When I try to add checkboxes to the TreeView,devtools int he browser show I am getting "Invalid Template"

This works (but no checkboxes).  But if I uncomment the ".Checkboxes part, it throws error.  I have tried many variants, including just ".Checkboxes(true)".

<script id="UserDetailsTemplate" type="text/kendo-tmpl">

    @*@Html.Kendo().TextBox().Value("foo #= User_Login#").Name("yoda_#=User_Login#")*@
    @(Html.Kendo()
          .TabStrip()
          .Name("userTabStrip_#=Person_ID#")
          .SelectedIndex(0)
          .Items((items) =>
                 {
                     items.Add()
                          .Text("Contact Info");
                     items.Add()
                          .Text("Permissions")
                          .Content(obj => Html.Kendo()
                                              .TreeView()
                                              .DataTextField("Name")
                                              .Name("userModulePermissions#=Person_ID#")
                                              //.Checkboxes(cbxConfig => cbxConfig.Enabled(true)
                                              //                                  .CheckChildren(true)
                                              //                                  .Name("checkedNodes"))
                                              .DataSource(d => d.Read("PermissionsTree_Read",
                                                                      "SettingsUsers"))
                                              .ToClientTemplate());
                     items.Add()
                          .Text("Group Membership");
                 })
          .ToClientTemplate()
          )
</script>

Here is the action the provides the tree data:

         public JsonResult PermissionsTree_Read(long? id)
        {
            var moduleId = id;
            var tracDB = new TRACEntities();
            // because modules & permissions are not same thing, we have to distinguish what "level" we are at in the tree
            // modules are root level, permissions (sub_sections) are next (leaf) level
            if (moduleId == null)
            {
                var result = GetOrgModules()
                    .Select(m => new {   
                                         id = m.Module_Type_ID,
                                         Name = m.Module_Type_Name,
                                         hasChildren = GetUserModuleSubsectionPermissions(m.Module_Type_ID).Any(),
                                         @checked = false
                    });
                return Json(result,
                            JsonRequestBehavior.AllowGet);
            }
            else
            {
                var result = GetUserModuleSubsectionPermissions((long) moduleId)
                    .Select(p => new {
                                         id = p.Sub_Section_Type_Id,
                                         Name = p.Sub_Section_Type_Desc,
                                         hasChildren = false,  //always leaves
                                         //@checked = false  //I have tried with and without this line -- it was just a guess that this was needed
                                     });
                return Json(result,
                            JsonRequestBehavior.AllowGet);
            }
        }

Here's my ViewModel

    public class EmailStartsViewModel
    {
        public int Year { get; set; }
        public int Week { get; set; }
        public int Starts { get; set; }
    }​

 I would like to display a line chart that has a category axis value for each week of the year i.e. 1 - 52, and that groups the data by year, so that it display a line for each year.

The data covers 2012 through the present, and looks like this: 

Year     Week Starts
2013    1         1
2015    1         11
2014    2         1
2015    2         8
2013    3         3
2015    3         20
2013    4         9
2015    4         30
2012    5        1
2013    5        3
2014    5        1
2015    5        18

etc up to week 53 (because of partial weeks) 

With these settings 

                  .DataSource(ds => ds
                      .Read(read => read
                          .Action("StartData", "Starts")
                          .Data("StartSettings"))
                      .Group( group => group.Add(model => model.Year))
                              .Sort(sort => sort.Add(model => model.Week))
                  )
                  .Series(series =>
                  {
                      series.Line(model => model.Starts, categoryExpression: model => model.Week).Name("Starts");

                  })
                  .CategoryAxis(axis => axis
                      .Categories(model => model.Week)
                  )​

It starts with week 5 which is the first week that has data in the first year. Weeks 1-4 aren't displayed

I've tried various combinations like directly specifiying the categories 

.CategoryAxis(axis => axis
                      .Categories("1", "2", "3", "4", "5", "6"....."52"))

and removing the categoryExpression in 

series.Line(model => model.Starts, categoryExpression: model => model.Week).Name("Starts");​

and it either doesn't show all the weeks, or puts values in the wrong category, or both.

 What's the right way to go about this?

 The treeview events demo has event handlers such as the following:

         function onCheck(e) {

                  kendoConsole.log("Checkbox changed :: " + this.text(e.node));

                  //???????  do something useful  ?????

         }

But how would I do something useful, like get ID, checked status (checked or unchecked), or other fields of the item checked?

If the data source has model with fields "Id", "name", "something", how would I get those values?