Seems Kendo is still not able to export image/PDF with the background. Any idea about this?

Dojo is here:  http://dojo.telerik.com/@jcbowyer/exuZi

I have a sheet with a header column, that I would like to preserve during an import of an Excel file.

In a kendoUpload.success event I import the uploaded Excel file like this: $spreadsheet.fromJSON(e.response);

Is there a clever way to have e.response inserted into the second column starting at cell A2?

/Morten

Hello,

I'm trying to fetch the total number of cells with validation errors; this works well with one sheet, but unfortunately, appears to cause issues when I have multiple sheets. I've followed https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/get-flagged-cells for starters... but have since wrapped it to iterate all sheets.

First concern: that method would consider undefined as invalid, which is often the case on initial load. Demo: https://dojo.telerik.com/OZOcasag (page load error count should be 0, but is instead 1)

Second Concern: If I update the method to consider not undefined, but === false... then I get into a system where the count is wrong/too-lower. Demo: https://dojo.telerik.com/iDoBiXAf/ . Please note that even starting with valid cells still shows this behavior when I make the cells invalid and bounce between cells. It's as if the cells are connected even though they're on different sheets.

Any advice on what I'm doing wrong or workarounds would be appreciated

Hi there,

Is there any provision for hiding the header but yet still being able to reorder by dragging the content around?

Many thanks

Paul

kendo-ui: ver. 2018.2.516

I want to select value in  headerTemplate then iterate throught all data in templates and if select in template contains same value change it. I can’t find any information how to do it

Could someone help me?

columns: [{
    title: "task",
    headerTemplate:
'<select kendo-drop-down-list k-options="$ctrl.multiSelect(dataItem)"></select>',
    field: "task_id",
template:
 '<select kendo-drop-down-list k-options="$ctrl.templateSelect(dataItem)"></select>',
    width: "240px"
}

Anyone by chance have any luck implementing fontawesome pro icons in a diagram? I was shown how to use the fontawesome free library icons like this:

... but this doesn't work:

FontAwesome Icon Cheatsheet: https://fontawesome.com/cheatsheet/pro/regular

Help me code How to get value id from dataSource by row and change to current value default (1)

in line:  var date = dataSource.get(1);
            console.log(date.ProductName)

My full source:

<div id="grid"></div>

    <script>
        $(document).ready(function () {
            var crudServiceBaseUrl = "https://demos.telerik.com/kendo-ui/service",
                dataSource = new kendo.data.DataSource({
                    transport: {
                        read:  {
                            url: crudServiceBaseUrl + "/Products",
                            dataType: "jsonp"
                        },
                        update: {
                            url: crudServiceBaseUrl + "/Products/Update",
                            dataType: "jsonp"
                        },
                        destroy: {
                            url: crudServiceBaseUrl + "/Products/Destroy",
                            dataType: "jsonp"
                        },
                        create: {
                            url: crudServiceBaseUrl + "/Products/Create",
                            dataType: "jsonp"
                        },
                        parameterMap: function(options, operation) {
                            if (operation !== "read" && options.models) {
                                return {models: kendo.stringify(options.models)};
                            }
                        }
                    },
                    batch: true,
                    pageSize: 20,
                    schema: {
                        model: {
                            id: "ProductID",
                            fields: {
                                ProductID: { editable: false, nullable: true },
                                ProductName: { validation: { required: true } },
                                UnitPrice: { type: "number", validation: { required: true, min: 1} },
                                Discontinued: { type: "boolean" },
                                UnitsInStock: { type: "number", validation: { min: 0, required: true } }
                            }
                        }
                    }
                });
          
            $("#grid").kendoGrid({
                dataSource: dataSource,
              selectable: true,
                pageable: true,
                height: 550,
                toolbar: ["create"],
                columns: [
                    "ProductName",
                    { field: "UnitPrice", title: "Unit Price", format: "{0:c}", width: "120px" },
                    { field: "UnitsInStock", title:"Units In Stock", width: "120px" },
                    { field: "Discontinued", width: "120px", editor: customBoolEditor },
                    { command: ["edit", "destroy"], title: "&nbsp;", width: "250px" }],
                editable: "inline",
              edit: function () {

                  var date = dataSource.get(1);
                  console.log(date.ProductName)

                } 
            });
        });
    </script>