This is a migrated thread and some comments may be shown as answers.

Restricting inputs in cells

4 Answers 56 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marcus
Top achievements
Rank 1
Marcus asked on 01 Dec 2014, 02:41 PM
Dear support,

is there a way to validate the users input? For example I only want to accept inputs of CellValueType.Number. Is it possible?

Thanks in advance

Marcus

4 Answers, 1 is accepted

Sort by
0
Tanya
Telerik team
answered on 02 Dec 2014, 08:41 AM
Hello Marcus,

I am afraid that this feature is still not supported, but we are working on it. You can track its status on our public portal: Data Validation.

Please do not hesitate to contact us if you have any other questions.

Regards,
Tanya
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Marcus
Top achievements
Rank 1
answered on 02 Dec 2014, 10:58 AM
Hi Tanya,

is there another way to achieve this? Like using an cell-exit-event for the check of the cell-content?

Regards
Marcus
0
Tanya
Telerik team
answered on 02 Dec 2014, 04:35 PM
Hi Marcus,

You can subscribe to selections' ActiveCellModeChanged event. Please find attached a sample project demonstrating how this can be achieved. The sample validates if the input is number between 1 and 1000 when the cell mode is changed to Display.

Hope this helps.

Regards,
Tanya
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Marcus
Top achievements
Rank 1
answered on 03 Dec 2014, 12:50 PM
Hi Tanya,

thank you very much. I will use it.

Regards
Marcus
Tags
Spreadsheet
Asked by
Marcus
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Marcus
Top achievements
Rank 1
Share this question
or