Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Chart Namespace / EmptyValueStyle Enumeration
Example Example


In This Topic
    EmptyValueStyle Enumeration
    In This Topic
    Specifies how to show empty worksheet cells in a data series in the chart.
    Syntax
    'Declaration
     
    Public Enum EmptyValueStyle 
       Inherits System.Enum
    'Usage
     
    Dim instance As EmptyValueStyle
    public enum EmptyValueStyle : System.Enum 
    Members
    MemberDescription
    ConnectInstead of leaving gaps for empty worksheet cells in a data series, the gaps are filled with a connecting element.
    GapsLeaves gaps for empty worksheet cells in a data series, which results in a segmented line.
    ZeroTreats empty worksheet cells in a data series as zero values, so that the line drops to zero for zero-value data points.
    Example
    This example uses the EmptyValueStyle enumeration.
    FpSpread1.Sheets[0].AddChart(0, 0, typeof(FarPoint.Web.Chart.BarSeries), 300, 300, 0, 0, FarPoint.Web.Chart.ChartViewType.View2D, true);
    FarPoint.Web.Spread.Chart.ChartDataSetting dataSetting = new FarPoint.Web.Spread.Chart.ChartDataSetting(FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero, true);
    FarPoint.Web.Spread.Chart.SpreadChart chart = FpSpread1.Sheets[0].Charts[0];        
    chart.DataSetting = dataSetting;
    //chart.DataSetting.EmptyValueStyle = FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero;
    //chart.DataSetting.ShowHiddenData = true;
    FpSpread1.Sheets(0).AddChart(0, 0, GetType(FarPoint.Web.Chart.BarSeries), 300, 300, 0, 0, FarPoint.Web.Chart.ChartViewType.View2D, True)
    Dim chart As FarPoint.Web.Spread.Chart.SpreadChart
    Dim dataSetting As New FarPoint.Web.Spread.Chart.ChartDataSetting(FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero, True)
    chart = FpSpread1.Sheets(0).Charts(0)
    chart.DataSetting = dataSetting
    'chart.DataSetting.EmptyValueStyle = FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero
    'chart.DataSetting.ShowHiddenData = True
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Web.Spread.Chart.EmptyValueStyle

    See Also