GrapeCity.Xaml.SpreadSheet.Data
ManualMax Property
Example 


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()>
Public Property ManualMax As Double
'Usage
 
Dim instance As SparklineSetting
Dim value As Double
 
instance.ManualMax = value
 
value = instance.ManualMax
[DefaultValue()]
public double ManualMax {get; set;}
Example
This example uses the ManualMax property.
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 3);
GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting();
ex.MaxAxisType = GrapeCity.Xaml.SpreadSheet.Data.SparklineAxisMinMax.Custom;
ex.ManualMax = 12;
ex.MinAxisType = GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column,ex);
Dim cellr As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 3)
Dim ex As New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting()
ex.MaxAxisType = GrapeCity.Xaml.SpreadSheet.Data.SparklineAxisMinMax.Custom
ex.ManualMax = 12
ex.MinAxisType = GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column,ex)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SparklineSetting Class
SparklineSetting Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options