Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum EmptyValueStyle Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As EmptyValueStyle | |
| C# | |
|---|---|
public enum EmptyValueStyle : System.Enum | |
Members
| Member | Description |
|---|---|
| Connect | Instead of leaving gaps for empty worksheet cells in a data series, the gaps are filled with a connecting element. |
| Gaps | Leaves gaps for empty worksheet cells in a data series, which results in a segmented line. |
| Zero | Treats 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.
| C# | Copy Code |
|---|---|
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; | |
| Visual Basic | Copy Code |
|---|---|
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
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8