or
1 answer
128 views
I'm using Kendo UI R3 2021 SP2 (version 2021.3.1207). There is a bug in the Gantt component (https://github.com/telerik/kendo-ui-core/issues/6547). This bug has been fixed in Kendo UI R1 2022 SP1 (version 2022.1.301), but I cannot upgrade to the new version due to rendering issues. How can I fix the Gantt issue while staying on version 2021.3.1207?
Nikolay
Telerik team
answered
on
05 Jun 2024
1 answer
155 views
This is an odd request, I know. I have a client asking for a tree list style grid that opens up instead of down when you click on a parent field. They want this so that, when expanded, it matches their excel spreadsheets which have children at the top and subtotals at the bottom of each category followed by grand totals. Basically, think of the whole table body being flipped upside down like this (but it should be a grid with multiple columns):
Child of 1
Child of 1
Child of 1
Parent 1
Child of 2
Grandchild of 2a
Child of 2 (2a)
Parent 2
Nikolay
Telerik team
answered
on
05 Jun 2024
1 answer
158 views
Hii,
While exporting the data to excel the hidden columns appear for some time (some seconds) and disappear in kendo angular js, as I am hiding those column on grid using hidden: true and showing in the excel using showColumn(1), and I am experiencing the stange behavoir that after data exporting to the excel from the grid (includes available column on the grid and hidden columns as well), it shows hidden columns with data for some seconds on the grid and disappear and grid regain its original state, how to fix this behavior?
(Using, Kendo UI, angular Js, Jquery) and tried timeout, showing and hiding loader, css but not worked.
Nikolay
Telerik team
answered
on
05 Jun 2024
11 answers
3.1K+ views
Hi, how do I get the numeric textbox in the grid filter row to show integer values for an integer column? I can apply the filter correctly but after the filter applies it will change "33" to "33.00".
1 answer
222 views
I am trying to detect whether the rows in a spreadsheet have been changed. Thus far I haven't been able to get the dirty or isDirty flag to work with the dataSource that I am binding to the spreadSheet control.
Here is my dataSource:
$("#spreadsheet").kendoSpreadsheet({
columns: 20,
rows: 200,
toolbar: true,
sheetsbar: true,
dataSource: dataSource,
width: "100%"
});
Button control:
I click this button to check for dirty rows in the dataSouce:
//render and initialize button:
$("#save-sheet-btn").kendoButton({
icon: "forward",
themeColor: "primary",
click: saveSheet
});Button:
the saveSheet function mapped to the click option looks like this:
function saveSheet() {
var currSpreadSheet = $("#spreadsheet").data("kendoSpreadsheet");
var data = dataSource.data();
var dirtyItems = $.grep(dataSource.view(), function (e) {
return e.dirty === true;
});
console.log("Modified rows:", dirtyItems);
};
I am trying to avoid sending back the entire sheet structure or data source when I want to save the spreadsheet contents, as the dataSource in the real program could get very large (1000 + records)..and only send back the rows that have been edited... that is why I am trying to detect them copy them to a smaller structure and send them in a request body (HTML POST).
How I have been testing it:
(1) Page loads, initializing in a jQuery: $(document).ready(function () {}) block.
(2) Change a cell value.
(3) Click the save button
(4) View the onclick function consol.log(...) and look within the array for any indication that the row dirty flag has been tripped.
Thus far the array is empty.... so what am I missing? I am not using any of the transport options, and maybe I should? also I usually have to grab the data from a .NET Web API... and the response comes back in the form of a JSON array similar to the below Dojo page.
As you can see the initialization of the spreadSheet, dataSource and button in this example is pretty bare bones... I only like to initialize kendo ui widgets/components with the bare minimum I have to. So. there are options missing. My full example code is located here:
UPDATED:
Spreadsheet |Save If Dirty | Kendo UI Dojo (telerik.com)
Thanks again for your help and patience!
George
George
Top achievements
Rank 3
Bronze
Bronze
Iron
Rank 3
Bronze
Bronze
Iron
updated question
on
03 Jun 2024
1 answer
152 views
The selected value in the comboBox may not always reflect what the client entered due to a timing issue. For instance, if the client enters a value and presses enter before the filtering process is completed, they may not receive the intended value. Instead, they may receive the top value in the filtered results.
Does anyone know a dependable solution to resolve this issue?
Does anyone know a dependable solution to resolve this issue?
1 answer
163 views
Sometimes, I find it easier to initialize widgets using data attributes.
However, I often find it difficult to find precise documentation on initialising specific widget properties, and I find myself trying out various attributes combinations.
1) Can all properties/settings for every Kendo UI jQuery widget be initialized using data attributes?
2) Where can I find documentation (API documentation) on initialising every property/setting for each widget using data attributes?
Yordan
Telerik team
answered
on
30 May 2024
1 answer
125 views
I have a jQuery grid where i enabled inline editing for some fields, but I want to edit multiple rows and allow to get data updated locally, and on any button click it should it the method/api. But if I set the autosync property to false I can not update the record in the grid.
@{
Layout = null;
}
<link href="https://kendo.cdn.telerik.com/themes/8.0.1/default/default-main.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2023.1.100/styles/kendo.default-v2.min.css" />
<script src="~/Scripts/kendo.all.min.js"></script>
<div id="example">
<div id="grid"></div>
<script>
$(document).ready(function () {
var crudServiceBaseUrl = "/Kendo",
dataSource = new kendo.data.DataSource({
transport: {
read: {
url: crudServiceBaseUrl + "/IndexGrid",
dataType: "json"
},
update: {
url: crudServiceBaseUrl + "/UpdateUserDetails",
type : "POST",
dataType: "json"
},
//destroy: {
// url: crudServiceBaseUrl + "/detailproducts/Destroy",
// dataType: "jsonp"
//},
parameterMap: function (options, operation) {
debugger;
if (operation !== "read" && options.models) {
return { models: kendo.stringify(options.models) };
}
}
},
batch: true,
pageSize: 20,
autoSync: true,
//aggregate: [{
// field: "TotalSales",
// aggregate: "sum"
//}],
//group: {
// field: "Category.CategoryName",
// dir: "desc",
// aggregates: [
// { field: "TotalSales", aggregate: "sum" }
// ]
//},
schema: {
model: {
id: "UserLink",
fields: {
UserLink: { editable: false, nullable: true },
UserName: { type: "string", editable: true },
Mobile: { type: "number", editable: true },
Email: { type: "string", editable: true },
DOB: { type: "date", editable: true },
CourseOpt: { type: "string", editable: true, nullable: true },
}
}
}
});
$("#grid").kendoGrid({
dataSource: dataSource,
columnMenu: {
filterable: false
},
height: "100%",
editable: "popup",
pageable: true,
sortable: true,
navigatable: true,
resizable: true,
reorderable: true,
groupable: true,
filterable: true,
dataBound: onDataBound,
toolbar: ["excel", "pdf", "search", "create", "save", "cancel"],
pdfExport: function (e) {
const width = e.sender.wrapper.width();
e.sender.wrapperClone.width(width);
e.sender.wrapperClone.addClass('k-clone');
},
columns: [
{
field: "UserName",
title: "UserName",
width: 300
},
{
field: "Mobile",
title: "Mobile"
},
{
field: "Email",
title: "Email ID",
width: 130,
},
{
field: "DOB",
title: "DOB",
editor: datePickerEditor,
width: 125
}, {
field: "CourseOpt",
title: "CourseOpt",
editor: clientCourseEditor,
width: 200,
},
{ command: ["edit", "destroy"], title: " ", width: 120 }],
saveChanges: function (e) {
// Manually sync changes
dataSource.sync();
}
});
});
function clientCourseEditor(container, options) {
$('<input required name="CourseOpt">')
.appendTo(container)
.kendoDropDownList({
autoBind: false,
dataTextField: "Title",
dataValueField: "CourseLink",
dataSource: {
transport: {
read: {
url: "/Kendo/CourseDtls",
dataType: 'json'
}
}
}
});
}
function datePickerEditor(container, options) {
$('<input data-bind="value:' + options.field + '"/>')
.appendTo(container)
.kendoDatePicker({
format: "dd/MM/yyyy"
});
}
function onDataBound(e) {
debugger;
var grid = this;
grid.table.find("tr").each(function () {
var dataItem = grid.dataItem(this);
kendo.bind($(this), dataItem);
});
}
//function returnFalse() {
// return false;
//}
</script>
</div>
Nikolay
Telerik team
answered
on
29 May 2024
1 answer
123 views
We have some cells with tabs (\t) character we need to export to excel.
When exporting, the tabs are removed after calling the function workbook.toDataURLAsync.
Can be reproduced here
https://dojo.telerik.com/@foxontherock/ATUzudIL
Peter Milchev
Telerik team
answered
on
28 May 2024
2 answers
152 views
We are experiences an issue with the Flip effect in the latest version of firefox, there is no animation and the content on the flip page appears in reverse on the screen.
The issue also occurs on your demo page for the flip effect, we have seen this on multiple devices running the latest version of firefox.
As far as i can see no errors are reported and nothing shows in the console
Neli
Telerik team
answered
on
28 May 2024
