Hi there,

I have posted a reply from this thread Scrollbar is missing after filtering the grid

I was wondering if anyone out there could help me with my issue?

Any help is greatly appreciated.

Cheers,

Junius

Hi

I'm creating a custom async function that for some reason bugs out the spreadsheet. 

The first few calls work fine, but after a while, the args passed are not the values of the cells, but the code of the cells. I had to use the raw function to test it out. This is what I mean, on the spreadsheet it goes like =getdata(B1,"name",C4,"a") for instance. Which should call the function with values from cell B1 and C4, correct?

Well, it does, for a few calls. Then suddenly it's not the value of B1 what is passed into the call, but "B1" itself. 

I wrote this simple test that will print out the error.

You can see it running at:

http://valuation.joaquingrech.com/test

kendo.spreadsheet.defineFunction("getdata", function (callback, args) {
                try {
                    var name = args[1];
                    var date = args[2];
                    var ar = json[name];
                    var mindate = 2012;
                    if (ar.constructor === Array) {
                        var index = Number(date) - mindate;
                        callback(ar[index]);
                    }
                    callback(ar);
                } catch (e) {
                    if (!displayed)
                        alert('error args:'+args+' error:' + e);
                    displayed = true;
                }
            });

so how do I fix it?

I am using Kendo dropdownlist with server side filtering using jquery in mvc,i'm facing one issue like when i type any special character like ? &  ‘  - ..etc,the filter is not working

I have tried to debug the code in backend, in Request.Params.Get("filter[filters][0][value]") the value is getting null 

is there any setting to filter special characters in search filter? please let me know 

below is the code that i have used.

$('#kendodrop').kendoMultiSelect({
            placeholder: "Select",
            dataTextField: "Text",
            dataValueField: "Id",
            filter: "contains",
            filtering: function (e) {
                var filter = e.filter;

                if (filter != undefined && !filter.value) {
                    //prevent filtering if the filter does not value
                    e.preventDefault();
                }
            },
            noDataTemplate: 'No Data!',
            height: 290,
            virtual: {
                itemHeight: 26,
                valueMapper: function (options) {
                    $.ajax({
                        url: '../controller/valueMapper',
                        type: "GET",
                        dataType: "jsonp",
                        success: function (data) {
                            options.success(data);
                        }
                    })
                }
            },
            dataSource: {
                transport: {
                    read: {
                        type: "POST",
                        url: "../controller/getdata",
                        dataType: "json",
                    },
                    parameterMap: function (options) {
                        return options;
                    }
                },
                schema: {
                    data: 'data',
                    total: 'total',
                    fields: [
                        { field: 'Id', type: 'number' },
                        { field: 'Text', type: 'string' }

                    ]
                },
                pageSize: 44,
                serverPaging: true,
                serverFiltering: true
            },
            dataBound: function (e) {
                //prevent the click event for disabled ones
                $(".optiondisable").parent().click(false);
                $(".optiondisable").parent().css("background-color", "#E4E6E9");
                //var listContainer = e.sender.list.closest(".k-list-container");
                //listContainer.width(listContainer.width() + kendo.support.scrollbar());
                e.sender.list.find("li").addClass("k_advautowrap");
                deffered.resolve();
            }
        });

Hi

By default the spreadsheet has a height that it's way too small for my excel sheet. Half of my webpage is just blank space with a tiny box with the spreadsheet.

How can I make it taller? I tried div style height:100% but that didn't work. Also hardcoding it on px may not be a good idea since everyone has a different screen.

Ideally it should be the height of the latest visible excel row.

so:

1) Can I make it so it goes full screen (all area of the web page)?

2) Even better, can I make it so that it goes to the height of certain row position? Like if I want to make it all visible without scrolling the component up to row 100 for instance.

Is there a slimmed down paging available for sites that have large amounts of content that are not within a Kendo grid control? I would like to use the same paging control that I use in the grids at the bottom of long pages. I want to use one at the end of my blog site (http://gregoryalexander.com/blogCfc/client/?reinit=1&theme=silver)

Please advise, I spent around 30 minutes and could not find anything specific on the web. 

On a grid is it possible to display an error message from the viewmodel datasource in the no records template?

I know you can display a custom string like this.

data-no-records="{ template: 'No Records Today!'}"   

In playing with a Kendo Grid I found that it's possible to enter Javascript code into the json dataSource and get it to execute.

This is the snippet I worked with as a proof of concept:

https://dojo.telerik.com/@andyrblank/uSAmapAV

I found this while entering data into a MVC grid for testing.

Hi, 

As my title says when i export my Grid to PDF, the export is stopping short, please look at the attachment, i dont know how to explain whats happening.

My config is as follows:

And my PDF config in my grid is here:

I have no clue, its like kendo lost interest in drawing the rest of the grid? :D

Please advise.

Thanks,
Grant