when importing a spreadsheet which has named ramges the named ranges are not imported. So any cells that reference these by range name do not work.

See attached file for demo.

Nick.

Check the attached sample, and try editing a value and then click on enter (it should move to the cell below). It is very very very slow.

Please help.

Is there a way to increase the width of the cell dropdown list, which appears when you do range.validation({ my list here });

Thanks!

Hello.

Sorry about asking the same question in Scheduler tread.

Is there any way to implement "export to pdf an excel" functionality in Angular 2 Grid component?

I decided to start a new thread since I now understand the problem better.

Im using a standard visual studio bootstrap 3 template as basis for a textbox and kendo.ui.grid grid.

I managed to get the grid to be full screen width and follow the browser when sized (only width, not height), that is shrink if you shrink the browser size.

My grid allways starts in about 1/3 of the screen size (height, width is fine), and even though I set the pagesize in the grid to 40 rows that doesnt change.

Is there a way that I can let the grid height use the browser height without having a scrollbar ? also follow its size when I resize the browser.

I would also like to be able to accomodate different resolutions and possibly pads or mobile devices.

I did have a look at a demo where this was nicely done in jfiddle, but I never managed to find the settings that controlled it, I tried copying every setting I found there over to my project to no avail.

The only difference I see is that my grid is constructed in .cshtml page but your demo is in javascript and only done clientside.

My grid gets it data from server side calls, so I cannot use client side only, but yes I could use ajax calls to get my data.

Regards,

Emil

Hi,

if my browser is on a 4k display I can get a lot more result lines on each screen than on 1080p is there a way for the grid to size its results based on the size of the display? its kind of awkward to have results that only use 20% of the screen size when you have a lot more space to use.

Regards,

Emil

Hello,

if i bind a datasource with mvvm to a grid through the data-bind attribute and for example try to trigger manually the read method of the datasource it seemed that it has no effects on the grid. Now i compared the viewmodel datasource with the datasource from the grid and they did not match. Why is this so? 

Thanks in advance

Michael

I have a field in my datasource who's value from the server is a 'Y' or a 'N'. I need to display that string value on the grid. When editing the value, I need to show a checkbox, checked if value == 'Y'.

There are 2 ways I can try to solve this problem, as I can tell, but I have problems/questions with each approach.

1. I can change the data model by making the field of type boolean, ie:
model: {
    fields: {

        "myFlag": { type: 'boolean"}

}}

, then changing the template of the column template like so: ` template: "#= (myFlag) ? 'Y' : 'N'"

This gets my desired UI result. However, all of my records on the grid display 'N', even though most of the records have 'Y' as their myFlag value. So therefore, how do I tell the datasource that 'Y' is true and 'N' is false? Furthermore, why does my grid currently treat myFlag as false when myFlag does indeed have a string value in it, which should equate to true.

2. The other approach is to leave my data source alone and just build a custom editor. However, most tutorials out there use a template to show a checkbox. I don't want to do that; I want to display "Y/N", and only render the checkbox when editing. I do not see any examples out there with this configuration. Here is my current editor for this checkbox:

editor: function (container, options) {
var value = options.model[options.field];
$('<input required name="' + options.field + '" type="checkbox" data-bind="checked:('+options.field + '==\'Y\')" />')
.appendTo(container)

}

note, i've also tried setting the html attribute 'checked' to no avail.

Hi,

I am using the trial edition of the Kendo UI products and I'm working on a scheduler proof of concept.

I've reviewed numerous items in this knowledge base and on the common issues site and I still am unable to get any scheduler events from my api to show on the scheduler. I'm attaching my .html document and the results of my api service call from the browser. I have compared the date formatting to this data from your samples (https://demos.telerik.com/kendo-ui/service/meetings) and I don't see any differences related to the date formatting. I have also tried formatting the date in these formats being returned by the api - yyyy-MM-ddThh:mm:ssZ, yyyy/MM/dd hh:mm:ss AM/PM with no luck.

I can get my resources to appear on the scheduler ok and as you will see in my .html file that I can create an event associated to one of the resources with no problem when I manually create the event in the datasource.