skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • AI Coding Assistants
    • Embedded Reporting
    • Document Processing Libraries
    • SSO Account Sign-in

    Web

    Kendo UI UI for Angular UI for Vue UI for jQuery KendoReact UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Telerik JustMock

    CMS

    Sitefinity

    AI Productivity Tools

    AI Coding Assistants

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    KendoReact Free VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • What's New
    • Roadmap
    • Release History
  • Support and Learning

    • Support and Learning Hub
    • First Steps
    • Docs
    • Demos
    • Virtual Classroom
    • Forums
    • Videos
    • Blogs
    • Accessibility
    • Submit a Ticket

    Productivity and Design Tools

    • Visual Studio Extensions
    • Visual Studio Templates
    • Embedded Reporting
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Namespace Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings

Classes

AutomaticMaximumValue

Represents a value that is automatically determined depending on its current context.

AutomaticMinimumValue

Represents a value that is automatically determined depending on its current context.

BeginsWithRule

Represents a rule that checks whether a cell text value begins with a specified text value.

BetweenRule

Represents a rule that determines whether a given value is between two other argument values.

BottomRule

Represents a rule that determines a rank of smallest values in a given range.

ColorScaleRule

Represents a range rule that applies different color value to a cell, in accordance to its distance from given Max and Min value.

ColorScaleValueContextBase

Represents a value context for color scale condtional formatting.

ConditionalFormatting

Represents the base class for defining conditional formatting.

ConditionalFormattingDxfRule

Represents the base type for a conditional formatting rule that supports differential formatting.

ConditionalFormattingRange

Represents the list of appled condtional formattings over a certain cell range.

ConditionalFormattingResult

Represents a conditional formatting and its result over a certain range.

ConditionalFormattingRule

Represents the base type for conditional formatting rule.

ContainsBlanksRule

Represents a rule that indicates whether a given value is a blank.

ContainsRule

Represents a rule that indicates whether a given value contains a text argument.

DataBarRule

Represents a range rule that visually applies to the cell in accordance to their distance from Max and Min values.

DataBarValueContext

Represents a value context for a data bar.

DifferentialFormatting

Represents an incremental formatting type that incrementally adds new values to an existing formatting.

DoubleArgumentConditionalFormattingRule

Represents a basic class for rules with two arguments. Support both absolute values and formula values.

DuplicateValuesRule

Represents a rule which determines whether a given vlaue is duplicate in the rule's range.

EndsWithRule

Represents a rule which determines whether a given vlaue ends with a given text argument.

EqualToRule

Represents a rule that determines whether a given value is equal to another argument value.

FiveIconSetValueContext

Represents a rule that distributes values according to five value ranges.

FormulaRule

Represents a rule that determines whether a given value satisfies a given formula.

FormulaValue

Represents a basic class with a predicate formula.

FourIconSetValueContext

Represents a rule that distributes values according to four value ranges.

GreaterThanOrEqualToRule

Represents a rule that indicates whether a value is greater or equal to a given argument.

GreaterThanRule

Represents a rule that indicates whether a value is greater than a given argument.

HasErrorRule

Represents a rule that determines whether a given value contains an error value.

HasNoErrorRule

Represents a rule that determines whether a given value does not contain an error value.

IconDefinition

Represents an icon definition specified by its parent preset and its index in the preset.

IconSetRange

Represents an icon set range, described by a value and a threshold operator.

IconSetRule

Represents a range rule that deparates values into different value classes defined by a set of constraints.

IconSetValueContextBase

Represents a rule that distributes values according to value ranges.

LessThanOrEqualToRule

Represents a rule that indicates whether a value is less than or equal to a given argument.

LessThanRule

Represents a rule that indicates whether a value is less than a given argument.

MaximumValue

Represents the highest value in the applied range.

MinimumValue

Represents the lowest value in the applied range.

NotBetweenRule

Represents a rule that determines whether a given value is not between two other argument values.

NotContainsBlanksRule

Represents a rule that indicates whether a given value is not a blank.

NotContainsRule

Represents a rule that indicates whether a given value does not contain a text argument.

NotEqualToRule

Represents a rule that determines whether a given value is not equal to another argument value.

NumericValue

Represets a simple numeric value.

PercentileValue

Represets a numeric value that takes values up to a certain percentile of the range.

PercentValue

Represets a percentage numeric value.

RangeValueContextBase

Represents a base class for rules that are applied equally on

SingleArgumentComparisonRule

Represents a basic class for rules wtih a single arguments. Support both absolute values and formula values.

SingleArgumentConditionalFormattingRule

Represents a basic class for rules wtih a single argument. Support both absolute values and formula values.

ThreeColorScaleValueContext

Represents a value context for color scale with three fixed colors.

ThreeIconSetValueContext

Represents a rule that distributes values according to three value ranges.

TopRule

Represents a rule that determines a rank of largest values in a given range.

TwoColorScaleValueContext

Represents a value context for color scale with two fixed colors.

UniqueValuesRule

Represents a rule which determines whether a given value is unique in the rule's range.

ValueDistributionRule

Represents a rule that describes value distribution within a range.

Interfaces

IAbsoluteRangeValue

Represents an absolute size value, whoch can be represented by a number.

IRangeValue

Represents a variable the can be assigned to RangeValue rules.

Enums

ConditionalFormattingUnit

Represents a conditional formatting value unit.

DataBarAxisPosition

Represents different setting for axis position.

DataBarDirection

Represents different setting for data bar direction.

IconSetRangeOperator

Represents a set of comparison operators.

OccurrenceTimePeriod

Describes the occurrence time period of a conditional formatting rule.

PresetIconSet

Represets sets of predefined icons.

ValueDistribution

Represents various option for value distribution.

ValueType

Represents the separate option for value types in RangeValue rules.

Getting Started
  • Install Now
  • Demos
  • Step-by-Step Tutorial
  • Sample Applications
  • SDK Samples
  • Visual Studio Extensions
Support Resources
  • Code Library
  • Knowledge Base
  • Videos
Community
  • Forums
  • Blogs
  • Feedback Portal
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.