Row Calculation

The Row Calculation form can be accessed by clicking the ellipse button on Formula field of the Column Designer form. This form displays the rows and columns arranged like an actual report layout. This form also allows you to enter formulas to perform calculations using other cells in the worksheet.

Row Calculation MUST be selected on the Column Type field in order for the Formula field to be visible.

The Cell Name field indicates the code of the cell where you are currently entering a formula in. If you are not entering a formula, it will simply display the cell code of where the current focus is.

The Formula Editor allows you to enter a formula or edit a formula on a specific cell by simply placing an equal sign '=' and reference the cells that you want to include in the formula by clicking the cell or manually typing the cell code.

You can also directly enter a formula in a cell. Same procedures follow

Note: You can only edit the cells under the column that you are currently on when the Formula ellipse button is clicked.

Buttons

Click the OK button to close the form and save the changes made in the worksheet.

Click the Cancel button to close the form and cancel the changes made in the worksheet.