Spread for ASP.NET 7.0 Product Documentation
EmptyValueStyle Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.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.

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

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

See Also

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