I have a spreadsheet that gets data loaded from a database. I want to add validation to a range of cells, but I never know how many columns or rows until after the data is loaded. So my question is: How do I do this with jquery? The validation is fairly simple. Each character can be a number or a colon : 

 

Thank you in advance

To illustrate the probelm I will use a simple example. I'm using the following code in the OnSelect() event handler:  

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

sheet.range(1,5,1,1).select();

The problem is that it never really highlights the correct cell and the cell it does select varies depeding on whether I use the left, right, up or down scroll key to navigate.  I'm not sure what is going on under the covers, but I'm guessing that the issue has to do with the fact that the selection was changing from one cell to another before the event was called, therefore, there is some soft of clash or confusion between the two select events.

I use the exact same code when I initalize the spreadsheet and it works perfectly. Inside the event handler though, I cannot figure out what it's doing.

 

Also, is there any documentation on the arguments that are passed to event handlers. There is a lot of stuff going in there but I cannot find any good documentation on it? I find that the API documentation does not go very deep, especially with events.

If you have defined an action for OnSelect, is there a way to cancel the navigation from within the function? I think Kendo does this with Validation. If you add Validation to a cell, then enter invalid data and try to navigate to another cell, the navigation is cancelled until you either fix the data or Cancel the input. Is there a way to replicate that behavior in my own code within the OnSelect event. There is no equivalent to blur when you leave a cell so the next best thing would be to do something as you select another.

 

 

Hi,

I have a requirement for a multi-select drop down within each cell of a specific column within a Kendo spreadsheet control.

Is this possible? I can't find any documentation around this. I would be really appreciative if someone could help me with code samples/demos

Thanks

Ian

Hello, I'm using Kendo Jquery to create my SPAs applications, I'm missing using a state controller, because I need some components to communicate and update according to a general action.

For example, instead of adding all listeners to the datasource's change event or the observable object,
I thought about using Redux.

Imagining the following scenario, I have a datasource that will provide a list of all system notifications. When receiving the notification from the server, this datasource will be updated, in the update we will perform specific functions according to the new notification. For example, we can display a message or open an application.

I could register all possible operations in each new notification within the "CHANGE" event of the datasource, however, with each new function to handle a new type of notification, I will have to change the "CHANGE" event of this datasource.

I'm thinking of using redux, this would be responsible for notifying any change of state for the components subscribed to the store, executing the store dispatch on the "change" trigger of the datasource or observable object, thus giving more freedom for the new components to use the event change of state without having to change the "CHANGE" trigger of the datasource.

I would like to know if this would be a good practice and if anyone has used redux with kendo jquery and what are your recommendations?

Thanks

Hi,

I was trying to update my kendo version to the latest available (from 2019 to 2022) and when compiling my scss files I always get an error saying that my CSS is invalid after "...-header-border," which most likely corresponds to the $grid-header-border variable in the grid's theme file.

Invalid CSS after "...-header-border,": expected expression (e.g. 1px, bold), was ");"

I have downloaded the latest version from Node. I added the classic version.

Hello there,

It seems like there is an issue with narrator announcing table head and body cell values. Is it fixed in lated version or does anyone know workaround for this?
Using:
"@progress/kendo-grid-react-wrapper": "^2019.4.1014"

Best regards,
Stevan

Hello,

I am trying to add the css class to the kendo controls based on some validations. I tried as given in the below code but its not applying. Please suggest me how i can achieve this.

var datePicker = $("#SampleDatePicker").data("kendoDatePicker");
datePicker.addClass('error-Border');

Thanks and Regards,
Ravi

I have written my own data validation in a Kendo Spreadsheet that executes when OnChange is fired. From what I can tell, this event happens when I change the contents of the cell then either click on another cell or scroll using the arrow key -- in Html this would have been onBlur. To that end, everything is working well. What I am not able to do though is reset the focus back to the cell that was in error. Within the OnChange function I execute sheet.range(rangeString).select(), but Kendo ignores this and continues moving to the next cell when OnChange is completed. Is there a way to stop this action?

 

Thank you in advance.

Hello, 

I am using the Kendo Upload widget to upload images to a web application. I am having some issues with file sizing even though my maximumfile size is set to 10 MB and the Image is 5.1 MB.

I was unable to find any information on built-in limitations for the uploader on in the Kendo UI jQuery documentation.

Are there any built-in limitations to this widget in terms of file size? If so, what are they?