DisplayEmptyCellsAs Property

Visual Basic
C#

'Declaration
 
Public Property DisplayEmptyCellsAs As EmptyValueStyle

'Usage
 
Dim instance As ExcelSparklineSetting
Dim value As EmptyValueStyle
 
instance.DisplayEmptyCellsAs = value
 
value = instance.DisplayEmptyCellsAs

public EmptyValueStyle DisplayEmptyCellsAs {get; set;}

Property Value

The display empty cells as value.

This example creates a sparkline in a cell.

C#

FarPoint.Win.Spread.SheetView sv = new FarPoint.Win.Spread.SheetView();
FarPoint.Win.Spread.Chart.SheetCellRange data = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 0, 0, 2, 2);
FarPoint.Win.Spread.Chart.SheetCellRange data2 = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 5, 0, 2, 1);

FarPoint.Win.Spread.ExcelSparklineSetting ex = new FarPoint.Win.Spread.ExcelSparklineSetting();
ex.AxisColor = Color.SaddleBrown;
ex.ShowMarkers = true;
ex.DisplayEmptyCellsAs = FarPoint.Win.Spread.Chart.EmptyValueStyle.Zero;

fpSpread1.Sheets[0] = sv;
sv.Cells[0, 0].Value = 2;
sv.Cells[0, 1].Value = 5;
sv.Cells[1, 0].Value = 3;
fpSpread1.Sheets[0].AddSparkline(data, data2, FarPoint.Win.Spread.SparklineType.Line, ex);

Visual Basic

Dim sv As New FarPoint.Win.Spread.SheetView
Dim data As New FarPoint.Win.Spread.Chart.SheetCellRange(sv, 0, 0, 2, 2)
Dim data2 As New FarPoint.Win.Spread.Chart.SheetCellRange(sv, 5, 0, 2, 1)

Dim ex As New FarPoint.Win.Spread.ExcelSparklineSetting()
ex.AxisColor = Color.SaddleBrown
ex.ShowMarkers = True
ex.DisplayEmptyCellsAs = FarPoint.Win.Spread.Chart.EmptyValueStyle.Zero

FpSpread1.Sheets(0) = sv
sv.Cells(0, 0).Value = 2
sv.Cells(0, 1).Value = 5
sv.Cells(1, 0).Value = 3
FpSpread1.Sheets(0).AddSparkline(data, data2, FarPoint.Win.Spread.SparklineType.Line, ex)

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

ExcelSparklineSetting Class
ExcelSparklineSetting Members