GrapeCity.Xaml.SpreadSheet.Data Namespace : EmptyValueStyle Enumeration |
'Declaration Public Enum EmptyValueStyle Inherits System.Enum
'Usage Dim instance As EmptyValueStyle
public enum EmptyValueStyle : System.Enum
Member | Description |
---|---|
Connect | Fills gaps with a connecting element instead of leaving gaps for empty values in a data series. |
Gaps | Leaves gaps for empty values in a data series, which results in a segmented line. |
Zero | Handles empty values in a data series as zero values, so that the line drops to zero for zero-value data points. |
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)
System.Object
System.ValueType
System.Enum
GrapeCity.Xaml.SpreadSheet.Data.EmptyValueStyle
Target Platforms: Windows Server 2012, Windows RT