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


In This Topic
    SparklineAxisMinMax Enumeration
    In This Topic
    An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
    Syntax
    'Declaration
     
    Public Enum SparklineAxisMinMax 
       Inherits System.Enum
    'Usage
     
    Dim instance As SparklineAxisMinMax
    public enum SparklineAxisMinMax : System.Enum 
    Members
    MemberDescription
    CustomSpecifies that the vertical axis minimum or maximum for each sparkline in this sparkline group is specified by the manualMin attribute or the manualMax attribute of the sparkline group.
    GroupSpecifies that the vertical axis minimum or maximum is shared across all sparklines in this sparkline group and is calculated automatically such that the data point with the minimum or maximum value can be displayed in the plot area.
    IndividualSpecifies that the vertical axis minimum or maximum for each sparkline in this sparkline group is calculated automatically such that the data point with the minimum or maximum value can be displayed in the plot area.
    Example
    This example uses the SparklineAxisMinMax enumeration.
    GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 3);
    GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
    ex.MaxAxisType = GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax.Custom;
    ex.ManualMax = 12;
    ex.MinAxisType = GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax.Custom;
    ex.ManualMin = 0;
    gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 5;
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 17;
    gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = 4;
    gcSpreadSheet1.Sheets[0].SetSparkline(1, 3, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column,ex);
    gcSpreadSheet1.Invalidate();
    Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 3)
    Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
    ex.MaxAxisType = GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax.Custom
    ex.ManualMax = 12
    ex.MinAxisType = GrapeCity.Windows.SpreadSheet.Data.SparklineAxisMinMax.Custom
    ex.ManualMin = 0
    GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 5
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 17
    GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = 4
    GcSpreadSheet1.Sheets(0).SetSparkline(1, 3, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column,ex)
    GcSpreadSheet1.Invalidate()
    Inheritance Hierarchy

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

    See Also