Hello,

 I've been reading through the documentation, and I wanted to reach out in case I am missing something.  In all the Kendo Spreadsheet documentation that is available, I've not seen an MVVM example provided.  Is the MVVM method available with use for the Spreadsheet widget?   I was also wondering if just syntactically I might not have the right items configured in order for the data to populate in the spreadsheet.  I can confirm at the viewmodel that my data is populated in that object, but I just can't seem to get the data to appear in the spreadsheet.  Any guidance or additional documentation would be most helpful.

I am setting the data-role="spreadsheet", mimicking other examples of mvvm that I've seen.  I've also set the data-bind to my dataSource (data-bind="source:spreadsheetDataSource" while also populating a dataSource object within my data-sheets property.  I wanted to verify that these are in fact supported before I continue down this road.  I would also like to understand which properties are required by default (data-columns, data-rows, data-sheets) etc...and the properties that exist within the arrays (such as data-sheets), since that also doesn't seem to be present in the documentation. 

I'd also like to point out that I am using a windows server 2016, since that option was not listed in the fields below for the ticket.  The .NET Framework is 4.5.2

I appreciate all assistance in this matter. 

The Editor has an Encode option that when enabled allows Html tags to be submitted encoded.

This feature request is for a similar option in the Scheduler. A possible scenario could be an Editor nested in the Scheduler's custom editor. Currently the value of that field will be submitted not encoded regardless of the nested Editor's Encode option value. Having the option of enabling encoding of the values of the Scheduler fields would allow Html tags to be sent encoded. 

Hello, 

I think there is a bug with the DataTimeOffset field when used in a Grid. It cannot display correctly and is showing something like /Date(1364927400000)/. I have to retrieve my data from database as DateTimeOffset format and then use a new ViewModel to convert the DateTimeOffset values to DateTime values. This is really annoying.

Could you let me know if there is a way a DateTimeOffset field can be supported in the grid? Sometimes you do have to display the time zone info.

I hope this can be fixed in a future release.

Thanks,

Sam

This is in regards to my previous ticket #1426737. Your suggested solution did not work on closer look. The problem is that the event is turned off completely instead of only for a specific event.

Let me give you a practical example: I have a separate filter for the scheduler that allows me to look at the events for a specific resource. If someone else on a different computer now adds an event that is assigned to a different resource, it still shows up on my calendar. I want to suppress that event if it doesn't match the resource I selected in the filter. Using the taskHub.off('create') turns off the 'create' event completely (at least until the user refreshes the page). That way, new tasks added by someone for the selected resource won't show up.

I would like to subscribe to the events like this:

And then in the function check if the filter applies to the task and if not, suppress it. I tried the 'preventDefault' method, but that also turns off the event completely.

functiononScheduleCreate(e) {

if(e.AssignedResource != filter.AssignedResource)

This is not an untypical requirement for a calendar, especially if there are hundreds of tasks and filtering is the only option to organize them in a legible way.

There has to be a way to achieve this, but I have spent already way too much time on this. I need your help.

Thanks. 

In the grouping demo for MultiColumnComboBox (https://demos.telerik.com/aspnet-mvc/multicolumncombobox/grouping), the first group 'Argentina' is not displayed as a black label on the right. This is inconsistent with the way other groups are displayed.

This can pose a usability issue for example when there are only two groups. The second group has a black label on the right, but the first group does not.

To be consistent, the first group should also display as a black label on the right.

We are looking to see whether all the cells in the formula are filled or not  for that we need all the cells information in the formula. 

Is there any way to get list of cells present in formula cell.

Hi There,

I am facing one issue in kendo spreadsheet onchange event.

Suppose I have applied formula on one cell A1 and formula is =SUM(B1:B3)

Now one change of values in B1 to B3 on change event gets fired but whenever cell A1 values gets updated i.e. on entering value in B1 to B2, on change event doesn’t get fired.

How can I make onchange event fire for formula cell.

Thank you,

Rakesh

When I use a grid, I can enable Filterable and the column shows me when I am filtering it; however if I enable ColumnMenu I have no indication if I am filtering on that column.  We've used a work around to handle this state ourselves, but its ugly and I think this should be part of the core product.

@(Html.Kendo().Grid<ShipmentGrid>()
  .Name("grid")
  .AutoBind(false)
  .Columns(columns =>
  {
  columns.Template(@<text></text>).Width(50).Title("PDFs").ClientTemplate($"<a href='javascript:" + jsPage + $".openDocumentWindow(#=AccountId#, #=OrderNumber#, #=OrderLineId#, #=OrderLineNumber#)'><img src={Url.Content("~/Content/images/pdficon_small.png")} /></a>");
  columns.Bound(m => m.CustomerName).Width(200).Title("Customer").HeaderTemplate("Customer <span style='float:center' class='k-icon k-i-filter'></span>").Filterable(f => f.Multi(true).Search(true)).Sortable(true);
  columns.Bound(m => m.PurchaseOrderNumber).Width(100).Title("PO").HeaderTemplate("PO <span style='float:center' class='k-icon k-i-filter'></span>").Filterable(f => f.Multi(true).Search(true)).Sortable(true);
  })
  .HtmlAttributes(new { style = "font-size:0.85em;" })
  .Filterable()
  .ColumnMenu()
  .Reorderable(reorder => reorder.Columns(true))
  .Resizable(r => r.Columns(true))
  .Scrollable(s => s.Height(340))
  .Pageable(pageable => pageable
  .Refresh(true).ButtonCount(10)
  .PageSizes(new [] { 25, 250, 2500 })
)
  .Sortable(sortable => sortable
  .SortMode(GridSortMode.SingleColumn)
)
  .ClientDetailTemplateId("itemdetail")
  .DataSource(dataSource => dataSource
  .Ajax()
  .Read(read => read.Url("/api/shipments").Data(jsPage + ".getParameters"))
  .PageSize(2500)
  .ServerOperation(false)
  .Events(events => events
  .Error(jsPage + ".GridService.onError")
  .RequestStart(jsPage + ".GridService.onRequestStart")
  .RequestEnd(jsPage + ".GridService.onRequestEnd")
)
)
  .NoRecords()
  .Events(events => events.DataBound(jsPage + ".onDataBound"))
)

It would be nice, if you can create a build-in property or function to create icon-only buttons/commands in a grid.

Actually it requires some workaround to realize this.

This Example create an edit button with the k-button-icontext class, but i want only an k-button-icon button. The destroy button gets the button name as default text.

@(Html.Kendo().Grid<WidgetDashboard.Models.Widget.WidgetData>()
    .Name("adminWidgetGrid")
    .Columns(columns =>
    {
        columns.Bound(p => p.Name).Width(150);
        columns.Bound(p => p.Active).Width(75);
        columns.Command(command => { command.Edit().Text(" "); command.Destroy().Text(""); }).Width(300);
    })
    //.ToolBar(toolbar => toolbar.Create())
    .Editable(editable => editable.Mode(GridEditMode.InLine))
    .Pageable(p => p.Refresh(true))
    .Sortable()
    .Scrollable()
    .Resizable(r => r.Columns(true))
    .HtmlAttributes(new { style = "height:450px; width: 100%" })
    .DataSource(dataSource => dataSource
        .Ajax()
        .PageSize(20)
        //.Events(events => events.Error("error_handler"))
        .Model(model => model.Id(p => p.ID))
        .Create(update => update.Action("Admin_Create", "Dashboard", new { id = Model.DashboardId }))
        .Read(read => read.Action("Admin_Read", "Dashboard", new { id = Model.DashboardId }))
        .Update(update => update.Action("Admin_Update", "Dashboard", new { id = Model.DashboardId }))
        .Destroy(update => update.Action("Admin_Destroy", "Dashboard", new { id = Model.DashboardId }))
    )
)

Alternative it would be ok if the correct css class is given when an empty string is specified.

Thank you

Christian

Hello,

I would like to suggest improvement to the function convertValues which is used in the virtualized datasources in multiple controls (dropdownlist, combobox, multiselect etc).

I've realised (after very long time) that the ValueMapper ajax is called in the initial loading, i.e. when there is no default value set in the control. In my opinion that request is extra unnecessary load and shouldn't happen if there is no value to be checked (mapped).

For example check this screenshot of the link https://demos.telerik.com/kendo-ui/dropdownlist/virtualization

In my code I started to surround with the following if:

if (options.value != "") {
        //value mapper code
    }
    else {
        options.success([])
    }

which stopped the initial value mapper ajax request.

This also helped to have only single value mapper request when there is default value set - otherwise it was generating 2 value mapper requests, one with empty value and another one with the set value.

I reckon this will help many users to improve their code.

Thanks.

Kind regards,

Kristina

Hello,

I am looking at possibility to convert Spreadsheet tables to html . I am creating an HTML report with header and footer and would like to merge the spreadsheet table as html between header and footer.

Is there a way to convert the spread content to html tables

Thanks

Anamika 

Also add appropriate dependencies to the current package like JQuery version. So in this case the MVC would be dependent on the main Kendo package and the Kendo package would depend on JQuery.

To whom it may concern,

       I’m one of your subscribed customers. And I’m writing to seek help in order to realize a filter display I want KendoGrid to show.

The following screenshot is the date filter display that KendoGrid has:

Can it be changed to the similar way as the following picture shows?

It is also acceptable if the filter can provide 3 different options to easily choose from for users:

1. Before a certain date that the user can choose from a calendar just like the picture above
2. After a certain date
3. Between two dates
4. In a certain date 

Thanks.

Best Regards,

BLACK STREAM