Questions on Kendo UI for jQuery Forum

1 answer

376 views

Hi,

In our application users can upload an excel file, this data is then displayed in a Kendo spreadsheet (JQuery) control. The templates we use to insert the data have 6 blank rows at the top:

Row 7 is the header row and the data starts at row 8.

Using the built in 'Export' function on the Kendo spreadsheet we are able to export the data. What we want to be able to do is export the data in the same format it was imported. i.e. with the 6 blank rows at the top and the header row on row 7.

I have played around with sheet.insertRow(0); but this leaves 0's in the numeric columns and also blanks out the header row.

Do you have any other suggestions?

Thanks

Ian

Spreadsheet

answered on 10 Jan 2022

4 answers

15.3K+ views

Uncaught TypeError: $(...).kendoGrid is not a function

I am trying to use Kendo Grid in a view.

In the main index.html I have reference for the required css and js files:

<link href="kendo-phcc/styles/kendo.mobile.all.min.css" rel="stylesheet">

<script src="kendo-phcc/js/jquery.min.js"></script>

<script src="kendo-phcc/js/kendo.mobile.min.js"></script>

I have a list view in the main index.html and each list item refers to a separate external view which is defined in it's own html file.

In the view html file I have this :

<div data-role="view" data-init="initGrid" data-title="Restaurants" id="restaurantsView">

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

</div>

<script>

function initGrid() {

//This alert was displayed

alert("Dummy");

$("#grid").kendoGrid({

columns: [{

field: "Attribute",

title: "Attribute"

},

{

field: "Value",

title: "Value"

}],

dataSource: {

data: [{

Attribute: "Mall/Location",

Value: "City Center/The Mall/Pearl"

},

{

Attribute: "ShopName",

Value: "Gold Gourmet"

}]

}

});

};

</script>

I have seen this forum and made sure that I made no such mistakes such as repeating jquery reference or not including required files.

StackOverflow-Reference

http://stackoverflow.com/questions/32917273/uncaught-typeerror-kendogrid-is-not-a-function

But still I have the error

Could you please help me out in this problem.

The app was created from Telerik Platform so it already had the required css and js files included.

I also tried creating a separate folder and manually adding all the required files from the Kendo UI Professional zip that I downloaded from my account.

But still I have the same issue.

I think this is a very basic question but I am just starting with kendo and Telerik so I would really appreciate your help

Grid

answered on 07 Jan 2022

10 answers

4.9K+ views

Export to excel - remove HTML tags before excel generation

Is it possible to get hold of the text that gets generated when we do grid.saveAsExcel(), so that we can remove certain html tags from the output before the excel (xlsx file) gets generated.

We need to remove the html tags from the excel that gets generated.

I am attaching a sample excel file so that you can see what (html tags) i intend to remove

Grid

answered on 06 Jan 2022

0 answers

106 views

Is there a way to to use svg to diplay a log in the appbar?

This does not work: https://dojo.telerik.com/UNIJebUR

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8"/>
    <title>Kendo UI Snippet</title>

    <link rel="stylesheet" href="https://kendo.cdn.telerik.com/2021.3.1207/styles/kendo.default-v2.min.css"/>

    <script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
    <script src="https://kendo.cdn.telerik.com/2021.3.1207/js/kendo.all.min.js"></script>
</head>
<body>
  
<div id="appbar"></div>
<script>
$("#appbar").kendoAppBar({
    items: [
        {
            type: "contentItem",
            template: "<span><input /><span>"
        },
        {
            type: "spacer"
        },
        {
            type: "contentItem",
            template: "<svg viewBox="0 0 100 100" xmlns="http://www.w3.org/2000/svg"><circle cx="50" cy="50" r="50"/></svg>"
        },
    ]
});
</script>
</body>
</html>

AppBar

NavBar

asked on 06 Jan 2022

1 answer

138 views

Is it possible to get this format to work with a password field or text file ??

Is it possible to get this format to work with a password field? For example, if I wanted to be able to add hyphens to a private number but still keep it masked with asterisks so that as the user typed, it would appear as shown in the image?

MaskedTextBox

answered on 06 Jan 2022

0 answers

100 views

Server side paged groups with ajax jquery remote data end point

I've tried to get this working using this aspnetmvc-ajax sample code from telerik found here.

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

I'm using jquery ajax restful api for the remote data endpoint and I am returning the response in the exact format as shown in the above example but it doesn't work.

After the grid loads, an "undefined" is displayed as the first row in the grid despite the data from the ajax data call returning the data in the exact same format as shown in the above example.

I also added the code for the sample into my project and I tried a local data source in order to rule out jquery ajax as remote api being the problem with the same response data format as the sample code to see if the server side group paging is anyway dependent on the datasource.type being aspnetmvc. In this case I also get the same error as seen in my jquery ajax grid with remote group paging.

Has anyone been able to get group paging for a grid using a custom function for the transport read (jquery ajax) configuration?

Can anyone confirm whether it should work for this use case? And does anyone have an example?

Thanks in advance and appreciate your help.

Best,

Don

Grid

updated question on 04 Jan 2022

1 answer

503 views

Customize hint Element when using rowReorder functionality on Grid

Is it possible for me to customize the hint Element during a row reorder operation using the kendo Grid rowReorder functionality?

Grid

answered on 04 Jan 2022

1 answer

862 views

Why e.model.isNew() is not a function ?

Hi everybody,

I post today because i have this code and my edit function return me "e.model.isNew() is not a function"... i don't know why ? :

$("#table-luminaire").kendoGrid({
          dataSource: {
            data: ares
          },
          editable: {
            confirmation: "blabla ?",
            mode: "incell"
          },
          toolbar:["excel", "create", "save"],
          sortable: true,
          columnMenu : true,
          resizable : true,
          pageable: {
              refresh: true,
              pageSizes: true,
              buttonCount: 5,
              pageSize: 20,
          },
          columns: [{
              field: "ID",
              title: "ID",
              hidden:true,
          }, {
              field: "CATEGORIE",
              title: "Catégorie",
              width: 135,
              editable: function() {return array_decode.includes("CATEGORIE");}
          }, {
              field: "CODE_INSEE",
              title: "Code INSEE",
              width: 140,
              editable: function() {return array_decode.includes("CODE_INSEE");}
          },
          { command: ["edit", "destroy"], title: "&nbsp;", width: "250px"}
          ],
          edit: function (e) {
              console.log(e)
            if (e.model.isNew()) {
                console.log('model')
            }
          },
          save: function(e) {
            console.log(e.values);
          },
          saveChanges: function(e) {
            console.log('ok save')
          },
          schema: {
            model: {
              id: "id"
            }
          },
        });

If someone have an idea ... Thank you in advance for your answers,

Erka

Grid

answered on 03 Jan 2022

4 answers

7.0K+ views

Minimum Width for Grid Columns

This seems to be a pretty good example, but unfortunately it doesn't work:

http://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/Layout/apply-minimum-width-during-column-resize

Is this deprecated? The binding to the resizable-events doesn't seem to work.

Grid

answered on 31 Dec 2021

1 answer

110 views

Drawing Library/PDF with column-count > 1

Hello,

I have a problem using the drawing library for creating PDFs with blocks being styled with a column-count style sheet being set to something other than 1 - it seems as if the drawing library is erroneously taking into account the sum of of all columns height instead of the real height when placing the output in a PDF, and thus leaving lots of blank space on the pages.

A working example can be found at Kendo UI Snippet | Kendo UI Dojo (telerik.com) (based on the page templates example)

Is this a known problem, am I missing something or is there any way/workaround to fix this?

Thanks & kind regards,

Hermann

Drawing API