Questions on Kendo UI for jQuery Forum

1 answer

565 views

Indeterminate state for Kendo Grid Checkboxes

i saw from the Kendo UI for Jquery Kendo Grid page is able to achieve the indetermindate state for checkbox but i cant seems to find how do i do it?

Checkbox

Grid

answered on 06 Jul 2022

1 answer

187 views

Kendo UI Scheduler Timezone

Hi All,

Can we pass Sql server timezone names like 'Pacific Standard Time (Mexico)' etc to Kendo Scheduler timezone option instead of passing like below. Or can we use any other option to meet this. Please help.

 timezone: "Etc/UTC",

Scheduler

answered on 05 Jul 2022

1 answer

1.1K+ views

Using FileManager as file manager for TinyMCE 5/6

Hello,

I am trying to use FileManager as the file manger for TinyMCE 6. I have been able to successfully get it to load in TinyMCE's windowManager dialog. All of the features of the FileManager work, except for uploading files. When I click on the Upload button, or drag and drop a file into the FileManager, nothing happens. When I view the browser console, I see a warning that says: The uploadDialog dialog is not available!

What will cause the uploadDialog to not be able to show?

I am using the FileManager in a plain .html file like so:

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title></title>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2022.2.621/styles/kendo.common-bootstrap.min.css" />
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2022.2.621/styles/kendo.bootstrap.min.css" />
<link href="https://cdn.kendostatic.com/2022.2.621/styles/kendo.bootstrap-main.min.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="telerik-file-manager.min.css" />

<script src="https://kendo.cdn.telerik.com/2022.2.621/js/jquery.min.js"></script>
<script src="https://kendo.cdn.telerik.com/2022.2.621/js/kendo.all.min.js"></script>
</head>
<body>
<div id="filemanager"></div>
<script src="telerik-file-manager.min.js"></script>
</body>
</html>

The jQuery code that I'm using to initialize the FileManager is:

$('#filemanager').kendoFileManager({
initialView: 'grid',
draggable: 'true',
resizeable: 'false',
dataSource: {
schema: kendo.data.schemas.filemanager,
uploadUrl: '/api/telerik-file-manager/upload',
transport: {
read: {
url: `/api/telerik-file-manager/read?filter=${filter}`,
method: 'GET'
},
create: {
url: '/api/telerik-file-manager/create',
method: 'GET'
},
update: {
url: '/api/telerik-file-manager/update',
method: 'GET'
},
destroy: {
url: '/api/telerik-file-manager/delete',
method: 'GET'
}
}
},
contextMenu: {
items: [
{ name: "select", text: "Select File", command: "SelectFile", spriteCssClass: "k-icon k-i-hyperlink-open" },
{ name: "rename" },
{ name: "delete" },
]
}
});

I am using ASP.NET Core 6 and I have the FileManager completely working great on a Razor Page, but I can't get the Upload feature to work when loading it into a TinyMCE windowManager dialog.

Any suggestions would be appreciated.

FileManager

answered on 04 Jul 2022

0 answers

117 views

Adding the data written to the cell to the validation with the changelistiner

Hello,

const processesList: string[] = ["Process 1","Process 2","Process 3"];

I want to add the word I wrote in the cell to the "list of validation" if it is not in the current list.

  SpreadValidation() {
    var spreadsheet = kendo.jQuery(this.spreadsheetEl.nativeElement).data("kendoSpreadsheet");
    var sheet = spreadsheet.activeSheet();
    const processesMerge = '"'+processesList.toString()+'"';
   
    sheet.range("B:AX").validation({
      dataType: "list",
      showButton: true,
      comparerType: "list",
      from: processesMerge,
      allowNulls: true,
      type: "warning"
    }); 
  }

change listener code

   var spreadsheet = kendo.jQuery(this.spreadsheetEl.nativeElement).data("kendoSpreadsheet");
    spreadsheet.bind("changing", this.changeListener);

  changeListener(e) {
    console.log("The netered value is: "+e.data);
    processesList.push(e.data);
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    var sheet = spreadsheet.activeSheet();
    const progressMerge = '"'+processesList.toString()+'"';
   
    sheet.range("B:AX").validation({
      dataType: "list",
      showButton: true,
      comparerType: "list",
      from: progressMerge,
      allowNulls: true,
      type: "warning"
    });    
}

I can capture the data I entered in the cell, but I could not add this word to the current validation list. how can I do it ?

My goal is that if the added word is not in the validation list, it will be added, and if there is, it will not repeat the data. in this way, it is always to increase the list and to be able to make a selection from the existing ones.

Spreadsheet

updated question on 01 Jul 2022

3 answers

154 views

Kendo filter field dropdown not loading.

I have a filter on a datasource which in return updates a grid. The following are the code to filter and its' template handler.

The problem with this is that, I can load the categories at first when I'm creating the filters. But when I save and reload the filter from local storage, the category dropdown does not load. Please help me with this. It loads up only on a fresh filter.

Thanks in advance.

@(Html.Kendo().Filter<Lovely>()
                                .Name("OrgFilter")
                                .ApplyButton(true)
                                .ExpressionPreview(true)
                                .DataSource("DataSource")
                                .Fields(f =>
                                {
                                    f.Add(p=>p.OrgName).Label("Organization");
                                    f.Add(p=>p.CategoryId).Label("Category").EditorTemplateHandler("CategoryDropdown");
                                    f.Add(p=>p.AsAtDate).Label("As At Date");
                                }))

<script>
function CategoryDropdown(container, options) {
        $('<input data-bind="value: value" name="' + options.field + '"/>')
            .appendTo(container)
            .kendoDropDownList({
                dataTextField: "CategoryId",
                dataValueField: "CategoryId",
                dataSource: @Json.Serialize(ViewData["Catogories"])
            });
    }
</script>

answered on 30 Jun 2022

1 answer

694 views

Export to pdf grid body font size

we can set diff font sizes for page, header, footer, but is it possible to set for exported grid body (table)?

Grid

answered on 29 Jun 2022

7 answers

175 views

Sort on Command column

Problem I'm having is first column with commands does not sort. Is this not supported?

$("#statusGrid").kendoGrid({
dataSource: {
transport: {
read: async function (options) {
KendoData_Read(
options,
BaseAbs3ApiUrl + "api/CustomerDetail/GetCustomerStatusDetail",
{ customerId: customerId }
);
}
},
sort: [{ field: "CreatedDate", dir: "desc" }]
},
dataBound: function (e) {
$(".k-grid-addDischarge").attr("title", "Add");
$(".k-grid-editDischarge").attr("title", "Edit");
$(".k-grid-viewDischarge").attr("title", "View");
},
toolbar: kendo.template($("#statusGridToolbarTemplate").html()),
scrollable: false,
excel: {
allPages: true,
fileName: "CustomerStatus.xlsx",
proxyURL: "/save",
filterable: true
},
excelExport: absKendoAutoWidthExcelExport,
sortable: true,
pageable: absKendoGridPageableDefault,
noRecords: { template: "No records to display." },
columns: [
{
command: [
{
name: "addDischarge",
text: "",
title: "Add",
visible: function (item) { return item.CanCreateDischargeDocument },
iconClass: "fas fa-plus fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = "/Customer/Discharge/Create/" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
},
{
name: "editDischarge",
text: "",
title: "Edit",
visible: function (item) { return item.CanEditDischargeDocument },
iconClass: "fa fa-pencil-alt fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = "/Customer/Discharge/EditByStatusChangeId/" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
},
{
name: "viewDischarge",
text: "",
title: "View",
visible: function (item) { return item.CanViewDischargeDocument },
iconClass: "fas fa-eye fa-border",
click: function (e) {
e.preventDefault(); // prevent page scroll position change
var tr = $(e.target).closest("tr");
var data = this.dataItem(tr);
var url = BaseAbs2Url + "SSRSReports/Report.aspx?report=DischargeandTransferSummary&cuCustomerStatusChangeId=" + data.CustomerStatusChangeId;
window.open(url, "_blank");
}
}
]
, headerTemplate: "Document<br />Actions", title: "Document Actions", width: "10em", sortable: true, field: "DocumentActions"
},
{ field: "Id", hidden: true },
{ title: "Status", field: "CurrentStatusTypeName", width: "20em", sortable: true },
{ headerTemplate: "Status Change<br />Reason", title: "Status Change Reason", field: "CustomerStatusChangeReasonName", width: "20em", sortable: true },
{ headerTemplate: "Admit/Start<br />of Care Date", title: "Admit/Start of Care Date", field: "AdmitStartCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.AdmitStartCareDate); } },
{ title: "Service Hold/End of Care Date", field: "ServiceHoldEndCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ServiceHoldEndCareDate); } },
{ headerTemplate: "Resumption of<br />Care Date", title: "Resumption of Care Date", field: "ResumptionCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ResumptionCareDate); } },
{ headerTemplate: "Discharged<br />Closed Date", title: "Discharged Closed Date", field: "DischaredClosedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.DischaredClosedDate); } },
{ headerTemplate: "Status<br />Comments", title: "Status Comments", field: "StatusChangeComment", width: "20em", sortable: true },
{ headerTemplate: "Status<br />Change Date", title: "Status Change Date", field: "CreatedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.CreatedDate); } },
{ headerTemplate: "Status<br />Changed By", title: "Status Changed By", field: "CreatedByName", width: "15em", sortable: true },
{ title: "Discharge/Transfer Document Status", field: "DischargeDocumentStatus", width: "12em", sortable: true }
]
});

Grid

answered on 29 Jun 2022

0 answers

143 views

Spreadsheet data import/export in Angular

hello,

I want to access the spreadshet object in Angular, export and import data.

Example

(A completely imaginary example. I don't know how.)

 dataExport() {
    kendo.jQuery(this.spreadsheetEl.nativeElement).kendoSpreadsheet({
        function() {
            var sheet = $("#spreadsheet").data('kendoSpreadsheet').activeSheet();
            var range = sheet.selection();
            console.log(sheet.toJSON());
        }
    });
  }