Questions on Kendo UI for jQuery Forum

1 answer

352 views

SaveasExcel Fails

I'm exporting a kendo grid to excel and it only fails under certain circumstances, generally when there's a large text field in one of the cells .The HTML is rendered fine, but when I open the workbook in excel it tells me the file has been corrupted (sometimes no data is in the worksheet at all). Read in the forums that this was an issue encountered by other users and there was a fix made to account for it, but I've upgraded to the latest version of the controls and I'm still seeing it. Any suggestions?

Grid

answered on 18 Jan 2019

3 answers

859 views

Foreign Key Fields with null values

Hello,

I have to create a foreign key field, but the field can be null. so in the example below I cant change the row with the null value with the drop down.

How can I fix that ?

Please help me!

br,
Kevin A1Telekom Austria AG

01.<!DOCTYPE html>

02.<html>

03.<head>

04. <base href="http://demos.telerik.com/kendo-ui/grid/foreignkeycolumn">

05. <style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>

06. <title></title>

07. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.common.min.css" rel="stylesheet" />

08. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.metro.min.css" rel="stylesheet" />

09. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.dataviz.min.css" rel="stylesheet" />

10. <link href="http://cdn.kendostatic.com/2014.2.716/styles/kendo.dataviz.default.min.css" rel="stylesheet" />

11. <script src="http://cdn.kendostatic.com/2014.2.716/js/jquery.min.js"></script>

12.

13. <script src="http://cdn.kendostatic.com/2014.2.716/js/kendo.all.min.js"></script>

14.</head>

15.<body>

16. <script src="../content/shared/js/products.js" type="text/javascript"></script>

17. <div id="example">

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

19.

20. <script>

21.

22. var categories = [{

23. 'value': null,

24. 'text': 'null'

25. },{

26. 'value': 1,

27. 'text': 'Cat1'

28. },{

29. 'value': 2,

30. 'text': 'Cat2'

31. },{

32. 'value': 3,

33. 'text': 'Cat3'

34. }];

35.

36.

37.

38.$(document).ready(function () {

39.

40.

41. var date = [{id: 1, name: "Jane Doe", category: 1},

42. {id: 2, name: "XXX", category: 1},

43. {id: 3, name: "XX2", category: null},

44. {id: 4, name: "XXX3", category: 1},

45. {id: 5, name: "XXX4", category: 3}];

46.

47. var dataSource = new kendo.data.DataSource({

48. pageSize: 20,

49. data: date,

50. schema: {

51. model: {

52. id: "id",

53. fields: {

54. name: { type:'string' },

55. category: { field: "category", type: "number" },

56.

57. }

58. }

59. }

60. });

61.

62.

63.

64.$('#grid').kendoGrid({

65. dataSource: dataSource,

66. height: 570,

67. filterable: true,

68. sortable: true,

69. pageable: true,

70. editable: true,

71. toolbar: ['save', 'cancel'],

72. columns: [

73.{ field: "name", title: "Name" },

74. { field: 'category', title: 'Category', width: '200px', values: categories , }

75. ]

76. });

77.});

78.

79.

80.

81.

82.

83. </script>

84. </div>

85.

86.

87.</body>

88.</html>

Grid

answered on 18 Jan 2019

14 answers

3.3K+ views

[Solved] Make Combobox non editable

How do I prevent user to enter any character in Combobox (and also datepicker) ?
I tried this but it doesn't work :

$(".k-input").attr("readonly", "readonly");

Best regards.

ComboBox

answered on 18 Jan 2019

3 answers

4.6K+ views

[Solved] Date Columns handling in grid

I am getting Data from Web API as array of object with one of the object's property/field as Date field. on API side its handled and returned as date . But when the data is retrieved after Ajax call , Grid (most likely Javascript as well) treat it as string and grid shows something like "2019-01-01T00:00:00".

I tried to use column.format to display it as date . which doesn't work .

Then i used Template to parse it using kendo.toString which worked,

But when i export grid to Excel or PDF it still shows 2019-01-01T00:00:00

Also i am trying to use Filter option on Column and trying to use Datetimepicker

column.filter.ui ="datetimepicker"

which shows the date picker but filter doesn't work.

Could you please suggest some solution or is there any step i am missing.

Thanks

Grid

answered on 17 Jan 2019

8 answers

1.6K+ views

grid.setOptions causes empty grid

Hi all,

in our Application we are using a normal grid. We are trying to save the Filters with the following code:

var grid = $("#myGrid").data('kendoGrid');

localStorage["kendo-grid-options"] = kendo.stringify(grid.getOptions());

This works perfectly. We are trying to reload our saved Filters with the following code:

var options = localStorage["kendo-grid-options"];
if (options) {
grid.setOptions(JSON.parse(options));
}

After this our Grid is just empty... The filters are applied to the coloumns..
If we click on the refresh icon on our grid or trigger the click in code ($('.k-i-refresh').trigger('click');) the filtered data appears?

Any ideas?

Our main target is to apply the filters on the first load.. So if we leave the page, and go back to the grid should directly display the filtered data.. But so far all our attempts failed..

Regards

Grid

answered on 17 Jan 2019

1 answer

174 views

Drag Labels

Hi,

Is it possible to enable dragging of labels so that they don't overlap? See the screenshot for what I mean. I have the chart like that and the labels overlap. Didn't find any way to make them draggable. Or is there any other solution.

Thanks

General Discussions

answered on 17 Jan 2019

2 answers

241 views

Change strikethrough toolbar button to insert strike tag instead of del tag

The strikethrough tool on the toolbar inserts a <del> tag by default. It looks like there may be support for inserting a <strike> tag or a <span style="text-decoration: line-through"> tag as well.

Are those other tags supported? If so, how can I change the default behavior to use one of those instead of the <del> tag.

Editor

answered on 15 Jan 2019

5 answers

1.6K+ views

[Solved] Hide series tooltip if mouse hover out data point

Hi,

I can show a tooltip, if the mouse hover over a data point: https://dojo.telerik.com/EWoPODum

The tooltip is closed, if the mouse leave the chart or if I click in the chart outside of the bars.

How can I avoid the click? The tooltip should hide if the mouse leave the bar.

Peter

Charts

answered on 15 Jan 2019

3 answers

627 views

[Solved] Set different line width of legend item

Hi,

it is possible to set the line width in the legend?

The second green line should have the double width of the first line. https://dojo.telerik.com/uGabOFUr

Peter

Charts

answered on 15 Jan 2019

10 answers

494 views

[Solved] Timeline misaligned sometimes

Hi,

We encountered strange behavior on gantt timeline. For certain situations gantt timeline scrolls to the right and then headers stop but timeline below keeps scroling but showing white space at the end and causing timeline to lose alignment.

for example, last element in gantt finishes on march 2019, and we scroll time line until then. When march is displayed in header header scrolling stops but timeline table below continue scrolling basically moving columns to the left, and showing white space on the right. This causes columns in timeline to misalign with their corresponding header columns, so task finishing on 15.12.2019. is displayed to be finishing week or two before, depending how much whitespace is added at the end.

See screenshots attached please.

Thank you and regards.

Gantt

answered on 15 Jan 2019