or
5 answers
1.3K+ views
Hello,
I am using a client-side solution to export kendo grid data to Excel. I would like to be able to include line breaks within each cell. \r, \n, <br />, and don't work. Here's some sample code:
// ...excelExport: function (e) { var sheet = e.workbook.sheets[0]; var skillsIndex = 0; // First row. Find the skills column, and set the index. for (var i = 0; i < sheet.rows[0].cells.length; i++) { if (sheet.rows[0].cells[i].value == "Skills") { skillsIndex = i; break; } } for (var j = 1; j < sheet.rows.length; j++) { sheet.rows[j].cells[skillsIndex].value = "We got skills!"; // doesn't break the line between got and skills -- how to do so? }}// ...Thank you for any help you can provide!
Petar
Telerik team
answered
on
19 Dec 2019
11 answers
698 views
Hello,
I would know how to expand a row on column click but I've a custom function on expand and It's not working.
The row expand well with ".collapse(row)" but the custom function I've defined in :
expand: function(e){
setTimeout(function(){
customExpandFunction(e);
}, 20);
},
only works when I click on treelist expand icon.
Is there a way to make this works ?
PS : sorry for my english, I'm french
Tsvetomir
Telerik team
answered
on
19 Dec 2019
5 answers
274 views
Hi
I'm using virtual scrolling in a grid and want to show and hide columns dynamically.
While doing so, it seems to work first, but breaks, after scrolling down.
Hiding column 2 and scrolling down, removing column 2 values and replaceing them with column 3 values.
See example for this behaviour:
http://dojo.telerik.com/EJOZAJob/6
How to fix column values switching while scrolling and remaining correct columns and values on scroll.
Greets Robin
3 answers
1.0K+ views
Instead of using the Toggle button I would rather use a switch for a better visual representation.
If i add a template item as such:
items.Add().Template("<input type='checkbox' id='check'>");
and then I try to modify the attribute of the item using jquery as such, it fails (no error, it simply doesn't work):
$("#check").attr("checked", "checked");
but if i move the html markup out of the template and put it somewhere else on the page, it works perfectly fine. This also happens when i try to use:
$("#check").kendoSwitch();
If i move the checkbox out of the toolbar it works fine.
Is there a way to use the switch, inside the toolbar?
Ivan Danchev
Telerik team
answered
on
19 Dec 2019
3 answers
413 views
Hi,
The TimePicker is set to 30 minute intervals by default.
So if the time fits in that interval, the first time you open the dropbox, it will be focused at that time.
However, if the initial or recalled time is equal to 32 minutes or 49 minutes, the focus is set at 00:00.
Is there a way to round and focus to nearby times?
3:29-> 3:30 Focusing
2:14-> 2:00 Focusing
I don't want to change the value.
The focus only needs to move near that time.
The TimePicker is set to 30 minute intervals by default.
So if the time fits in that interval, the first time you open the dropbox, it will be focused at that time.
However, if the initial or recalled time is equal to 32 minutes or 49 minutes, the focus is set at 00:00.
Is there a way to round and focus to nearby times?
3:29-> 3:30 Focusing
2:14-> 2:00 Focusing
I don't want to change the value.
The focus only needs to move near that time.
Teya
Telerik team
answered
on
19 Dec 2019
1 answer
135 views
Hello,
I'm writing logic to add and store some data in an empty grid.
This is fine but I need data information for the rows I added before saving.
Accessing saveChanges () is easy to save, but I need a list of that data.
In summary
Please tell me how to access and use the data before saving the rows I just added with AddRow.
I'm writing logic to add and store some data in an empty grid.
This is fine but I need data information for the rows I added before saving.
Accessing saveChanges () is easy to save, but I need a list of that data.
In summary
Please tell me how to access and use the data before saving the rows I just added with AddRow.
Tsvetomir
Telerik team
answered
on
19 Dec 2019
5 answers
1.3K+ views
I have 15 data, showing 10 data per page.
1page = 10data, 2page = 5data.
Total [1, 2 Page]
There is no problem so far, but the number of pages does not decrease according to the number of new read ().
If there are only one row of results, only one page should appear,
[1, 2 Page] is maintained, “No data available" appears when page 2 is pressed, and page 2 disappears.
Attach as below picture.
Do you know how to solve this?
1. Display the grid.
2. Search by words.
3. Only data that meets the criteria is displayed.
4. However, the paging number does not change immediately with the number of data.
Petar
Telerik team
answered
on
18 Dec 2019
2 answers
397 views
I'm working through an Incell editable.
Select the list you want to delete and press the Delete button to execute the remove row and the row will be "temporarily deleted", and press the Save button to actually delete it with the Sync () method.
After that, the grid is refreshed.
But what I want
If a row is deleted, the following data fills in the empty spaces.
remove Row removes the row, but does not load the next piece of data to fill the empty space.
In other words, if you remove the entire page, you will get "no data".
I want to be filled with the next data as much as the deleted rows.
(Important) Clearly, if you actually delete it with Sync () method, the screen will be updated.
What I want is a refresh when I've only progressed to remove Row ().)
Is there a way?
Select the list you want to delete and press the Delete button to execute the remove row and the row will be "temporarily deleted", and press the Save button to actually delete it with the Sync () method.
After that, the grid is refreshed.
But what I want
If a row is deleted, the following data fills in the empty spaces.
remove Row removes the row, but does not load the next piece of data to fill the empty space.
In other words, if you remove the entire page, you will get "no data".
I want to be filled with the next data as much as the deleted rows.
(Important) Clearly, if you actually delete it with Sync () method, the screen will be updated.
What I want is a refresh when I've only progressed to remove Row ().)
Is there a way?
Veselin Tsvetanov
Telerik team
answered
on
18 Dec 2019
2 answers
343 views
dayDropDownEditor : function (container, options) { $('<input id="' + options.field + '" data-bind="value:' + options.field + '"/>') .appendTo(container) .kendoDropDownList({ suggest: true, dataSource: [ {name: '조업' }, {name: '안함' } ], dataTextField: 'name', dataValueField: 'name', valuePrimitive: true, }); }
Hi,
My dropbox list is displayed correctly.
However, the default is still "", which is blank.
I tried using select and also index but it didn't work.
How can I make Dropbox default to the first data if I don't pick anything?
If I pick one, the data is imported normally.
If uneven, it is empty.
NHJ
Top achievements
Rank 1
Rank 1
answered
on
18 Dec 2019
1 answer
438 views
Hi,
I have a PanelBar left side menu with content to the right. I am happy with the functionality but would like to be able to collapse the entire side to allow more horizontal space for content. Drawer seems to have this functionality but then I would lose the PanelBar menu functionality. I have tried to put the PanelBar into a splitter but this doesn't seem to work with bootstrap and the doesn't render properly.
Do you have any suggestions for the best way to implement a hideable PanelBar side menu?
Kind regards,
David
Preslav
Telerik team
answered
on
17 Dec 2019
