MinPoint Property

Gets a IConditionValue object which specifies how the shortest bar is evaluated for a data bar conditional format.
ReadOnly Property MinPoint As IConditionValue
Dim instance As IDataBar
Dim value As IConditionValue
value = instance.MinPoint
IConditionValue MinPoint {get;}
To customize the longest bar of DataBar we have to set values for MaxPoint property.
The shortest bar of DataBar is set by defining the MinPoint property. To do that we have to set values for IConditionValue.Value, Type and IConditionValue.Operator Properties. Here for example, we set "30" to IConditionValue.Value property which sets the shortest bar.
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 MinPoint for DataBar
            dataBar.MinPoint.Value = "30";
            dataBar.MinPoint.Type = ConditionValueType.Percent;
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also