menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class ConditionValueWrapper - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Class ConditionValueWrapper

    This object wraps IConditionValue object to ensure correct parent object update.

    Inheritance
    System.Object
    ConditionValueWrapper
    Implements
    IConditionValue
    Namespace: Syncfusion.XlsIO.Implementation
    Assembly: Syncfusion.XlsIO.UWP.dll
    Syntax
    public class ConditionValueWrapper : Object, IConditionValue

    Constructors

    ConditionValueWrapper(IConditionValue, IOptimizedUpdate)

    Initializes new instance of wrapper.

    Declaration
    public ConditionValueWrapper(IConditionValue value, IOptimizedUpdate parent)
    Parameters
    Type Name Description
    IConditionValue value

    Object to wrap.

    IOptimizedUpdate parent

    Parent object.

    Properties

    Operator

    Gets or sets the operator which specifes operator for the threshold values in the conditional format.

    Declaration
    public ConditionalFormatOperator Operator { get; set; }
    Property Value
    Type
    ConditionalFormatOperator
    Examples
    ExcelEngine excelEngine = new ExcelEngine();
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;
    IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
    IWorksheet worksheet = workbook.Worksheets[0];
    IConditionalFormats conditionalFormats = worksheet.Range["C7:C46"].ConditionalFormats;
    IConditionalFormat conditionalFormat = conditionalFormats.AddCondition();
    conditionalFormat.FormatType = ExcelCFType.DataBar;
    IDataBar dataBar = conditionalFormat.DataBar;
    dataBar.MinPoint.Operator = ConditionalFormatOperator.GreaterThanorEqualTo;

    Type

    Gets or sets the condition value type which specifies how the threshold values for a data bar, color scale, or icon set conditional format are determined. Read-only.

    Declaration
    public ConditionValueType Type { get; set; }
    Property Value
    Type
    ConditionValueType
    Examples
    ExcelEngine excelEngine = new ExcelEngine();
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;
    IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
    IWorksheet worksheet = workbook.Worksheets[0];
    IConditionalFormats conditionalFormats = worksheet.Range["C7:C46"].ConditionalFormats;
    IConditionalFormat conditionalFormat = conditionalFormats.AddCondition();
    conditionalFormat.FormatType = ExcelCFType.DataBar;
    IDataBar dataBar = conditionalFormat.DataBar;
    dataBar.MinPoint.Type = ConditionValueType.LowestValue;

    Value

    Gets or sets the shortest bar or longest bar threshold value for a data bar conditional format.

    Declaration
    public string Value { get; set; }
    Property Value
    Type
    System.String
    Examples
    ExcelEngine excelEngine = new ExcelEngine();
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;
    IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
    IWorksheet worksheet = workbook.Worksheets[0];
    IConditionalFormats conditionalFormats = worksheet.Range["C7:C46"].ConditionalFormats;
    IConditionalFormat conditionalFormat = conditionalFormats.AddCondition();
    conditionalFormat.FormatType = ExcelCFType.DataBar;
    IDataBar dataBar = conditionalFormat.DataBar;
    dataBar.MinPoint.Value = "0";

    Methods

    BeginUpdate()

    Initiates updates to the object.

    Declaration
    public void BeginUpdate()
    Remarks

    This method should be called before several updates to the object will take place.

    EndUpdate()

    Ends updating the object.

    Declaration
    public void EndUpdate()
    Remarks

    This method should be called after several updates to the object took place.

    Implements

    IConditionValue

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved