Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IConditionalFormat Interface : IsPatternFormatPresent Property

IsPatternFormatPresent Property

True if the conditional format contains pattern formatting. otherwise, False.
Syntax
'Declaration
 
Property IsPatternFormatPresent As Boolean
'Usage
 
Dim instance As IConditionalFormat
Dim value As Boolean
 
instance.IsPatternFormatPresent = value
 
value = instance.IsPatternFormatPresent
bool IsPatternFormatPresent {get; set;}
Example
To check whether the cell's FillPattern is set or not, We can use the IsPatternFormatPresent property. Here for example, We check before and after applying ExcelPattern.DarkHorizontal to FillPattern.
using Syncfusion.XlsIO;
using System;
            
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];
            
            //Load data to Apply Conditional Formatting.
            worksheet["B1"].Text = "Conditional Formats";
            worksheet["B2"].Number = 10;
            worksheet["B3"].Number = 20;
            worksheet["B4"].Number = 30;
            worksheet["B5"].Number = 40;
            worksheet["B6"].Number = 50;
            worksheet["B7"].Number = 60;
            worksheet["B8"].Number = 70;
            worksheet["B9"].Number = 80;
            worksheet["B10"].Number = 90;
            worksheet["B11"].Number = 100;
            
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["B2:B11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            
            //Set Condition.
            format.FirstFormula = "60";
            format.SecondFormula = "20";
            format.Operator = ExcelComparisonOperator.Between;
            
            //Check whether pattern format is present.
            Console.WriteLine(format.IsPatternFormatPresent);
            
            //Set Pattern.
            format.FillPattern = ExcelPattern.DarkHorizontal;
            
            //Check whether pattern format is present.
            Console.WriteLine(format.IsPatternFormatPresent);
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
//Output will be
//False
//True
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also