Questions on Kendo UI for jQuery Forum

0 answers

108 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

143 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

635 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

163 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 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 Reason", title: "Status Change Reason", field: "CustomerStatusChangeReasonName", width: "20em", sortable: true },
{ headerTemplate: "Admit/Start 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 Care Date", title: "Resumption of Care Date", field: "ResumptionCareDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.ResumptionCareDate); } },
{ headerTemplate: "Discharged Closed Date", title: "Discharged Closed Date", field: "DischaredClosedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.DischaredClosedDate); } },
{ headerTemplate: "Status Comments", title: "Status Comments", field: "StatusChangeComment", width: "20em", sortable: true },
{ headerTemplate: "Status Change Date", title: "Status Change Date", field: "CreatedDateText", width: "12em", sortable: true, template: function (item) { return formatKDate(item.CreatedDate); } },
{ headerTemplate: "Status 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

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

how can I do it ?

thanks in advance

SPA

Spreadsheet

updated question on 29 Jun 2022

1 answer

190 views

Pagination in ImageBrowser of Kendo Editor

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

answered on 29 Jun 2022

1 answer

107 views

filemanager: Drag and drop validation

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

FileManager

answered on 29 Jun 2022

0 answers

163 views

Scheduler/ParseDate - Developer timezone specific?

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

Scheduler

asked on 28 Jun 2022

1 answer

400 views

Using MultiSelect column to achieve Mutli Column design

Hi,

I was researching available control in Kendo to achieve my requirements it seems that multi-select control is what I need. but I am unsure how i do the templating for the control. my markup for the dropdown is

<select id="users">
<option value="1" data-email="abc@email.com">User 1</option>
<option value="2" data-email="12@email.com">User 2</option>
<option value="3" data-email="adc@email.com">User 3</option>
<option value="4" data-email="anmf@email.com">User 4</option>
</select>

what I wanted to achieve is when the user is selecting the option to show User 1 - abc@email.com. then upon selected, the tag to show User 1.

I understand that multi-column combo box is able to achieve this but i need to be able to select multiple options. I also prefer to render the control via HTML way instead of using json data source

MultiColumnComboBox

MultiSelect

answered on 28 Jun 2022

1 answer

117 views

Use gantt within Kendo Drawer - position right

Hi,

I am trying to use Gantt widget with Drawer located at the right side.

For some reason, when I position drawer to the right, even with mini mode it is always outside of the screen (horizontal scroll appears) - if i expand drawer, it basically expands it to the right, and remains outside screen, horizontal scroll just expands area.

When drawer is positioned on the left it works normally (pushes gantt for width of drawer).

Behavior can be observed in following Dojo:

https://dojo.telerik.com/EdIQaXeY

Thank you very much

Regards

Vedad

Drawer

Gantt