Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IDataBar Interface : NegativeBorderColor Property

NegativeBorderColor Property

Gets or sets the negative border color of the data bar.
Syntax
'Declaration
 
Property NegativeBorderColor As Color
'Usage
 
Dim instance As IDataBar
Dim value As Color
 
instance.NegativeBorderColor = value
 
value = instance.NegativeBorderColor
Color NegativeBorderColor {get; set;}
Remarks
To change fill color and border color of DataBars use BarColor and BorderColor properties.
Example
There will be no borders applied to ColorBars initially. Like BorderColor property used to set border color for positive values in the cells NegativeBorderColor property is used to set border color for negative values in the cells. Here in our example, we set NegativeBorderColor to Yellow.
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];
            
            //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 NegativeBorder color for DataBar
            dataBar.NegativeBorderColor = Color.Yellow;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also