Spread Silverlight Documentation
DisplayEmptyCellsAs Property (SpreadChart)
Example 


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)
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

SpreadChart Class
SpreadChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.