Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / BarDirection Enumeration
Example Example


In This Topic
    BarDirection Enumeration
    In This Topic
    Specifies the direction of the data bar.
    Syntax
    'Declaration
 
Public Enum BarDirection 
   Inherits System.Enum
    'Usage
 
Dim instance As BarDirection
    public enum BarDirection : System.Enum
    Members
    MemberDescription
    LeftToRightIndicates whether to display the bar from left to right.
    RightToLeftIndicates whether to display the bar from right to left.
    Example
    This example sets the BarDirection enumeration. 
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = 3; 

GrapeCity.Windows.SpreadSheet.Data.DataBarRule test = new GrapeCity.Windows.SpreadSheet.Data.DataBarRule();
test.AxisColor = Color.FromArgb(101, 50, 50, 200);
test.AxisPosition = GrapeCity.Windows.SpreadSheet.Data.DataBarAxisPosition.CellMidPoint;
test.BorderColor = Color.FromArgb(150, 10, 100, 99);
test.ShowBorder = true;
test.DataBarDirection = GrapeCity.Windows.SpreadSheet.Data.BarDirection.RightToLeft;
test.MaximumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.HighestValue;
test.MinimumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.LowestValue;
test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);    
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = 3

Dim test As New GrapeCity.Windows.SpreadSheet.Data.DataBarRule()
test.AxisColor = Color.FromArgb(101, 50, 50, 200)
test.AxisPosition = GrapeCity.Windows.SpreadSheet.Data.DataBarAxisPosition.CellMidPoint
test.BorderColor = Color.FromArgb(150, 10, 100, 99)
test.ShowBorder = True
test.DataBarDirection = GrapeCity.Windows.SpreadSheet.Data.BarDirection.RightToLeft
test.MaximumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.HighestValue
test.MinimumType = GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.LowestValue
test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Windows.SpreadSheet.Data.BarDirection

    See Also

    Reference

    GrapeCity.Windows.SpreadSheet.Data Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page