Spread Windows Forms 9.0 Product Documentation
DisplayHidden Property
Example 


Gets or sets a value that indicates whether data in hidden cells is plotted for the sparklines in this sparkline group.
Syntax
'Declaration
 
Public Property DisplayHidden As Boolean
'Usage
 
Dim instance As ExcelSparklineSetting
Dim value As Boolean
 
instance.DisplayHidden = value
 
value = instance.DisplayHidden
public bool DisplayHidden {get; set;}

Property Value

true to display data in hidden cells; otherwise, false.
Example
This example sets the DisplayHidden property.
FarPoint.Win.Spread.SheetView sv = new FarPoint.Win.Spread.SheetView();
FarPoint.Win.Spread.Chart.SheetCellRange data = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 0, 0, 1, 5);
FarPoint.Win.Spread.Chart.SheetCellRange data2 = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1);

FarPoint.Win.Spread.ExcelSparklineSetting ex = new FarPoint.Win.Spread.ExcelSparklineSetting();
ex.LineWeight = 2;
ex.ShowMarkers = true;
ex.DisplayXAxis = true;
ex.DisplayHidden = true;
fpSpread1.Sheets[0] = sv;
sv.Cells[0, 0].Value = 2;
sv.Cells[0, 1].Value = 5;
sv.Cells[0, 2].Value = 4;
sv.Cells[0, 3].Value = -1;
sv.Cells[0, 4].Value = 3;
sv.Columns[2].Visible = false;
fpSpread1.Sheets[0].AddSparkline(data, data2, FarPoint.Win.Spread.SparklineType.Line, ex);
Dim sv As New FarPoint.Win.Spread.SheetView()
Dim data As New FarPoint.Win.Spread.Chart.SheetCellRange(sv, 0, 0, 1, 5)
Dim data2 As New FarPoint.Win.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1)

Dim ex As New FarPoint.Win.Spread.ExcelSparklineSetting()
ex.LineWeight = 2
ex.ShowMarkers = True
ex.DisplayXAxis = True
ex.DisplayHidden = True
FpSpread1.Sheets(0) = sv
sv.Cells(0, 0).Value = 2
sv.Cells(0, 1).Value = 5
sv.Cells(0, 2).Value = 4
sv.Cells(0, 3).Value = -1
sv.Cells(0, 4).Value = 3
sv.Columns(2).Visible = False

FpSpread1.Sheets(0).AddSparkline(data, data2, FarPoint.Win.Spread.SparklineType.Line, ex)
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

ExcelSparklineSetting Class
ExcelSparklineSetting Members

 

 


Copyright © GrapeCity, inc. All rights reserved.