Questions on Kendo UI for jQuery Forum

3 answers

649 views

Format Column headers of Grid Before Exporting to Excel

Hi,

We are having a grid which should be exported to Excel. As this grid contains large data we are slanting the grid header columns to an angle.

So when we export this data to excel, we would like to rotate the header columns to 90 degrees. We have gone through this link

http://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook#configuration-sheets.rows.cells but couldnt find the help we need.

Can you help us on this?

Regards

Sripriya

Grid

answered on 12 Aug 2019

1 answer

230 views

Formula Editor

Are there any plans to add a formula editor in the Spreadsheet component?

Spreadsheet

answered on 09 Aug 2019

1 answer

184 views

Is it possible to prevent pasting in spreadsheet?

I would like to prevent users from being able to paste in my spreadsheet. They should be able to type directly in cells, however. Is this possible?

Thanks.

Spreadsheet

answered on 09 Aug 2019

1 answer

226 views

Applying resources based on a condition

Hi,

As the title says, is it possible to apply a a resource based on a condition or multiple fields?

For example, I'd like to colour events based on 'age' and 'country'. eg. country=SA && age<30.

Is this possible, or is there a work around that can achieve this?

Thanks,
Grant

Scheduler

answered on 08 Aug 2019

2 answers

110 views

Newbie - help setting modal content

I am trying to bring up a modal window and define the content of the modal from a partial view.

None of the content is appearing in the modal. Once I get this working I will expand on it.

Thanks for the help!

Here is the contents of the partial view file (.cshtml file in views folder)

<div id="mytemplate">
    <center>
        <span>
            <img src="/Home/DownloadResource/16FDD8CA-03CF-492B-8DA9-F7FEFC2EE2D5" style="height: 72px;" class="fa-spin" /><br />
            <h3 class="app-title" style="display:inline; vertical-align:middle;"> The scheduler is processing. This might take a moment...</h3>
        </span>
    </center>
</div>

Here is the portion of JavaScript I am using to create the modal (.js file in scripts folder):

$("#requestLoadDiv").kendoWindow({

modal: true,

width: "1000px",

title: "Event Details",

deactivate: function deactivate() {

this.destroy();

},

actions: [

"Pin",

"Minimize",

"Maximize",

"Close"

],

open() {

$.ajax({

url: "/Files/CalEventPartial.cshtml",

method: 'GET',

success: function (result) {

$('#requestLoadDiv').html(result);

}

});

}

}).data("kendoWindow").center().open();

Window

answered on 07 Aug 2019

1 answer

1.7K+ views

Datepicker focuses on date closest to today

Hi,

I'd like to know why the Datepicker auto focuses on the date closest to today's date?
See my example here, https://dojo.telerik.com/abijIxUH.

In my scenario, this auto focus could be misunderstood as a suggested date, when that is not the case.

How can the initial focused date be unfocused?

Thanks,
Grant

Date/Time Pickers

answered on 07 Aug 2019

23 answers

3.9K+ views

Refresh multi checkbox filter options when grid is filtered

How do I force a refresh of the filter menu item in a grid column when the grid is filtered after filterMenuItem has been fired?

The grid data source is having an initial filter, that might make the grid empty at initialization.

Scenario 1:

If I click on one of the grid column filter buttons (let us call it ReviewStatus) with a multi check box filter (filterMenuItem is fired), then there is of course no options available when the grid is empty. If I then clear all filters on the data source by calling grid.dataSource.filter({}) and the grid is now having rows, then there is still no options available in the ReviewStatus filter.

Scenario 2:

The first thing I do is to clear all filters such that there is rows available in the grid. If I use a multi check filter on one of the other columns to filter the grid then the options in ReviewStatus will be updated accordingly.

How do I force the filter menu item to sync the data source with the grid data source after the filter menu item is initialized?

My grid has a the following grid options:

dataSource:{

type: "odata",

serverFiltering: true,

serverSorting: true,

filter:{ field: "Country": operator: "eq", value: "UK" }

},

columns: [ { field: "ReviewStatus", filterable: { multi: true } }, { field: "Country", filterable: { multi: true } }, { field: "Severity", filterable: { multi: true } }, { field: "SensorName", filterable: { multi: true } }

],

filterable: true,

navigatable: true,

selectable: "multiple",

resizable: true,

reorderable: true,

sortable: true,

columnMenu: false,

pageable: false

Grid

answered on 07 Aug 2019

2 answers

110 views

Always downloads files again

I have an ASP.NET MVC application that loads a bunch of javascript files when it starts up. Every time I create a kendoWindow, I can see in Google Chrome where it reevaluates all the css and javascript files to see if they have changed. Of course, it always returns 304 responses. How do I disable this check each time a kendowWindow object is created and opened. I don't want all these files checked again because it slows things down. I can enable optimizations in the bundle but that doesn't help much.

Window

answered on 06 Aug 2019

3 answers

749 views

prevent default behaviour of Destroy

Hi,

In this dojo example, https://dojo.telerik.com/atakEcUH, I am not able to prevent the default behaviour of remove event like how it works in edit event.

Can you please help?

Thanks,

Vaishali

Gantt

answered on 06 Aug 2019

7 answers

986 views

Performance issue

Hi,

I am having performance issue on our webapp using Kendo UI for jQuery:
In average, 20 columns are shown, 100 are hidden (style="display:none").
The Kendo grid is using a lot of CPU when navigating, loading filters or editing data inside cells. The browser (Firefox) can freeze sometimes.

2018.1.117 version of Kendo is used, do you think we could gain performance by upgrading to the latest Kendo version ?
I would enjoy too if you have any other advices about Kendo perf, bad practices to avoid ...

Thank you.

Complementary infos:
Templates are used for some columns
server Paging is true for the grid

General Discussions

answered on 06 Aug 2019