Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadChart Class / DisplayHidden Property
Example


In This Topic
    DisplayHidden Property (SpreadChart)
    In This Topic
    Gets or sets a value that indicates whether data in hidden cells is plotted.
    Syntax
    'Declaration
     
    Public Property DisplayHidden As Boolean
    'Usage
     
    Dim instance As SpreadChart
    Dim value As Boolean
     
    instance.DisplayHidden = value
     
    value = instance.DisplayHidden
    public bool DisplayHidden {get; set;}

    Property Value

    true to plot the ; otherwise, false.
    Example
    This example sets the DisplayHidden 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