Syncfusion.XlsIO.Base
Example 


FirstFormula Property (IDataValidation)

Gets or sets the value or expression associated with the data validation. Firstformula must important to validate data in CompareOperator property.
Syntax
'Declaration
 
Property FirstFormula As String
'Usage
 
Dim instance As IDataValidation
Dim value As String
 
instance.FirstFormula = value
 
value = instance.FirstFormula
string FirstFormula {get; set;}
Remarks
This can be a constant value, a string value, a cell reference, or a formula. To know more about FirstFormula property refer this link.
Example
The following code illustrates the use of FirstFormula property.
using Syncfusion.XlsIO;
using System.Drawing;
             
class Example
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
           //Create a worksheet.        
           IApplication application = excelEngine.Excel;
           application.DefaultVersion = ExcelVersion.Excel2013;
           IWorkbook workbook = application.Workbooks.Create(1);
           IWorksheet worksheet = workbook.Worksheets[0];
           worksheet.Range["A2"].CellStyle.Color = Color.LightGray;
           worksheet.Range["C2"].CellStyle.Color = Color.LightGray;
           worksheet.Range["E2"].CellStyle.Color = Color.LightGray;
           worksheet.Range["A1"].Text = "Text Vaidation";
           worksheet.Range["C1"].Text = "Time Vaidation";
           worksheet.Range["E1"].Text = "Number Vaidation";
           worksheet.Range["A1"].AutofitColumns();
           worksheet.Range["C1"].AutofitColumns();
           worksheet.Range["E1"].AutofitColumns();
           
           // Data validation for text length
           IDataValidation dataValidation = worksheet.Range["A2"].DataValidation;
           dataValidation.AllowType = ExcelDataType.TextLength; 
           dataValidation.CompareOperator = ExcelDataValidationComparisonOperator.GreaterOrEqual;
           dataValidation.FirstFormula = "5"; //DataValidation Value for First Formula
            
           // Date Validation for Time 
           IDataValidation dataValidation2 = worksheet.Range["C2"].DataValidation;
           dataValidation2.AllowType = ExcelDataType.Time; 
           dataValidation2.CompareOperator = ExcelDataValidationComparisonOperator.Between;
           dataValidation2.FirstFormula = "10:00"; //DataValidation Value for First Formula
           dataValidation2.SecondFormula = "12:00";
            
           //Data validation for number
           IDataValidation dataValidation3 = worksheet.Range["E2"].DataValidation;
           dataValidation3.AllowType = ExcelDataType.Integer; 
           dataValidation3.CompareOperator = ExcelDataValidationComparisonOperator.NotBetween;
           dataValidation3.FirstFormula = "0"; //DataValidation Value for First Formula
           dataValidation3.SecondFormula = "10";
            
           workbook.SaveAs("DataValidation.xlsx");
           workbook.Close();
           excelEngine.Dispose();
        }
     }
 }
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also