Hi, 

I'm try disabled fiels in the dynamically grid, find a exaple in kendo demo but i can't goal.

This is exaple:

This is my code, in the generateColumns method i want to do that:

Hello,

I'm having slow performance in spreadsheet validation. 

    var sheets = $("#spreadsheet").data("kendoSpreadsheet").sheets();

      var colPromiseDate = sheets .activeSheet().range("C2:C" + sheets.activeSheet()._rows._count);
                            colPromiseDate.format("MM/dd/yyyy");
                            colPromiseDate.validation({
                                dataType: "date",
                                showButton: true,
                                allowNulls: true,
                                type: "reject",
                                comparerType: "between",
                                from: "01/01/2000",
                                to: "01/01/2099",
                                titleTemplate: "Date validaton error",
                                messageTemplate: "Invalid Date"
                            });

I had debug the script, only this part will affect the performance of the page. 

My spreadsheet have 200 rows which get from kendo grid data source, so I can't do it in sheets.rows.cell validation. 

FYI, I have tried to use for loop to put in validation on each cell, but the result is still the same. 

Please advice.. 

Thanks. 

Regards,

Su Pei

I have a line chart which can be configured to show data from the last month, last 3 months, ... , last 2 years, last 10 years, etc.
In my SQL query I filter the data to return only the last X months and provide this data to the Kendo chart.
I am using ChartAxisBaseUnit.Fit so I can return data over weeks, months, years and the date axis is adjusted accordingly.

It is now March 16th, if I return 6 months of data the chart will show Months (September to March) on the data axis.
The problem is that we are only half way through March so the line drops off as we do not have all the data for that month yet.
What I could do is filter the data in SQL to only return complete months... i.e. filter the data from 1st September to 1st March.

However, if I return data over a longer period of time the chart will automatically show Years on the date axis.
In this case I don't want to show 2017 at all so I want to ignore any data from Jan and Feb 2017 causes.

Hopefully you get the problem... if date axis is showing years, months, weeks then I only want to show data for the last complete year, month, week.
I have seen there is a MaxDateGroups property that can be set to control the number of items shown but that does not really help.
Eventually I want the user to be able to select a custom date range and show a line chart with automatically scaled date axis.
However, I don't want the line chart to suddenly drop down at the end because we are on the first day of the month, etc.

I am hoping I am just missing something simple here and there is some property which I can set?
If not how have other people got around this problem? I would expect this is a common issue.

Hi,

Sometimes the filter button does not highlight that a filter is active. You can see from the screenshot that some rows are filtered. (Missing row numbers indicate this). The filter column is H, however the filter button has not changed colour.

I have tested with column B and the filter column changes for this column.

Thanks

Marc

Could you please check the below and let me know your suggestion

How to load Tree view with nested nodes (n-level) and context menu (Add/Edit/Delete) for CRUD operation of all nodes

Thanks,

Prabhakar.P

Hi,

I have used Kendo spreadsheet, wants to know how to change the background color of a cell dynamically. I know there is a way like sheet. range ("A1"). background ("#ffffff"). I need an alternate way to do that because columns and its properties changing regularly, also an index of the columns are changing. So it's very hard to follow this, it would be helpful to get alternate way.

Thanks.

Hi,

I came across a problem where I tried putting a kendo editor inside a kendo tabstrip

using Kendo UI and Angular ( 1.x ).

Unfortunately by doing so, the Kendo Editor seems to be not editable.

Could you please advise how to get this running?

Here's a dojo for reference: Link

Thanks in advance

Hi, 

I have a DataSource, let say it looks like this: [{ id: 1, name: 'Grant' }, { id: 2, name: 'Vaughan' }, { id: 3, name: 'David' }].

I also have an object { id: 2, name: 'Devina' }.

How would I go about updating the relevant data item in the datasource with the new object?

Thanks,
Grant

It seems by default connections are drawn over shapes, and I couldn't find a way to change this. Is there a way to make it so connections are drawn behind shapes? In general, is there a way to control the z-level of shapes and connections? 

Thanks.