When I tried to export excel, the data format changed.
For example, the data that is seen in the browser looks like this: 01:01:30
However, checking the excel after export, the time shows like this: 3690, which is seconds.
How can I get the same format in the browser and in excel?
Thanks.
{
field: "cn_busy_grp",
title: "통화시간",
columns :[{
field: "ts_busy_times",
title: "총통화시간",
template: '#=convertSecondsToString(ts_busy_times, "hms")#',
footerTemplate: '#=convertSecondsToString(sum, "hms")#',
groupFooterTemplate: '#=convertSecondsToString(sum, "hms")#',
width: "80px"
},Hi,
I'm tryign to dynamically change the tagMode of a kendo.ui.DropDownTree as a user selects more or less items but the control does not refresh/rerender
Below is a sample of the code I have tried...
var ddt = $(id).data('kendoDropDownTree');
var maxSelectedItemsDisplayedInSingleTagMode = 3;
let selectedValues = ddt.value();
let currentTagMode = ddt.options.tagMode;
let newTagMode = currentTagMode;
newTagMode = selectedValues.length <= maxSelectedItemsDisplayedInSingleTagMode ? "multiple" : "single";
if (newTagMode != currentTagMode) {
ddt.value([])
ddt.setOptions({
tagMode: newTagMode
});
ddt.value(selectedValues);
}
Something similar does work for the kendo.ui.MultiSelect but I cannot get it to play ball for kendo.ui.DropDownTree
Thanks

I get content as HTML encoded and would like to render this content as HTML in a grid row column using a template.
template: window.kendo.template($("#title").html())
<script id="title" type="text/x-kendo-template">
<strong>#:title#</strong>
<div>#:content#</div>
</script>
Have tried many (all) combinations of #:content#, #=content#, encoded: false, kendo.htmlEncode...
Please see the screenshot.
What am I doing wrong?
/Morten
Hello ,
I'm using below code for date validation
sheetForNPD.range("O2:O100").validation({
dataType: "date",
showButton: true,
comparerType: "between",
from: "DATEVALUE(\"1/1/1900\")",
to: "DATEVALUE(\"1/1/2050\")",
allowNulls: true,
type: "reject",
titleTemplate: "Start Date validation error",
messageTemplate: "Start Date should be between 1899 and 2050 year."
}).format('MM-dd-yy');
But i need if user enter in these format then also acceptable
Slashes
M/D/YY
M/D/YYYY
MM/DD/YY
MM/DD/YYYY
Dashes
M-D-YY
M-D-YYYY
MM-DD-YY
MM-DD-YYYY
Dots
M.D.YY
M.D.YYYY
MM.DD.YY
MM.DD.YYYY
Is it possible in kendo spreadsheet can i validate these format for single column ?

Hello,
I have applied range validation for numerical type data it's working until i'm entering single record but it's not working when i'm paste multiple record it's not validating please give me any solution.Thank you
sheetForRootCause.range("G2:G300").validation({

I use kendoEditor(jQuery) to let user create html content. Then, saving this content as html and using this html content to export to a pdf document by xmlParser.
I also restricted the width of kendoEditor by A4 page width in order to create a PDF document without fitting problem.
But the problem is the users are not able to know page end so their contents might be split. For example, they create a table and table header in kendoEditor but this table and its header can be split in two pages when exporting to pdf document.
So, is there a way to show page layout or a page end marker or line in kendoEditor?
toolbar: ["create"],
columns: [
{ field: "id", title: "Id", hidden: true },
{ field: "type", title: "type", hidden: true },
{
field: "tenantId", filterable: { multi: true, search: true} ,width: "200px", dataTextField: "name", dataValueField: "id", dataSource: {
type: "json",
transport: {
read: {
url: '@Url.Action("GetSyncingTennantsJsn", "dB")',
data: { type: ##I want to pass 'type' value for this row## }
}
}
}
},
{ field: "folder", title: "Folder" },
Many thanks!
Rob