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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2