Spread Windows Forms 6.0 Product Documentation
EmptyValueStyle Enumeration
Example  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Chart Namespace : EmptyValueStyle Enumeration

Glossary Item Box

Lets you specify how you want empty worksheet cells in a data series to be shown in the chart.


Visual Basic (Declaration) 
Public Enum EmptyValueStyle 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As EmptyValueStyle
public enum EmptyValueStyle : System.Enum 


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.


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 BasicCopy 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



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

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.