Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ExcelSparklineSetting Class / DisplayEmptyCellsAs Property
Example


In This Topic
    DisplayEmptyCellsAs Property
    In This Topic
    Gets or sets what to display empty cells as.
    Syntax
    '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.
    Example
    This example creates a sparkline in a cell.
    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);
    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)
    See Also