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:vb.net} Public ReadOnly Property ComparisonType() As Comparison {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} |
Page History
Overview
Content Tools