Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadChart Class / DisplayEmptyCellsAs Property
Example


In This Topic
    DisplayEmptyCellsAs Property (SpreadChart)
    In This Topic
    Gets or sets what to display the empty cells as.
    Syntax
    'Declaration
     
    Public Property DisplayEmptyCellsAs As EmptyValueStyle
    'Usage
     
    Dim instance As SpreadChart
    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 sets the DisplayEmptyCellsAs property.
    gcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } });            
    GrapeCity.Windows.SpreadSheet.Data.SpreadChart schart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("test", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.BarStacked, 100, 100, 200, 200);
    schart.Formula = "Sheet1!$A$1:$A$7";
    schart.DisplayEmptyCellsAs = GrapeCity.Windows.SpreadSheet.Data.EmptyValueStyle.Zero;
    schart.DisplayHidden = true;
    gcSpreadSheet1.Sheets[0].Charts.Add(schart);
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}})
    Dim schart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("test", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.BarStacked, 100, 100, 200, 200)
    schart.Formula = "Sheet1!$A$1:$A$7"
    schart.DisplayEmptyCellsAs = GrapeCity.Windows.SpreadSheet.Data.EmptyValueStyle.Zero
    schart.DisplayHidden = True
    GcSpreadSheet1.ActiveSheet.Charts.Add(schart)
    See Also