Formula Sections

In This Topic

The formula sections are represented by instances of the NFormulaSection class. You can think of formula sections as groups, which group related cells. The sections of a sheet are contained in an instance of the NFormulaSectionCollection class, which can be obtained from the Sections property of the NFormulaSheet class. The following example creates a sheet and adds a section in it:

C#	Copy Code
// create a new sheet and get its sections NFormulaSheet sheet = new NFormulaSheet(); // create a section with the specified name and title NFormulaSection section = new NFormulaSection("MySection", "My First Section"); // add the section to the sheet sheet.Sections.Add(section);

Copy Code

// create a new sheet and get its sections
NFormulaSheet sheet = new NFormulaSheet();
// create a section with the specified name and title
NFormulaSection section = new NFormulaSection("MySection", "My First Section");
// add the section to the sheet
sheet.Sections.Add(section);

Visual Basic	Copy Code
' create a new sheet Dim sheet As New NFormulaSheet ' create a section with the specified name and title Dim section As New NFormulaSection("MySection", "My First Section") ' add the section to the sheet sheet.Sections.Add(section)

Visual Basic

Copy Code

' create a new sheet
Dim sheet As New NFormulaSheet
' create a section with the specified name and title
Dim section As New NFormulaSection("MySection", "My First Section")
' add the section to the sheet
sheet.Sections.Add(section)

Section Name and Title

Each section has a name and a title, which are accessible from the Name and Title properties respectively. The section name is used as a prefix when you want to explicitly specify the section in which a named cell resides (see Formula Cell References for more information). The section title is used when the formula section is visually edited.

Section Cells

Each section stores its cells in one (or both) of the following ways:

Named Section Cells - the named section cells are stored in an instance of the NFormulaCellDictionary class, which can be obtained from the Cells property. The named section cells, can be referenced by other cells formulas by their name. The following example adds several named cells to a section:

C#	Copy Code
// create the section cells dictionary and add two cells section.Cells = new NFormulaCellDictionary(); section.Cells.Add("Cell1", new NSingleFormulaCell(10)); section.Cells.Add("Cell2", new NSingleFormulaCell(20));

Copy Code

// create the section cells dictionary and add two cells
section.Cells = new NFormulaCellDictionary();
section.Cells.Add("Cell1", new NSingleFormulaCell(10));
section.Cells.Add("Cell2", new NSingleFormulaCell(20));

Visual Basic	Copy Code
' create the section cells dictionary and add two cells section.Cells = New NFormulaCellDictionary section.Cells.Add("Cell1", New NSingleFormulaCell(10)) section.Cells.Add("Cell2", New NSingleFormulaCell(20))

Visual Basic

Copy Code

' create the section cells dictionary and add two cells
section.Cells = New NFormulaCellDictionary
section.Cells.Add("Cell1", New NSingleFormulaCell(10))
section.Cells.Add("Cell2", New NSingleFormulaCell(20))

Section Rows - the rows of a section are contained in an instance of the NFormulaRowCollection class, which can be obtained from the Rows property. You can add and remove NFormulaRow instances from this collection. Formula rows are in fact collections of formula cells. The formula rows form an irregular grid (since rows can have a different number of cells). The following example adds several rows to a section:

C#	Copy Code
// create the rows collection section.Rows = new NFormulaRowCollection(); // add a row with two cells NFormulaRow row1 = new NFormulaRow(); row1.Add(new NSingleFormulaCell(10)); row1.Add(new NSingleFormulaCell(20)); section.Rows.Add(row1); // add a row with three cells NFormulaRow row2 = new NFormulaRow(); row2.Add(new NSingleFormulaCell(10)); row2.Add(new NSingleFormulaCell(20)); row2.Add(new NSingleFormulaCell(30)); section.Rows.Add(row2);

Copy Code

// create the rows collection
section.Rows = new NFormulaRowCollection();
// add a row with two cells
NFormulaRow row1 = new NFormulaRow();
row1.Add(new NSingleFormulaCell(10));
row1.Add(new NSingleFormulaCell(20));
section.Rows.Add(row1); 
// add a row with three cells
NFormulaRow row2 = new NFormulaRow();
row2.Add(new NSingleFormulaCell(10));
row2.Add(new NSingleFormulaCell(20));
row2.Add(new NSingleFormulaCell(30));
section.Rows.Add(row2);

Visual Basic	Copy Code
' create the rows collection section.Rows = New NFormulaRowCollection ' add a row with two cells Dim row1 As New NFormulaRow row1.Add(New NSingleFormulaCell(10)) row1.Add(New NSingleFormulaCell(20)) section.Rows.Add(row1) ' add a row with three cells Dim row2 As New NFormulaRow row2.Add(New NSingleFormulaCell(10)) row2.Add(New NSingleFormulaCell(20)) row2.Add(New NSingleFormulaCell(30)) section.Rows.Add(row2)

Visual Basic

Copy Code

' create the rows collection
section.Rows = New NFormulaRowCollection
' add a row with two cells
Dim row1 As New NFormulaRow
row1.Add(New NSingleFormulaCell(10))
row1.Add(New NSingleFormulaCell(20))
section.Rows.Add(row1)
' add a row with three cells
Dim row2 As New NFormulaRow
row2.Add(New NSingleFormulaCell(10))
row2.Add(New NSingleFormulaCell(20))
row2.Add(New NSingleFormulaCell(30))
section.Rows.Add(row2)

The cells inside rows, can be referenced by other cells formulas with an identifier, which is a concatenation of the section name, cell column name and row index. See Formula Cell References for more information.

Section Verbs

Visually the formula sections are edited with verbs. The verbs, which the section supports can be obtained from the GetVerbs method of the NFormulaSection class. Besides the section the rows inside it can also provide verbs for visual editing - they are consistently retrieved from the the GetVerbs method of the NFormulaRow class.