Syncfusion.XlsIO Namespace > IDataBar Interface : HasGradientFill Property

HasGradientFill Property

Gets or sets a Boolean value indicating whether the data bar has a gradient fill.
Property HasGradientFill As Boolean
Dim instance As IDataBar
Dim value As Boolean
instance.HasGradientFill = value
value = instance.HasGradientFill
bool HasGradientFill {get; set;}
To know more about conditional formatting type refer this link.
HasGradientFill is set to "True" by default to provide a rich formatting look to DataBars. To make the DataBars look with plain unformatted color just like the color fill of cells, we can set this property to "False".
using Syncfusion.XlsIO;
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["A1"].Text = "DataBar";
            worksheet["A2"].Number = 10;
            worksheet["A3"].Number = 20;
            worksheet["A4"].Number = 30;
            worksheet["A5"].Number = 40;
            worksheet["A6"].Number = 50;
            worksheet["A7"].Number = 60;
            worksheet["A8"].Number = 70;
            worksheet["A9"].Number = 80;
            worksheet["A10"].Number = 90;
            worksheet["A11"].Number = 100;
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["A2:A11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            //Set FormatType as DataBar.
            format.FormatType = ExcelCFType.DataBar;
            IDataBar dataBar = format.DataBar;
            //Set Gradient fill to false.
            dataBar.HasGradientFill = false;
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also