Hello! I am using the exact same code as in this example: https://demos.telerik.com/kendo-ui/spreadsheet/datasource
When I try to add 1 validation like this:
sheet.range("$B2").validation({
from: '{ "Foo item 1", "Bar item 2", "Baz item 3" }',
dataType: "list",
messageTemplate: "Number should match the validation.",
showButton: true,
comparerType: "list",
type: "reject"
});
it works fine and shows it with no problem, but when I add a second one, the headers are not shown and I get this error:
Uncaught TypeError: Cannot read property 'indexOf' of undefined
at r.set (kendo.all.min.js:27)
at r.set (kendo.all.min.js:27)
at kendo.all.min.js:586
at init.forEach (kendo.all.min.js:511)
at init._sheetChange (kendo.all.min.js:586)
at init.trigger (kendo.all.min.js:4)
at init.triggerChange (kendo.all.min.js:526)
at init._set (kendo.all.min.js:518)
at init._property (kendo.all.min.js:518)
at init.validation (kendo.all.min.js:521)
This is all the code I added to the example:
var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
var sheet = spreadsheet.activeSheet();
sheet.range("$B2").validation({
from: '{ "Foo item 1", "Bar item 2", "Baz item 3" }',
dataType: "list",
messageTemplate: "Number should match the validation.",
showButton: true,
comparerType: "list",
type: "reject"
});
sheet.range("$C2").validation({
from: '{ "Ble item 1", "Ble item 2", "Ble item 3" }',
dataType: "list",
messageTemplate: "Number should match the validation.",
showButton: true,
comparerType: "list",
type: "reject"
});
Please help! thanks
Hi,
I have a Kendo Drop down, displaying remote data (of type odata) implemented as follows:
$("#listDropDown").kendoDropDownList({
filter: "contains",
dataTextField: "displayName",
dataValueField: "fieldid",
optionLabel: "Please Select..."
dataSource: {
type: "odata-v4",
transport: {
read: function (options) {
$.ajax({
url: someURL,
dataType: "json",
success: function (result) {
options.success(result);
},
error: function (result) {
console.log(result);
}
});
}
}
}
});
the 'fieldId' in this case is of type GUID. The drop down is created successfully and displaying data on screen. Using the no data template i can also successfully add a new item and refresh the drop down to the item is available on the list.
I would like to dynamically set the selecteditem on the drop to the item that has just been added. I am using the following code.
$("#listDropDown").data("kendoDropDownList").value(newFieldId);
'newfieldId' is a GUID that has been returned by the ajax call which has just created the new item. This is getting a value successfully, however doesnt appear to work. I have also tried hard coding this to use a value which i know existsin the drop down which i pass in as a string as i would expect a GUID to and this still doesnt work. This leads me to believe i havent configured my drop down correctly for using the GUID as the datavalue field.
Can you confirm if this is the case?
Many thanks

I have issue with getting grid name from toolbar component.
I have nested grid with dynamicly fill name, in these grid i have toolbar with combobox. OnChange event in these combo i need to refresh grid where is combo placed. How i can get name of the grid?
<script id="template" type="text/x-kendo-template"> @(Html.Kendo().Grid<Rule.TreeViewItem>() .Name("grid_#=Text#") .Columns(columns => { columns.Bound(o => o.HasChildren).Hidden(); columns.Bound(o => o.Text).Filterable(flr => flr.Cell(cell => cell.Operator("contains").ShowOperators(false))); columns.Bound(o => o.ObjectPath).Filterable(flr => flr.Cell(cell => cell.Operator("contains").ShowOperators(false))); columns.Bound(o => o.ChildrenPath).Filterable(flr => flr.Cell(cell => cell.Operator("contains").ShowOperators(false))); }) .ToolBar(t => t .Template("#= kendo.render(kendo.template($('\\#comboTemp').html()), [{ Text, ChildrenPath }]) #") ) .Events(e => e.DataBound("removeExpander")) .Resizable(resize => resize.Columns(true)) .Filterable(ftb => ftb.Mode(GridFilterMode.Row)) .ClientDetailTemplateId("template") .DataSource(dataSource => dataSource .Ajax() .PageSize(100) .Model(m => m.Id(o => o.ObjectPath)) .Read(read => read.Action("GetAttributes", "Rule", new {objectPath = "#= ChildrenPath #"})) ) .Pageable(pageable => pageable .Input(true) .Numeric(false) .PageSizes(new int[] {10, 20, 50, 100}) .Refresh(true) ) .AutoBind(false) .Sortable(sort => sort.SortMode(GridSortMode.MultipleColumn)) .ToClientTemplate() )</script><script type="text/x-kendo-template" id="comboTemp"> @(Html.Kendo().DropDownList() .Name("targetFor#=Text#") .DataTextField("SchemaName") .DataValueField("SchemaPath") .Events(events => events.Change("onNestedSchemaChange")) .DataSource(ds => ds.Read("GetTargetSchemas", "Rule", new { objectPath = "#=ChildrenPath#" }) ) .ToClientTemplate() )</script><script type="text/javascript"> function onNestedSchemaChange(e) { // code here }</script>I'm able to export a .xls file without any trouble, but I would like to make it password protected. Is this supported?
I found this: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/protection/worksheet which appears to be what I'm trying to achieve, only in JavaScript.

Hello,
I would like to customize the hours display as follows:
9H
11H
14H
16H
18H
18H30
19H
My Code:
$("#schedulerQ").kendoScheduler({
date: new Date('28/01/2018 09:00'),
startTime: new Date(),
views: [{ type: "week",
dateHeaderTemplate: kendo.template("<span class='days-name'>#=kendo.toString(date, 'dddd dd/MM')#</span>")}],
minorTickCount: 1, // display one time slot per major tick
majorTick: 60,
allDaySlot: false,
selectable: true,
...
});
but I have the display:
09:00
10:00
11:00
12:00
....
I need your help, Thanks.
Hi,
We have one grid in which we have one column for every day between two different dates, it works fine with one year but fails when we have more than one, you could see the error into this Dojo (https://dojo.telerik.com/asIVaS/2). It works with our previous version (2017R2SP1) but fails with newest ones. It looks like there are one error into rowtemplate. There is something wrong or any workaround to skip that error?
Thanks in advance

Hi
I have this annoying blue border around the Kendo TabStrip whenever it is selected.
Please see attached image.
Does anyone know how to use it please?
Thanks.

I just upgraded my kendoUI code to the latest release, and now my markers don't show up on the map. I copied the old kendoUI code back in and they show up just fine. Anybody else experiencing this? The tooltips still work fine when I mouse over a spot where the marker should be.
Here's my code
var markerUrlFormat = "GetMarkerData.aspx?lat={0}&lng={1}";resultsMap = $("#resultsMap").kendoMap({ center: [44.367966, -100.336378], zoom: 7, layers: [ { type: "bing", imagerySet: "road", key: bingMapsKey }, { type: "marker", dataSource: agMapResultsDataSource, locationField: "LocationArray", tooltip: { iframe: true, content: { url: "GetMarkerData.aspx?lat=0&lng=0" }, requestStart: function (e) { e.options.url = kendo.format(markerUrlFormat, e.sender.marker.dataItem.Latitude, e.sender.marker.dataItem.Longitude); }, autoHide: false, width: 350, height: 300 }, titleField: "StreetAddress" } ]}).data("kendoMap");