Spread for ASP.NET 8.0 Product Documentation
ManualMin Property
Example 


Gets or sets a value that specifies the minimum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if minAxisType does not equal custom.
Syntax
'Declaration
 
Public Property ManualMin As Double
'Usage
 
Dim instance As ExcelSparklineSetting
Dim value As Double
 
instance.ManualMin = value
 
value = instance.ManualMin
public double ManualMin {get; set;}
Example
This example creates a sparkline in a cell.
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);
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)
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

Reference

ExcelSparklineSetting Class
ExcelSparklineSetting Members

 

 


Copyright © GrapeCity, inc. All rights reserved.