-
Spread for ASP.NET 18 Product Documentation
-
Developer's Guide
- Getting Started
- Understanding the Product
- Namespaces Overview
- Working with the Spread Designer
- Customizing User Interaction
- Customizing the Appearance
- Customizing with Cell Types
- Managing Data Binding
- Managing Data in the Component
-
Managing Formulas
- Setting Calculation Culture
- Placing a Formula in Cells
- Specifying a Cell Reference Style in a Formula
- Using a Circular Reference in a Formula
- Nesting Functions in a Formula
- Finding a Value with Goal Seeking
- Recalculating and Updating Formulas Automatically
- Creating a Custom Function
- Creating a Custom Name
- Using the Formula Extender Control
- Managing File Operations
- Using Sheet Models
- Maintaining State
- Working with the Chart Control
- Using Touch Support with the Component
- Assembly Reference
- Client-Side Scripting Reference
- Import and Export Reference
-
Developer's Guide
Nesting Functions in a Formula
You can nest a function within another function in a formula.
For more information about formulas, refer to the Formula Reference.
Using Code
Specify the cell type.
Use a function within another function in a formula
Example
In this example the sum of the value in two cells (found by using the SUM function) is embedded in a PRODUCT formula. First the cell types are set and the values of the cells are set.
FarPoint.Web.Spread.DoubleCellType ncell = new FarPoint.Web.Spread.DoubleCellType();
FpSpread1.Sheets[0].Cells[0, 0, 2, 0].CellType = ncell;
FpSpread1.Sheets[0].Cells[0, 0, 2, 0].Value = 2;
FpSpread1.Sheets[0].Cells[3, 1].Formula = "PRODUCT(A1, SUM(A2,A3))";Dim ncell As New FarPoint.Web.Spread.DoubleCellType
FpSpread1.Sheets(0).Cells(0, 0, 2, 0).CellType = ncell
FpSpread1.Sheets(0).Cells(0, 0, 2, 0).Value = 2
FpSpread1.Sheets(0).Cells(3, 1).Formula = "PRODUCT(A1, SUM(A2,A3))"