Spread Silverlight Documentation
BarDirection Enumeration
Example Example 


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.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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.