Hi Kendo folks,

In our implementation of kendo spreadsheet, we use datasource binding, and rely closely on kendo spreadsheet to notify datasource about changes to the sheets to keep data consistent. However, we noticed that undo command (whether triggered by undo button or ctrl+z) will not notify the datasource about this change. For example, cell A:1 - Y:1 are bind to values in datasource, and Z:1 is bind a sum property which totals the values bind to A:1 - Y:1. 

When user 

1. enter value 1 in cell A:1 (value 1 appears in Z:1)

2. undo (ctrl+z)

expected: value 0 in Z:1, actual: value 1 remains in Z:1.

We hope kendo can fix this; it feels inconsistent. Other operation such as paste can consistently synchronize with datasource, but the undo doesn't.

Below are a bit of our finding in kendo source code, and hope that could help :

On paste (ctrl+v), the paste function calls range to setSate, and then sheet.triggerChange to invoke the SheetDataSourceBinder._sheetChange function, who calls the Range.values function, which is responsible for binding with datasource. However, Range.values is invoked only if e.ref (range reference) is provided. When user triggers undo, undo function will also trigger range.setState() function, but setState function itself will trigger the _sheetChange function without reference information, causing it to skip Range.values function. We suggest the undo function to do the same thing as paste, after calling range().setState(), also triggerChange with range reference.

Currently

paste => range().setState() & triggerChange({... ref: ref}) => SheetDataSourceBinder._sheetChange => Range.values

undo => range().setState() => SheetDataSourceBinder._sheetChange (no ref provided, end)

Best,

Anna

Hi, I have a listview that I use Jquery on to be able to have multi-select functionality by simply clicking the items, instead of needing to hold ctrl. When I attempt to gather the selected items using .select(), It implies that because selectable is undefined, that it can't find that information. This was previously a grid and it worked fine having the selectable property off and still using .select(). I also have another grid currently that applies the same functionality and it works. It seems to only be an issue with the listview. I can't set the selectable property to on because with my Jquery doing the selecting, it seems it doesn't know what to do to select and fails.

Here is my selection with Jquery:

$('#expensesView').delegate('.expense', 'click', function () {
        $(this).toggleClass('k-state-selected');
    })

The listView:

    $('#expensesView').kendoListView({
        dataSource: ExpensesDS,
        //selectable: "multiple",
        scrollable: "true",
        filterable: "true",
        height: 600,
        template: kendo.template($('#expenseTemplate').html())
    });

Method I'm using to get all the selected objects IDs:

    var listView = $('#expensesView').data('kendoListView');
    var ids = [];

    listView.select().each(function () {
        var dataItem = grid.dataItem($(this));
        ids.push(dataItem.expenseID);
    });

.select works fine on the grid without selectable being defined, but not in the listview. What should I do here?

Thanks!

Hello, the latest and greatest seems to have broken customizing actions.

You can see it on your demo page.

Clicking the custom icon there should pop up an alert but it doesn't

https://demos.telerik.com/kendo-ui/window/actions#

Apologies if this is a known issue:

As of what appears to be Kendo UI 2017 R3 SP1, the horizontal scrollbar doesn't behave like it used to.  Using the following example:

http://dojo.telerik.com/@mcook103/UVetI

If I choose Kendo UI 2017 R3 from the Library dropdown, run the example, and click on the empty space to the right of the horizontal scrollbar, it moves to the far right of the grid with one click.

If I choose any version after Kendo UI 2017 R3 (including the latest 2018 R1 version), I have to click multiple times to get the scrollbar to move just a fraction of the grid's width.

I've tested this in IE and Opera browsers and found the same results.

Hello,

I'm having a problem with the kendo ui scheduler, if you multiselect multiple events with CTRL and then try to move them to another Resource, you are not moving the last one because to drag it you have to click&drag and then it gets deselected, the only way to move is holding CTRL then select all events except the last one and then drag the last one, is there a way to fix this behaviour?

Thank you in advance.

I'd like to use the calendar widget but what I need is to be able to highlight certain dates. I have a result set from SQL that returns pay dates. I want to highlight the paydates, which will ultimately act as a parameter when passed into another method to do other things.

How would I go about doing this?

Good morning! 

We have a form with100 date pickers on it and it is a cause of forced reflow because a lot of popup controls that attached to the body elements (see attached files). Is it possible to configure kendo data pickers to use the same popup element like jQuery UI Date Picker? Please note that we have the same issue for other types of contols like CKEditor, multiselects and so on. 

Hi All,

i am new to KendoGrid ,i am facing couple of issues while implementing teh requirement. Any pointers will be highly appreciated.

1)  In my grid i have couple of columns , column-1 ( checkbox) and column-2 ( amount/Numeric) . column-2 is non editable.  The requirement is if i click on column-1 ( checkbox) column-2  value should get replace/copied over from some other column (say column-n) . the problem is since its non-editable i am not able to update this column on checkbox click event. if i make column-2 as editable then its working fine. But requirement is prevent it from manual editing  should only be edited from column-1 checkbox click event .   do i need to call   editCell and closeCell in checkbox click event method as a workaround. 

2) How can i call validate event on column-2 , seems  we are updating the column via checkbox click event and not manually( dell edit) , so validation method is not invoked.

Greetings - was looking for some help with this error I'm seeing:

"The binary operator Equal is not defined for the types 'System.Decimal' and 'System.String'."

I have a field that is a decimal type in the database and using this filter to try to search it:

restFilter.filters.push({ field: "OrderNumber", operator: "eq", value: searchValue });

I am passing it a value of "001" so it is numeric. Not sure why it's not working?

Could someone help - thanks!

Craig

Hello,

Is it possible to force the current page to always be in the center of the pager? Such as if you're on page 5 then the pager would show [ 3 4 5 6 7 ] instead of [ 1 2 3 4 5]. Essentially the active page would always be centered.