Syncfusion.XlsIO.Base
Example 


ClearFormats Method (IChartErrorBars)

Clears the formats of the error bars.
Syntax
'Declaration
 
Sub ClearFormats() 
'Usage
 
Dim instance As IChartErrorBars
 
instance.ClearFormats()
void ClearFormats()
Example
The following code illustrates how to clear the formats of IChartErrorBars
using Syncfusion.XlsIO;
using System;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "25";
            sheet.Range["C3"].Value = "35";
            sheet.Range["D2"].Value = "4";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered;
            
            //Get chart serie
            IChartSerie serie = chart.Series[0];
            
            //Enabling the Y Error bars
            serie.HasErrorBarsY = true;
            
            //Get Y Error Bars 
            IChartErrorBars errorBars = serie.ErrorBarsY;
            
            //Set Error bars border color
            errorBars.Border.ColorIndex = ExcelKnownColors.Red;
            
            //Set error amount to custom
            errorBars.Type = ExcelErrorBarType.Custom;
            
            //Set minus range
            errorBars.MinusRange = sheet["D2"];
            
            //Check error bar contains formats
            Console.WriteLine("Is default line color applied in Error bars:" + errorBars.Border.IsAutoLineColor);
            Console.WriteLine("Error bar type:" + errorBars.Type);
            
            //Clear the Error bar formats
            errorBars.ClearFormats();
            
            //Check error bar contains formats
            Console.WriteLine("Is default line color applied in Error bars:"+ errorBars.Border.IsAutoLineColor);
            Console.WriteLine("Error bar type:"+ errorBars.Type);
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
            Console.ReadKey();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also