Spread for ASP.NET 7.0 Product Documentation
SparklineAxisMinMax Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : SparklineAxisMinMax Enumeration


Glossary Item Box

An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.

Syntax

Visual Basic (Declaration) 
Public Enum SparklineAxisMinMax 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As SparklineAxisMinMax
C# 
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.
C#Copy Code
FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
ex.MaxAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom;
ex.ManualMax = 12;
ex.MinAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom;
ex.ManualMin = 0;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 11;
fpSpread1.Sheets[0].Cells[1, 2].Value = 4;
fpSpread1.Sheets[0].AddSparkline("Sheet1!$A$2:$C$2", "Sheet1!$D$2:$D$2", FarPoint.Web.Spread.SparklineType.Column, ex);
VB.NETCopy Code
Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
ex.MaxAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom
ex.ManualMax = 12
ex.MinAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom
ex.ManualMin = 0
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 11
FpSpread1.Sheets(0).Cells(1, 2).Value = 4
FpSpread1.Sheets(0).AddSparkline("Sheet1!$A$2:$C$2", "Sheet1!$D$2:$D$2", FarPoint.Web.Spread.SparklineType.Column, ex)

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.SparklineAxisMinMax

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.