I am running into an issue where the Excel Export from my grid seems to be randomly missing rows. As an example, I can see in Firebug that my REST service is returning 1,735 rows of data. But when I export to Excel, the exported file and the excelExport event only shows 1,728 rows. And that includes the Excel headings, so I should be seeing 1,736. Other examples may be off by 1 or 2 rows. And some are working exactly right. Any thoughts on how to resolve this are appreciated.
I am using serverPaging and Kendo UI 2016.1.125.
excelExport Event
excelExport : function(e) {
// debug
var sheet = e.workbook.sheets[0];
alert(sheet.rows.length);
}
dataSource
var
ds =
new
kendo.data.DataSource({
type:
"json"
,
pageSize:100,
transport: {
read:
"../myurl"
},
serverPaging:
true
,
schema: {
model: {
id:
"rn"
,
fields: {
rn: { type:
"number"
},
invno: { type:
"string"
, editable:
false
},
....
}
// end fields
},
// end model
data:
"invoices"
,
total:
"total"
//have to have this with serverPaging set to true
},
error:
function
(e) {
console.log(
"error ---> Status: "
+ e.status);
}
});
// end datasource
Data Returned from REST Service
{
"total"
: 1735,
"invoices"
:
[
{
"rn"
: 1,
"invno"
:
"12345"
,
...
},
....
{
"rn"
: 1735,
"invno"
:
"67890"
,
...
}
]
}
How to set multiple date in the calendar with mvvm.
I have my calendar :
<
div
id
=
"calendar1"
data-role
=
"calendar"
data-bind="value: Cvalue,
dates: Csource,
events:{change: ConChange}">
</
div
>
JS, view model:
Cvalue:null,
Csource:[],
Conchange:function(){
}
Csource contains:
[
{"nome":"1"},{"data":"21/112017"},
{"nome":"2"},{"data":"22/112017"},
{"nome":"3"},{"data":"26/112017"},
{"nome":"4"},{"data":"28/112017"},
{"nome":"5"},{"data":"29/112017"}
]
Cain i see this dates with different color in the calendar?
and at onChange of day, i'd like to print the name of date;
What I assumed would be fairly straightforward has vexed me for several days now -
I'm trying to pass the Expression Preview string along with some additional custom security vars when the filter is loaded and obviously when re-applied.
I've tried filter.getOptions, sender._previewContainer, I even tried $( '.k-filter-preview' ).text() but I am running into issues of inconsistency regarding timing of availability.
My JS/jQuery is mediocre as its really only been my secondary, or even tertiary, approach of choice, until very recently so feel free to add ...dummy to an suggested resource. :)
Thanks.
Hello.
I'm developing with Kendo Grid and I have a question about styling cell of every row.
I've already read some articles to style every cell in databound event.
Can I add styling rule in JSON Data Passed to Kendo Grid?
In my case I have a datatable(vb.net) that I convert to json before pass to kengo grid.
My datatable has 3 column and 50 rows.
1° col: Name / 2° col: Surname / 3° col: Style.
Every row can have a different "Style" content. "Style" is the style that I need to apply to 1° and 2° column.
Example:
PAUL BEAN color:red;
STEVE JOBS text-align:center;
SAM SMITH background-color: green;
{"data":[{"Name": "Paul", "Surname":"Bean","Style":"color:red"}, {"Name": "Steve", "Surname":"Jobs","Style":"text-align:center"}, {"Name": "Sam", "Surname":"Smith","Style":"background-color: green;"}]}
Can you explain If is possibile styling on json "data"?
I've already use databound event and I Iterate every rows but it is very slow.
Are there any alternatives?
thanks!
Hello,
I'm working on an app that needs to display Kendo Recurrence Editor as read-only mode. Is the component have read-only option?
Example on the attached image.
Thanks,
When the spreadsheet loads, the width loads perfectly well and it automatically adjusts to browser resizing. Awesome sauce.
Is there a way to coax the height of the widget to do the same? Something like a height:100% so it happily resizes.
The default height of the spreadsheet leaves lots of space.