How to use Data Validation in cells in spread

How to use Data Validation in cells in spread

Posted by: amulya.verma on 29 September 2021, 6:38 am EST

• 

  amulya.verma

  • Post Options:
  • Link
    Copy

  Posted 29 September 2021, 6:38 am EST

  How to achieve the result shown in attached image programmatically using spread in C#

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 1 October 2021, 5:54 am EST

  Hi,

  You can use a RangeValidator with MessageBoxNotify to achieve this behavior.
  
  Please refer to the sample attached.
  
  You can also refer to the documentation at the following link for information on different validator and validation actions.

  Validations: https://www.grapecity.com/spreadnet/docs/v14/online-win/spwin-cellvalidation.html

  Regards
  
  Avnish

  SpreadValidation.zip

• 

  amulya.verma

  • Post Options:
  • Link
    Copy

  Posted 5 October 2021, 12:27 am EST

  Hi i am unable to run your code “SpreadValidation.zip” , it is giving below error. see attached image.

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 5 October 2021, 5:23 am EST

  Hi,

  We tried executing the sample with Spread 13 and it worked fine. We have reattached the sample with Spread 13, Please try it at your end and let us know if you have any issues.

  Regards
  
  Avnish

  SpreadValidation_SP13.zip