Is it possible to set cells in the radspreadsheet as invalid?
Or to mock this anyway, by setting the cell styles (for e.g. red background or red border)?
And if the latter to lock the style of the cell only so that user cannot change it?
In order to help you achieve this behaviour we have created a demo project, which I hope will cover most of your needs. I am attaching this project so that you can download it.
Let me describe the demo with a few words.
The project uses class called DataValidator. An instance of this class listens to CellsPropertyChanged event.
When some cells property is changed DataValidator checks whether the cell should be validated (based on the changed property name) and sets either Green or Redbackground depending on whether the cells content is valid or not.
At the MainPage an instance of the DataValidator is used to validate the RadSpreadsheet control.
I hope this information is helpful! If you have any other questions or concerns please do not hesitate to contact us again.
the Telerik team
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.