GetRootWorkbook Method (FpSpread)

Gets the main workbook associated with the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetRootWorkbook() As SpreadView

'Usage
 
Dim instance As FpSpread
Dim value As SpreadView
 
value = instance.GetRootWorkbook()

public SpreadView GetRootWorkbook()

Return Value

SpreadView object containing the top or main workbook

Example

This example illustrates the use of this member by returning the main workbook associated with the Spread component.

FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.GetRootWorkbook().Sheets.Add(shv);

Visual Basic

Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.GetRootWorkbook().Sheets.Add(shv)

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

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Working with Hierarchical Data Display