I want to be able to use Defined Name when creating my spreadsheet so that I can use them in formulas.  IE instead of having to create a formula that is

= SUM(A1:A20)   I define A1 to A20 a name "Period1" and then I can do things like = SUM(Period1 Apples)  etc.  How do you create the Defined Names in the Spreadsheet and does the formulas then support this feature.  Also when exporting the spreadsheet to excel do the formulas and names export?

Thanks

Lee

Hi, i found an example of a Multiselect with checkbox on item templatem unfortunately only with UI syntax  and tried to use that in

MultiSelectFor in MVC but struggle with the item template. Can somebody help me please ?

Knowlege Article from UI

http://www.kendoui.io/kendo-ui/web/multiselect/how-to/checkbox-item-template#create-checkbox-custom-item-template

Here is my code for the editor template

@(
 Html.Kendo().MultiSelectFor(m => m)
        .DataTextField("Value")
        .DataValueField("Key")
        .ItemTemplate("<input type='checkbox'/> #:data.text#")
        .TagMode(TagMode.Single)
        .BindTo((System.Collections.IEnumerable)ViewData["FsrList"])
)

Hi!

I found a sample that features a grid working with API calls to edit a collection type object. It also shows that the three drop-downs on the grid are cascade-locked with each other. However, the sample was seriously dated and had an issue that the cell were displaying values instead of name even though the editor templates were defined properly. I have upgraded the sample to the very latest Kendo MVC and the behavior is still there and i'm not able to track it to the source. I'm following this example to create a solution to handle similar situation that I've been asking around for quite sometime now: http://stackoverflow.com/questions/37246701/simple-kendo-grid-to-represent-a-listbasicviewmodel-with-add-edit-and-delete

Kindly inform me why the dropdowns are not taking the DisplayText

P.S.: I didn't use NuGet to add commercial Kendo so I have deleted the CSS and JS related to Kendo. You'll have to paste in manually from you own licence.

I have a Kendo grid which represents some documents, each row is a document, i need to upload a pdf which is a digitalized copy of the physical document. All rows need  to be save as a List in the server so i'm using a template like this

.ClientTemplate("#= OficioId #<input type='hidden' name='OficioAban[#= index(data) #].OficioId' value='#= OficioId #'/>");    

All fields are working ok but the upload.

i'm trying to save the file in a HttpPostedFileBase which is part of OficioAban Class but this template is not working.

This is the Grid

@(Html.Kendo().Grid<RecintoFiscal.Models.OficioAban>(Model.OficioAban).Name("OficioAban")
                                                .DataSource(datasource => datasource
                                                    .Ajax()
                                                    .ServerOperation(false)
                                                    .Events(events => events.Error("error_handler"))
                                                    .Model(model =>
                                                    {
                                                        model.Id(t => t.OficioId);
                                                        model.Field(t => t.OficioId).Editable(false);
                                                        model.Field(t => t.Usuario).Editable(false);
                                                    })
                                                )
                                                .Events(e => e.Edit("onEdit"))
                                                .EnableCustomBinding(true)
                                                .Editable(editable => editable.Mode(GridEditMode.InCell).CreateAt(GridInsertRowPosition.Bottom))
                                                .Navigatable()
                                                .Scrollable()
                                                .TableHtmlAttributes(new { @class = "table" })
                                                .ToolBar(commands =>
                                                {
                                                    commands.Create().Text("Nuevo");
                                                })
                                                .Columns(columns =>
                                                    {
                                                        columns.Bound(o => o.OficioId).Hidden().ClientTemplate("#= OficioId #<input type='hidden' name='OficioAban[#= index(data) #].OficioId' value='#= OficioId #'/>");
                                                        columns.Bound(o => o.NumeroOficio).ClientTemplate("#= getValue(NumeroOficio) #<input type='hidden' name='OficioAban[#= index(data) #].NumeroOficio' value='#= NumeroOficio #'/>");
                                                        columns.Bound(o => o.FechaOficio).ClientTemplate("#= getDate(FechaOficio) #<input type='hidden' name='OficioAban[#= index(data) #].FechaOficio' value='#= getDate(FechaOficio) #'/>");
                                                        columns.Bound(o => o.TipoOficioId).ClientTemplate("#= getTipoOficioText(TipoOficioId) #<input type='hidden' name='OficioAban[#= index(data) #].TipoOficioId' value='#= TipoOficioId #'/>").Title("Asunto");
                                                        columns.Bound(o => o.TipoManiobraId).ClientTemplate("#= getManiobraText(TipoManiobraId) #<input type='hidden' name='OficioAban[#= index(data) #].TipoManiobraId' value='#= TipoManiobraId #'/>").Title("Maniobra");
                                                        columns.Bound(o => o.Remanejos).ClientTemplate("#= getValue(Remanejos) #<input type='hidden' name='OficioAban[#= index(data) #].Remanejos' value='#= Remanejos #'/>");
                                                        columns.Bound(o => o.FechaMovimiento).ClientTemplate("#= getDate(FechaMovimiento) #<input type='hidden' name='OficioAban[#= index(data) #].FechaMovimiento' value='#= getDate(FechaMovimiento) #'/>");
                                                        columns.Bound(o => o.Pedimento).ClientTemplate("#= getValue(Pedimento) #<input type='hidden' name='OficioAban[#= index(data) #].Pedimento' value='#= Pedimento #'/>");
                                                        columns.Bound(o => o.Documento).Width(180).ClientTemplate("#= getValue(Documento) #<input type='hidden' name='OficioAban[#= index(data) #].Documento' value='#= Documento #'/>");
                                                        columns.Bound(o => o.Archivo).ClientTemplate("<input type='hidden' name='OficioAban[#= index(data) #].Archivo'/>");
                                                        columns.Bound(o => o.Liberacion).ClientTemplate("#= Liberacion ? 'Si' : 'No' #<input type='hidden' name='OficioAban[#= index(data) #].Liberacion' value='#= Liberacion #'/>");
                                                        columns.Bound(o => o.Usuario).ClientTemplate("#= getUser(Usuario) #<input type='hidden' name='OficioAban[#= index(data) #].Usuario' value='#= Usuario #'/>");
                                                        columns.Command(command => command.Destroy().Text("Borrar")).Width(95).Title("Acciones");
                                                    })
                                                .Mobile()
                                                .Resizable(resize => resize.Columns(true))
        )

and this is my upload file Editor Template

@(Html.Kendo().Upload()
        .Name("Archivo")        
        .ShowFileList(false)
        .HtmlAttributes(new { @class = "form-control filestyle", accept = ".pdf", style = "vertical-align: bottom; padding:0px; margin:0px; border:0px; margin-top:2.5ex;" })
        .Multiple(false)        
)

Hello,

I have a scheduler with timeline view and need to set the row height dynamically. If I set the default height via css the auto expand won't work but if it's not there are to many white space inside the row. Please check image attached to clarify my mind. And is it possible to set alternate row here?

Thank you in advance.

I have MVC5 application and I am using kendo time picker to show time in 12 hr format. The ccorresponding model property is of type TimeSpan. When i submit the chosen time to server, the MVC model binding throws error

The value 'XXX' is not valid for 'PropertyName'.

cshtml

model

Note that if i remove Format method from the timePicker and submit the time in 24 hr format then i get chosen timespan value on server

I have a popup grid and I am using a template in Shared/EditorTemplates/_TeamSocial.cshtml.
However when the popup opens the TeamID value @Model.TeamID = 0.

How do I get the ID to pass over correctly?

Grid code:

Template popup code:

Thanks 

Tom

We are using Kendo MVC Grid in our application. We are using LINQ to EF to query the tables.

Following is a query in our application:

query.Where(ExpressionBuilder.Expression<ParentTable>(command.Request.Filters))

This works fine as long as the filters are any columns from the "ParentTable". However, the ParentTable has a navigation collection ICollection<ChildTable> and the ChildTable has a property ChildProperty and the method ExpressionBuilder.Expression fails when we use this ChildProperty for filtering.

Any solution for this problem?

Thanks

Hi guys, currently i have this scenario where i want to get the selected row id after clicking on the edit button and pass that id to the action method...

Please let me know if this is possible. here is my code below that i have gathered so far...

Hello, I'm trying to figure out the scrollbar functionality in Gridbuilder. In my particular case, as shown in the code below, I have a toolbar and some columns. The scrollbar is scrolling the entire grid, header and all. There appears to be another scroll bar for just the data but it is greyed out. What I'm trying to do is just get the data to scroll while leaving the header stationary. Any ideas? 

    .Name("Generic")
    .Columns(columns =>
    {
        columns.Bound(p => p.Name);
        columns.Bound(p => p.Desc);
    })
    .DataSource(dataSource => dataSource
        .Ajax()
        .Model(model =>
        {
            model.Id(p => p.ID);
        })
        .Create(create => create.Action("Create")
        .Read(read => read.Action("Read")
        .Update(update => update.Action("Update")
        .Destroy(destroy => destroy.Action("Delete")
        .PageSize(20)
    )
    .Sortable(sortable => sortable
        .AllowUnsort(true)
        .SortMode(GridSortMode.SingleColumn))
    .ToolBar(toolbar =>
    {
        toolbar.Template(@<text>
        @item.CreateButton("Add")
        @item.SaveButton("Save", "Cancel")
        </text>);
    })
)