Calculating formulas in tables
WordPerfect lets you perform spreadsheet calculations on table data. For example, you can calculate formulas, add values in a table quickly, and ignore a cell during calculations.
Formulas are calculated automatically each time you move the insertion point or insert a formula using the Table formula toolbar. You can disable automatic calculation.
You can also fill in cells with incrementing patterns and dates. A pattern of values must increment or decrement based on addition or subtraction. You cannot fill in a pattern of values that increment or decrement based on multiplication or division.
You can get more information about table formula errors, including a brief explanation of any ?? and ERR error symbols that display in a table as you calculate formulas.
To calculate a formula in a table 
1.


Click in a table.

2.


Click Table Calculate.

3.


Enable one of the following options:

•

Calculate table — calculates the table or floating cell in which the insertion point is positioned

•

Calculate tables in document — calculates all tables and floating cells in the document

•


You can disable automatic calculation by enabling the Off option.

To add values in a table quickly 
1.


Click the table cell below or to the right of the cells whose total you want to calculate.

2.


Click Table QuickSum.

•


The calculated sum overwrites any values, formulas, or text in the cell you click.

•


You can also add values by clicking the QuickSum button on the Table formula toolbar. To display the Table formula toolbar, click Table Formula toolbar.

To ignore a table cell during calculations 
1.


Select a cell, and click Table Format.

2.


Click the Cell tab.

3.


Enable the Ignore cell when calculating check box.

To fill a table with incremental numbers or dates 
1.


Select the cells that contain the incremental or decremental pattern of val
ues as well as the cells in which you want to continue the pattern. 
2.


Click Table QuickFill.

•


You can also fill a table with incrementing numbers or dates by clicking the QuickFill button on the Table formula toolbar. To display the Table formula toolbar, click Table Formula toolbar.

To display more information about table formula errors 
1.


Click a cell that contains an error.

2.


Click the View error button on the Table formula toolbar.
