Validate General Type Cell

Validate General Type Cell

Posted by: sandyaveas on 22 June 2018, 12:12 am EST

• 

  sandyaveas

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 June 2018, 12:12 am EST

  How can I validate General Type Cell,
  
  For eg: I want to validate a cell which in which user can enter only ‘A’ or ‘B’ as value. Any other value should notify with the error message or popup.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 24 June 2018, 11:09 pm EST

  Hello,

  There is no direct way to validate the cell text for this condition. You can write client side code to check types value in onDataChanged event and show the error message after comparing the cell’s text.

  Thanks,
  
  Deepak Sharma

• 

  sandyaveas

  • Post Options:
  • Link
    Copy

  Posted 29 June 2018, 8:57 pm EST

  OK, but how can I find the specific cell, this cell could be in any column. Is there anything like find cell with tagname or something else.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 1 July 2018, 11:39 pm EST

  Hello,

  You can check the active cell by getting the active row index and active column index. You can also search the cell with CellTag. Please refer to the documentation here:
  
  http://help.grapecity.com/spread/SpreadNet11/ASP2/webframe.html#FarPoint.Web.Spread~FarPoint.Web.Spread.SearchFoundFlags.html

  Thanks,
  
  Deepak Sharma