EMail Validation for particular Column

Posted by: narayanan on 8 September 2017, 3:07 pm EST

  • Posted 8 September 2017, 3:07 pm EST

    Hi All,

      I am using Far point Version 4.0 .User wants to insert the EMail id the Spread sheet. 

  • Replied 8 September 2017, 3:07 pm EST

    Hello,

    You can use RegularExpressionCellType for that matter as given below:-

                FarPoint.Win.Spread.CellType.RegularExpressionCellType regexcell = new FarPoint.Win.Spread.CellType.RegularExpressionCellType();
                regexcell.RegularExpression = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z][a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";
                fpSpread1.ActiveSheet.Columns[0].CellType = regexcell;

    Hope it helps.

    Thanks,

    Reeva

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels