GrapeCity.Xaml.SpreadSheet.Data Namespace > SparklineSetting Class : DisplayEmptyCellsAs Property |
'Declaration <DefaultValueAttribute()> Public Property DisplayEmptyCellsAs As EmptyValueStyle
'Usage Dim instance As SparklineSetting Dim value As EmptyValueStyle instance.DisplayEmptyCellsAs = value value = instance.DisplayEmptyCellsAs
[DefaultValue()] public EmptyValueStyle DisplayEmptyCellsAs {get; set;}
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr2 = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 4); GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting(); ex.DisplayEmptyCellsAs = GrapeCity.Xaml.SpreadSheet.Data.EmptyValueStyle.Zero; ex.DisplayXAxis = true; gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 5; gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 3; gcSpreadSheet1.Sheets[0].Cells[1, 3].Value = 4; gcSpreadSheet1.Sheets[0].SetSparkline(1, 5, cellr2, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Line, ex);
Dim cellr2 As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 4) Dim ex As New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting() ex.DisplayEmptyCellsAs = GrapeCity.Xaml.SpreadSheet.Data.EmptyValueStyle.Zero ex.DisplayXAxis = True GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 5 GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 3 GcSpreadSheet1.Sheets(0).Cells(1, 3).Value = 4 GcSpreadSheet1.Sheets(0).SetSparkline(1, 5, cellr2, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Line, ex)
Target Platforms: Windows Server 2012, Windows RT