Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / SparklineSetting Class / ManualMax Property
Example


In This Topic
    ManualMax Property
    In This Topic
    Gets or sets a value that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The axis is zero if maxAxisType does not equal custom.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(0)>
    Public Property ManualMax As Double
    'Usage
     
    Dim instance As SparklineSetting
    Dim value As Double
     
    instance.ManualMax = value
     
    value = instance.ManualMax
    [DefaultValue(0)]
    public double ManualMax {get; set;}
    Example
    This example uses the ManualMax property.
    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()
    See Also