Hi,

Is there any api that i can use to check if the row in the spreadsheet is hidden? TIA.

Regards,

Brian

Hello,

I'm using the Kendo Grid with Editing custom editor like the doc Edit custom but I have a real problem when I click on the "add button" there's no focus on the first column's new row.

I have the Datasource :

let DataSource = new kendo.data.DataSource({
        data: data,
        autoSync: true,
        schema: {
       }
})

And the grid

$('#grid').kendoGrid({
        dataSource: DataSource,
        pageable: false,
        height: 550,
        toolbar: ["create"],
        columns: [],
        editable: true
})
        

Of course schema and column are good with fields and model.

However when I add a new record, there's a new row but there's no focus on the first column input which have { validation: { required: true } }.

If I remove autoSync: true, I have the good action, and I focus out the error message display but I want to save when the focusout is fired on the field..
I don't understand why it's not working but if someone can help me it will be nice because I made it again and again whithout finding the solution (listening events 'Edit', 'BeforeEdit', 'EditRow' & 'EditColumn' but it only work with  "inline" or "popup" edit mode, or trying to focus on the first column's new row when the add button is fired).

Hope you see my problem.

Regards

Hi,

How do I set a dropdown list in the spreadsheet control cell manually? I will specify the list via the UI, I do not want to inputting the cell with the json injection.

TIA.

Regards,

Brian

Hi

Is this the example for REST API and the Grid ?

https://demos.telerik.com/kendo-ui/grid/editing

Hi

How I can make cascade drop downlist inside a grid like in this example :

https://demos.telerik.com/kendo-ui/grid/editing-custom

Hi

I would like to send a value (userid) with the read command of dataSource. I've done several tests but I can't catch the posted value in PHP.

Working ( $userid = $_POST["userid"] = 1234 on server side):

            $.ajax({
                type: 'POST',
                url: 'readparameter.php',
                data: {userid: "1234"},
                async: true,
                dataType: 'json',
                success: function(result) {      
                   console.log (result);
                }
            });

Not working ( $userid = $_POST["userid"] = NULL on server side):

var mySource = new kendo.data.DataSource({
            dataType: 'json',
            transport: {
                read: function (options) {
                    $.ajax({
                        type: "POST",
                        dataType: 'json',
                        async: true,
                        data: {userid: "1234"},
                        url: "readparameter.php",
                        success: function (result) {
                            console.log (result);
                        }
                    });
                }
            }
        });

My assumption is that the posted userid never reaches the server using dataSource. I'm trying since a lot of time and tried several ways like also Json.stringify etc. What am I doing wrong or is it just not possible to pass a value with dataSource?

Hi,

I have one requirement from our manager who wants to display some data as part of bubble chart like pie chart. (basically he wants to see something in bubble chart, but then split bubble value based on proportion (for example: bubble is total amount of resources used, but then its split based on how much of each resource participated in this).

Is it possible to achieve this somehow?

Thanks a lot!

Regards,

Vedad

I know how to do this, but I was wondering if there is a simpler way that I do not know. The solution I found seems a bit complicated for something that seemed simple at first.

I have a non-editable grid. For each item in Y, I have multiple cells in X displaying a counted number. I don't care about zeroes, so as to not draw attention to them I output a number only if it's not zero. To do that, the values I feed in my datasource needs to be in string format.

When I export this grid to Excel, by default all cells are of the "General" type. If I manually try to switch the cells to the "Number" type, it doesn't work right because the data is still a string.

I want my Excel export to have it's cells already in the "Number" type with it's data in the right format.

What I had to to is this :

- Change the values in my datasource to numbers, but now my grid displays zeroes.

- Create a template for my cells to control when to display numbers or not.

- Add a excelExport event handler to set my cells' format. The resulting cell type is always tagged as "Custom". Isn't there a way select one of the defaut Excel cell types? Is seems to work, but it feels weird to have to create custom formats to replicate default ones.

Did I miss something that would have made my life easier?

Thank you

Dears,

I need help in inline edit grid , i want way in that if user create row first time it add row (e.g item name, quantity), if user add same item again in the grid and that item exists in the grid update the quantity of first record and remove the new record.

how can i do that?

Thanks

Hi,

I'm sure this is a stupid question however I've not seen an example of how to do this.   I need to output just a simple status as a string in the popup editor external template when editing an appointment on the scheduler.    It does not need edited - it is there just to show the user if they are approved to request that appointment or not.   

I have the status value in my ViewModel and I need to display it on the appointment double click.  I've tried @Model.status but need something equivalent to @Html.Kendo().TextboxFor(m=>m.status).   By doing it this way the string shows but it is in a textbox of course.....I need to make it appear as just a string of text similar to a label.

Thanks for any help!