Telerik Forums
Kendo UI for jQuery Forum
0 answers
3 views

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.

 

kypdk
Top achievements
Rank 1
Iron
 updated question on 01 Jul 2022
3 answers
16 views

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>

Johhny
Top achievements
Rank 1
Iron
 answered on 30 Jun 2022
0 answers
6 views

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",
Raji
Top achievements
Rank 1
 asked on 30 Jun 2022
0 answers
3 views

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.

Raymond
Top achievements
Rank 1
 updated question on 29 Jun 2022
1 answer
19 views
we can set diff font sizes for page, header, footer, but is it possible to set  for exported grid body (table)?
Lance | Manager Technical Support
Telerik team
 answered on 29 Jun 2022
7 answers
15 views

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 }
        ]
    });
Brightstar
Top achievements
Rank 1
Iron
 answered on 29 Jun 2022
0 answers
4 views

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());
        }
    });
  }


how can I do it ?

thanks in advance

kypdk
Top achievements
Rank 1
Iron
 updated question on 29 Jun 2022
1 answer
11 views

Hello,

I am working with application where I have thousands of images to load on ImageBrowser of Kendo Editor.

ImageBrowser is getting stuck as having too many images to load, Can we have any option to add pagination or lazy loading in ImageBrowser?

So, I can load only 20 images at a time and other based on request.

Please note that I am fetching images from controller method which returns list of FileBrowserEntry as below.

 

 

Thanks,

Trusha

 

Martin
Telerik team
 answered on 29 Jun 2022
1 answer
9 views

Hi Team,

I would like to fire a validation post drag but pre-drop, this should allow me to cancel the drop and show a message to enduser explaining the cause.

the drop event only allows to modify the rendered alert dialog but it doesnt allow me to cancel the event altogether. 

any help is appriciated.

Regards,

Ashutosh

Neli
Telerik team
 answered on 29 Jun 2022
0 answers
3 views

Hi,

I'm not sure if the issue I have is related to kendo ui, but seeing an issue where code I run on my local computer on central time works fine, but when I deploy to the server (eastern time), some of my dates are shifting in the Scheduler control when I iterate through it.

I'm using the kendo.parseDate function on start/end dates

return kendo.parseDate(kendo.toString(input, 'd')).toLocaleDateString("en-US");

That works fine locally, but deployed to the server shifts an hour, which then saves the wrong date in my database.

Is there a timezone saved anywhere in the configs for developer machine that might be getting pushed to server?  Switching my computer timezone to eastern and then deploying seems to work fine.


Thanks

Kevin
Top achievements
Rank 2
Iron
Iron
Iron
 asked on 28 Jun 2022
Narrow your results
Selected tags
Tags
+? more
Top users last month
Benjamin
Top achievements
Rank 2
Iron
Christopher
Top achievements
Rank 1
Iron
Bernd
Top achievements
Rank 4
Bronze
Iron
Iron
Timothy J
Top achievements
Rank 1
Iron
Iron
Iron
Marian
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Benjamin
Top achievements
Rank 2
Iron
Christopher
Top achievements
Rank 1
Iron
Bernd
Top achievements
Rank 4
Bronze
Iron
Iron
Timothy J
Top achievements
Rank 1
Iron
Iron
Iron
Marian
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?