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 |
|---|---|
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; | |
| Visual Basic | Copy Code |
|---|---|
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
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6