Spread WinRT Documentation
GrapeCity.Xaml.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 uses 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.Xaml.SpreadSheet.Data.DataBarRule test = new GrapeCity.Xaml.SpreadSheet.Data.DataBarRule();
test.AxisColor = Windows.UI.Colors.Aquamarine;
test.AxisPosition = GrapeCity.Xaml.SpreadSheet.Data.DataBarAxisPosition.CellMidPoint;
test.BorderColor = Windows.UI.Colors.Chocolate;
test.ShowBorder = true;
test.DataBarDirection = GrapeCity.Xaml.SpreadSheet.Data.BarDirection.RightToLeft;
test.MaximumType = GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.HighestValue;
test.MinimumType = GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.LowestValue;
test.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.DataBarRule()
test.AxisColor = Windows.UI.Colors.Aquamarine
test.AxisPosition = GrapeCity.Xaml.SpreadSheet.Data.DataBarAxisPosition.CellMidPoint
test.BorderColor = Windows.UI.Colors.Chocolate
test.ShowBorder = True
test.DataBarDirection = GrapeCity.Xaml.SpreadSheet.Data.BarDirection.RightToLeft
test.MaximumType = GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.HighestValue
test.MinimumType = GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.LowestValue
    Inheritance Hierarchy

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

    See Also

    Reference

    GrapeCity.Xaml.SpreadSheet.Data Namespace

     

     

    Copyright © 2019 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page