Spread Windows Forms 12.0 Product Documentation

Entering a Formula in Spread Designer

You can enter a formula into a cell or range of cells using the **Formula** bar and the **Formula Editor** in the Spread Designer. The **Formula** bar provides a quick way to enter a formula for a cell or group of cells. The **Formula Editor** allows you to select any of the built-in functions and is called from the **Formula** bar when you click fx option, as shown in the following figure.

Click Choose Formula (the fx option), which launches the **Formula Editor**, or type equals (=) to begin entering the formula. (You can also launch the **Formula Editor** by clicking the button in the **Formula** property in the **Property** window.) The **Formula Editor** gives you a list of the built-in functions that you can use and displays a brief description of the selected function. To choose a function, double-click on the function name and it appears in the Formula field. Functions are organized by category. You may also type operators and constants to construct your formula.

You can enter the formula in the Formula field in the **Formula Editor** or in the formula box in the **Formula** **Bar**. When you are done entering the formula with the **Formula Editor**, click **Apply** or **OK**. When you are done typing the formula in the formula box, click Enter (the check mark button). This applies the formula to the selected cell or range of cells. When you click **OK** or **Apply**, the **Formula Editor** evaluates the formula to see if it is a valid formula. If it is not valid, it displays an error message. For more information on formulas and functions, refer to the Formula Reference.

To display or hide the formula bar, from the **View** menu, select **Formula Bar**.

From the **File** menu choose **Apply and Exit** to apply your changes to the FpSpread component and exit Spread Designer.

For more tasks in Spread Designer, return to Designing in the Data Area.