When importing data, we have a client that is using a spreadsheet link in their formula to grab data like so:

='H:\[OtherSheet.xls]Sheet1'!E3

(This other sheet does not exist in our system). When loading this into the Kendo spreadsheet via FromFile, we see the value [1]Sheet!E3 and the cell is highlighted red. This makes sense as we don't have the referenced sheet, but I noticed when we open the sheet in Excel, the cached value from for this cell exists and when using libraries like ExcelDataReader, we are able to parse out the actual cached value instead of looking for the sheet reference.

So how do we get the spreadsheet control to ignore the spreadsheet reference links and instead use the cached cell values that are already in the sheet?

Hi,

    I am using Kendo UI  controls for my MVC application. I am using "kendo.aspnetmvc.min.js" on my ASP.NET view.When my application is tested for Security issues by Burp(https://portswigger.net/burp/), the issue - "Open redirection (DOM-based)"  is reported into the kendo.aspnetmvc.min.js". The issue is reported because this js manipulates the URL as shown below. Please help me how we can resolve this security issue.

;i=location.search.replace(a,"").replace("?",""),i.length&&!/&$/.test(i)&&(i+="&"),t=this.setup(t,"read"),n=t.url,n.indexOf("?")>=0?(i=i.replace(/(.*?=.*?)&/g,function(e){return n.indexOf(e.substr(0,e.indexOf("=")))>=0?"":e}),n+="&"+i):n+="?"+i,n+=e.map(t.data,function(e,t){return t+"="+e}).join("&"),location.href=n

Thanks,

Alpesh.

(alpesh.chavda@allscripts.com)

We have a screen that includes 3 scheduler controls (previous, current, and next) with month-only views. Because these are all related, we need to have a change in the data for one be reflected in all three. I am sharing the dataSource between all of them because that way I don't need to query the database 3 times. Everything looks fine, except for the toolbar on top. Because each control has its own calendar, previous, and next buttons, the controls can be changed and get out of sync with the way we want them displayed. Also, we would prefer to show a title on them with the month and year rather than have a calendar control.

Is there any way to customize the toolbar? If so, how will the toolbar know which month is displayed? Is there a way to grab this piece of data? I am using AngularJS. 

Thanks!

Kendo grid allows drag and drop to reorder the columns. When I drag a unlocked column to the left of a locked column, this column will also be locked. I'm running into a situation where I can drag all visible columns and turn them into locked column. And the grid will crash because of this.

 I have setup a kendo grid that can reproduce my scenario on plunk: http://plnkr.co/edit/iTEPWXRKlZpzt3eCMirS?p=preview

To reproduce:

1. Hide the Country column (go to column menu and turn it off)

2. Drag the Last Name column to the left of First Name column 

Result:

- The column order will be [Last Name, FirstName]

- The Last Name column become locked

- (not shown in the plunk) but my own instances, the scroll bar will be gone

- Grid basically behaves very strangely afterwards.

I believe this is a bug.

In my Autocomplete I need to show grouped items, but groups have to be sorted non-alphabetically.

As the Autocomplete doesn't have such option, I tried using the serverGrouping option, but I guess I'm doing something wrong.

In fact the list of groups and items is correctly displayed (see attached picture #1), but typing any character in the input shows the NO DATA FOUND message (see attached picture #2 - typing "c" should show "Coffee" and "Cake"). Additionally items sorting doesn't seem to work.

This is the Autocomplete and its DataSource initialization code:

This is the json data returned by the server call:

Why the Autocomplete doesn't seem to work? Am I missing something in the Autocomplete settings, or DataSource settings, or JSON being sent by the server?

And why the sorting of items doesn't work?

Hello,

I'm trying to change the time dynamically for each day and each employee individual.

I've achieved that for all Views except the timlineMonth!

So every time I change the business hours dynamically, then the timelineMonth View does not work and one of these errors appear in the chrome devtools

kendo.all.js:113735 Uncaught TypeError: Cannot read property 'children' of undefined

OR

Uncaught TypeError: Cannot read property 'end' of undefined

I took the first Dojo example from you :

https://www.telerik.com/forums/how-to-set-business-hours-day-wise#6omvyHlQFkWOQVe1OTWdnw

and edited it to reproduce the issue:

https://dojo.telerik.com/aqekoJAG

steps to reproduce the issue:

1- change the time from the droplist (select) above the scheduler

2- change the view to timelineMonth

3- open debugger (e.g. devtools console) to see one of the error that I mentioned above 

 Thanks in advance

K.Ramadan

Hey,

I have a problem displaying texts that have multiple lines in my columns (text bound to a database and linebreaks are cr lf).

In the grid the texts are displayed in a single line.

My intuition would be to use a column template as I haven't found a way to configure columns to show multiple lines. But I don't know how this template would have to look like.

Could you help me with this?