Spread 8.0 Documentation
Spread Designer
Support Options

Glossary Item Box

Spread Designer


To add a formula to a sheet

In the Spread Designer,

  1. Select the cell or block of cells to which you want to add a formula.
  2. If you want to use the Formula dialog to enter a formula:
    1. From the Cell menu, choose Formula or press the Formula button ( ) on the Cell toolbar.
    2. On the Formula tab in the Cell Settings dialog box, type the formula in the Formula box.
      A list of valid operators available as mathematical expressions is displayed under Formula Operations. If you want to use functions supplied by Spread, choose the function from the drop-down list box and choose the Insert button.
    3. Choose the OK or Apply button.
  3. If you want to use the Formula toolbar to enter a formula:
    1. Press the Access Formula ( ) button on the Formula toolbar.
    2. Enter the formula in the text box.
      Use the buttons to select operators available as mathematical expressions. Choose functions supplied by Spread from the Functions drop-down list box. Choose a custom name, which you have created using the SetCustomName method, from the Custom Name drop-down list box.
    3. Choose the Submit button ( ).
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.