Syncfusion.XlsIO.Base
Example 


MaxPoint Property

Gets a IConditionValue object which specifies how the longest bar is evaluated for a data bar conditional format.
Syntax
'Declaration
 
ReadOnly Property MaxPoint As IConditionValue
'Usage
 
Dim instance As IDataBar
Dim value As IConditionValue
 
value = instance.MaxPoint
IConditionValue MaxPoint {get;}
Remarks
To customize the longest bar of DataBar we have to set values for MaxPoint property.
Example
The longest bar of DataBar is set by defining the MaxPoint property. To do that we have to set values for IConditionValue.Value, Type and IConditionValue.Operator Properties. Here for example, we set "70" to IConditionValue.Value property which sets the longest 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 MaxPoint for DataBar
            dataBar.MaxPoint.Value = "70";
            dataBar.MaxPoint.Type = ConditionValueType.Percent;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also