HierarchicalView Property

Gets or sets whether to display the child sheets in the Spread component hierarchically.

Syntax

Visual Basic
C#

'Declaration
 
Public Property HierarchicalView As Boolean

'Usage
 
Dim instance As FpSpread
Dim value As Boolean
 
instance.HierarchicalView = value
 
value = instance.HierarchicalView

public bool HierarchicalView {get; set;}

Property Value

true if component displays child views; otherwise false

Example

This example binds the spreadsheet to a dataset and turns off the hierarchical view and displays the hierarchy bar when the user clicks on the any of the expansion nodes.

DataSet ds = new System.Data.DataSet();

private void Page_Load(object sender, System.EventArgs e)
{
  if (this.IsPostBack) return;
  
  this.CreateDataSet();
  FpSpread1.Sheets[0].DataSource = ds;
  FpSpread1.Sheets[0].DataMember = "names";
  FpSpread1.Sheets[0].AllowSort = true;
  FpSpread1.Sheets[0].AlternatingRows[0].ForeColor = Color.Teal;
  FpSpread1.Sheets[0].SetColumnWidth(2, 150);
  FpSpread1.RowHeader.Width = 40;
  FpSpread1.HierBar.ShowParentRow = true;
  FpSpread1.HierBar.ShowWholePath = true;
  FpSpread1.HierarchicalView = false;    
}

private void CreateDataSet()
{
  DataTable names;
  DataTable cars;
  DataTable colors;
  names = ds.Tables.Add("names");
  names.Columns.Add("first");
  names.Columns.Add("last");
  names.Columns.Add("index");
  names.Rows.Add(new object[] {"bob", "morris", 0});
  names.Rows.Add(new object[] {"sean", "morris", 1});
  names.Rows.Add(new object[] {"chris", "morris", 2});
  cars = ds.Tables.Add("cars");
  cars.Columns.Add("make");
  cars.Columns.Add("model");
  cars.Columns.Add("owner");
  cars.Rows.Add(new object[] {"ford", "F-150", 0});
  cars.Rows.Add(new object[] {"ford", "Mustang", 1});
  cars.Rows.Add(new object[] {"chevy", "Impala", 2});
  colors = ds.Tables.Add("colors");
  colors.Columns.Add("exterior");
  colors.Columns.Add("interior");
  colors.Columns.Add("owner");
  colors.Rows.Add(new object[] {"black", "gray", 0});
  colors.Rows.Add(new object[] {"red", "beige", 1});
  colors.Rows.Add(new object[] {"black", "tan", 2});
  ds.Relations.Add("cars", names.Columns["index"], cars.Columns["owner"]);
  ds.Relations.Add("colors", names.Columns["index"], colors.Columns["owner"]);
}

Visual Basic

Dim ds As New System.Data.DataSet()

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

  If (Me.IsPostBack) Then Return

  CreateDataSet()
  FpSpread1.Sheets(0).DataSource = ds
  FpSpread1.Sheets(0).DataMember = "names"
  FpSpread1.Sheets(0).AllowSort = True
  FpSpread1.Sheets(0).AlternatingRows(0).ForeColor = Color.Teal
  FpSpread1.Sheets(0).SetColumnWidth(2, 150)
  FpSpread1.RowHeader.Width = 40
  FpSpread1.HierBar.ShowParentRow = True
  FpSpread1.HierBar.ShowWholePath = True
  FpSpread1.HierarchicalView = False

End Sub

Private Sub CreateDataSet()
  Dim names As DataTable
  Dim cars As DataTable
  Dim colors As DataTable
  names = ds.Tables.Add("names")
  names.Columns.Add("first")
  names.Columns.Add("last")
  names.Columns.Add("index")
  names.Rows.Add(New Object() {"bob", "morris", 0})
  names.Rows.Add(New Object() {"sean", "morris", 1})
  names.Rows.Add(New Object() {"chris", "morris", 2})
  cars = ds.Tables.Add("cars")
  cars.Columns.Add("make")
  cars.Columns.Add("model")
  cars.Columns.Add("owner")
  cars.Rows.Add(New Object() {"ford", "F-150", 0})
  cars.Rows.Add(New Object() {"ford", "Mustang", 1})
  cars.Rows.Add(New Object() {"chevy", "Impala", 2})
  colors = ds.Tables.Add("colors")
  colors.Columns.Add("exterior")
  colors.Columns.Add("interior")
  colors.Columns.Add("owner")
  colors.Rows.Add(New Object() {"black", "gray", 0})
  colors.Rows.Add(New Object() {"red", "beige", 1})
  colors.Rows.Add(New Object() {"black", "tan", 2})
  ds.Relations.Add("cars", names.Columns("index"), cars.Columns("owner"))
  ds.Relations.Add("colors", names.Columns("index"), colors.Columns("owner"))
End Sub

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

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Displaying Data as a Hierarchy