GrapeCity.Windows.SpreadSheet.Data Namespace > SpreadChart Class : DisplayEmptyCellsAs Property |
'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;}
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)
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