GrapeCity.Xaml.SpreadSheet.Data
DisplayHidden Property (SpreadChart)
Example 


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.Xaml.SpreadSheet.Data.SpreadChart schart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("test", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, 100, 100, 200, 200);
schart.Formula = "Sheet1!$A$1:$A$7";
schart.DisplayEmptyCellsAs = GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.SpreadChart("test", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, 100, 100, 200, 200)
schart.Formula = "Sheet1!$A$1:$A$7"
schart.DisplayEmptyCellsAs = GrapeCity.Xaml.SpreadSheet.Data.EmptyValueStyle.Zero
schart.DisplayHidden = True
GcSpreadSheet1.ActiveSheet.Charts.Add(schart)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SpreadChart Class
SpreadChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options