Spread WPF 14
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