GrapeCity.Xaml.SpreadSheet.Data
MaxAxisType Property (SparklineSetting)
Example 


Gets or sets a value that specifies how the vertical axis maximum is calculated for the sparklines in this sparkline group.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property MaxAxisType As SparklineAxisMinMax
'Usage
 
Dim instance As SparklineSetting
Dim value As SparklineAxisMinMax
 
instance.MaxAxisType = value
 
value = instance.MaxAxisType
[DefaultValue()]
public SparklineAxisMinMax MaxAxisType {get; set;}
Example
This example uses the MaxAxisType 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