Spread Windows Forms 10.0 Product Documentation
EmptyValueStyle Enumeration
Example Example 


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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FarPoint.Win.Spread.Chart Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.