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


In This Topic
    DataBarAxisPosition Enumeration
    In This Topic
    Specifies the position of the axis.
    Syntax
    'Declaration
 
Public Enum DataBarAxisPosition 
   Inherits System.Enum
    'Usage
 
Dim instance As DataBarAxisPosition
    public enum DataBarAxisPosition : System.Enum
    Members
    MemberDescription
    AutomaticIndicates whether to display at a variable position based on negative values.
    CellMidPointIndicates whether to display at the cell midpoint.
    NoneIndicates whether to display value bars in the same direction as positive values.
    Example
    This example sets the DataBarAxisPosition 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.DataBarAxisPosition

    See Also

    Reference

    GrapeCity.Windows.SpreadSheet.Data Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page