Spread Windows Forms 11.0 Product Documentation
EmptyValueStyle Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Chart Namespace : EmptyValueStyle Enumeration
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.
SpreadChart chart = this.fpSpread1_Sheet1.Charts[0];
ChartDataSetting dataSetting = new ChartDataSetting(EmptyValueStyle.Zero, true);
chart.DataSetting = dataSetting;
//chart.DataSetting.EmptyValueStyle = EmptyValueStyle.Zero;
//chart.DataSetting.ShowHiddenData = true;
Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart(GetType(FarPoint.Win.Chart.BarSeries))
Dim dataSetting As New FarPoint.Win.Spread.Chart.ChartDataSetting(FarPoint.Win.Spread.Chart.EmptyValueStyle.Zero, True)
chart.DataSetting = dataSetting
fpSpread1.Sheets(0).AddChart(chart, 0, 0)
'chart.DataSetting.EmptyValueStyle = FarPoint.Win.Spread.Chart.EmptyValueStyle.Zero
'chart.DataSetting.ShowHiddenData = True
Inheritance Hierarchy

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

See Also

Reference

FarPoint.Win.Spread.Chart Namespace