DataBarRule
Renders horizontal data bars within cells based on their numeric values relative to the range minimum and maximum, with customizable colors, gradients, and axis positioning.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class DataBarRule : ConditionalFormattingRuleInheritance: objectConditionalFormattingRuleDataBarRule
Inherited Members
Constructors
Initializes a new DataBarRule with the specified data bar value context defining the range bounds.
Properties
Gets or sets the color of the vertical axis line that separates positive and negative data bars, defaulting to black.
public ThemableColor AxisColor { get; set; }Gets or sets the axis position for the data bar, controlling whether bars grow from the cell edge, midpoint, or auto-calculated position.
public DataBarAxisPosition AxisPosition { get; set; }Gets or sets the border color for positive-value data bars when borders are enabled.
public ThemableColor BorderColor { get; set; }Gets or sets the direction in which data bars grow within the cell, such as left-to-right or right-to-left.
public DataBarDirection Direction { get; set; }Gets or sets the fill color for positive-value data bars, supporting theme-based or explicit colors.
public ThemableColor FillColor { get; set; }Gets or sets the maximum length of the data bar as a percentage of the cell width, capping the bar for the largest values.
public double MaxLength { get; set; }The maximum length represented as a percentage of the cell length.
Gets or sets the minimum length of the data bar as a percentage of the cell width, ensuring bars remain visible even for the smallest values.
public double MinLength { get; set; }The minimum length represented as a percentage of the cell length.
Gets or sets the border color for negative-value data bars when borders are enabled.
public ThemableColor NegativeBorderColor { get; set; }Gets or sets the fill color for negative-value data bars, allowing distinct styling for values below zero.
public ThemableColor NegativeFillColor { get; set; }Gets or sets whether only the data bars are visible, hiding the underlying numeric cell values.
public bool ShowBarsOnly { get; set; }Gets or sets whether data bars display a border, using the configured border colors.
public bool ShowBorder { get; set; }Gets or sets whether data bars use gradient fill from the fill color to white, creating a shaded appearance.
public bool UseGradientFill { get; set; }Gets the data bar value context that defines the minimum and maximum values for calculating bar lengths.
public DataBarValueContext ValueContext { get; }