Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

Returns the Condition's Condition.Comparison value, which determines whether each cell value will be compared with one or two other values, or if a formula will be evaluated for each cell.

{signature}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          ConditionalFormat condFmt = wb.CreateConditionalFormat();
          Condition cond =
               condFmt.CreateCondition(
               Condition.Comparison.CellValueGreaterThan,
               "=100");
          Condition.Comparison compType = cond.ComparisonType;
        
{code}
{code:vb.net
|title=vb.net
}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim condFmt As ConditionalFormat = wb.CreateConditionalFormat()
          Dim cond As Condition = _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueGreaterThan, _
               "=100")
          Dim compType As Condition.Comparison = cond.ComparisonType
        {code}

{example}
Signature
C#C#
Wiki Markup
{description}
{excerpt}Returns the [Condition|Condition]'s [Condition.Comparison|Condition.Comparison] value, which determines whether each cell value will be compared with one or two other values, or if a formula will be evaluated for each cell.{excerpt}
{signature:C#}
 public Comparison ComparisonType{ get; }
Signature
{signature}{signature:vb.net
vb.net
}
Public ReadOnly Property ComparisonType() As Comparison
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle