Reports Application

• New

• Open

• Close

• Save

• Save As

• Revert to Saved

• Page Setup

• Page Preview

• Print

• Exit

The New command creates a new worksheet with the default file name Sheet.wkz. Subsequent new worksheets are named Sheet#.wkz, where # is a number representing the order in which the worksheet was created. You can assign the worksheet a different name when you save it. The filename extension is not necessary, but it helps you identify worksheet files.

The Open command opens existing worksheet files including Wingz, BIFF, DIF, SYLK or Lotus 1-2-3 (version 1a or 2.0) worksheet files, or standard ASCII text files. When you select Open, the Open Spreadsheet window is displayed, prompting you for the file name to open. The Filter field indicates the current path and the type of files specified the last time the Filter command was used. The directories listed are those below the path in the Filter field. The files listed are of the type specified the last time the Filter command was used.

The Close command closes an open worksheet file. If you close a new worksheet file, you are prompted to determine if you want to save the file and, if so, the Save Spreadsheet window is displayed. The Selection field displays the current path and the default filename, Sheet.wkz.

The Save As command displays the Save Spreadsheet window listing the current filter, available directories and file names, and the name that will be assigned to the file in the Selection field. Click the File Type button to select a file type other than the Wingz default.

The Revert to Saved command enables you to abandon all changes made to the current worksheet since it was last saved. If changes have been made to the worksheet file since it was last saved, a dialog box prompts you to discard any changes that have been made or return to the modified worksheet file and cancel the Revert to Saved command.

• Undo Entry/Can't Undo

• Cut

• Copy

• Paste

• Clear

• Select All

• Show Clipboard

• Insert

• Delete

• Copy Right

• Copy Down

The Undo Entry command reverses the action of the previous cut, paste, clear, insert, delete, copy right, copy down, or paste special commands. The menu displays Undo followed by the editing action that was just performed. If the previous command cannot be undone, the Can't Undo command appears greyed at the top of the Edit Menu. the Undo command is not available when text has been cut, pasted, or cleared form a text field or script. If Undo was the last command executed, the menu option changes to Redo followed by the name of the command just undone.

The cut, copy, paste, clear, and select all commands function the same way as you would expect from the same commands in other applications.

The Insert command inserts a rnage of empty cells into a selcedted area of a worksheet, when the cells are inserted, no data is overwritten. Instead, the data in and to the right of the selected range is shifted to the right. The number of columns in the selected range determines how many columns to the right the data shifts. If a range of rows is selected, the cell data in the range, as well as all data in the rows beneath, the range is shifted downward the number of rows in the range. All formulae with cell references affected by the Insert command are adjusted after the command is executed.

The Delete command deletes a selected range and its contents. When a range is deleted the data within the range is removed, and the data in the cells to the right of the range is shifted to the left. The number of columns in the selected range determines how many columns to the left the data shifts. If a range of rows is selected, the cell data in the range, as well as all data in the rows beneath, the range is shifted upward the number of rows in the range. All formulae with cell references affected by the Delete command are adjusted after the command is executed.

The Copy Right command copies cell contents from the left column of a selected range into cells directly to the right of the column within the same selected range. When multiple discontiguous ranges are selected, the operation is performed on all selected ranges. When only a single cell or column is selected, the Copy Right command is greyed.

The Clear Special command clears only specific information from a selecte cell or range. The Clear Special command has the following submenu options:

• Format --- removes the format set for the currently selected range and displays the cell information in the default format.

• Formula --- replaces the formulae in the selected range with the results of the formulae. This option produces the same result as choosing Cut, then selecting Values from the Paste Special submenu.

• Data --- removes the data from the selected cell or range, but the formatting information remains the same.

• Recalc

• Recalc Info

• Paste Formula

• Find

• Select

• Name

• Define Name

• Create Names

• Remove Names

The Recalc command performs an immediate recalculation of the entire worksheet, including charts and formulae. Teh method, order, and number of recalculations are determined by the current settings in the Recalc Info submenu.

Recalc is typically used in conjunction with the Manual Recalc option in the Recalc Info submenu. In Manual Recalculation mode, no recalculation is performed until you choose the Recalc command.

To interrupt recalculation, enter data from the keyborad or click the mouse. If you interrupt the recalculation process, you must choose Recalc again to restart the recalculation.

The Recalc Info command determines how and when recalculation occurs through the following submenu selections:

• Manual Recalc

This option disables automatic recalculation of a worksheet, requiring you to select the Recalc command to recalculate your worksheet. Use this option before defining iteration criteria to ensure the correct number of recalculations.

• Automatic Recalc

This option is used to recalculate each time a formula is changed or when information affecting a formula is entered. This is the default mode of recalculation.

• Natural Recalc

This option causes recalculation to occur in the order required to resolve formula dependencies. This is the default order of recalculation.

• Row Recalc

This option causes recalculation to begin at cell A1 and continue for all formulae in the first row from left to right. Recalculation then continues for the second row, starting at cell A2 from left to right, and continues in this manner through the worksheet.

• Column Recalc

This option causes recalculation to begin at cell A1 and continue for all formulae in the first column from top to bottom. Recalculation then continues in the second column, starting at cell B1 from top to bottom, and continues in this manner through the worksheet.

• Iteration

This option casues the worksheet to be recalculated depending upon the settings in the Iteration dialog box, shown in FIGX. Iteration options generally apply to worksheets that contain circular references.

***TBS Iteration Dialog Box ***

Worksheet recalculation continues until the amount of change in the Test Cell field from one iteration to the next is less than or equal to the Max Change value. The formula specified in the Test Cell field must contain a circular reference. The formula value is tested for the amount of change after each recalculation. Max Iterations, entered via the stepper button, determines the maximum number of times the worksheet is recalculated.

When you choose the Paste Formula command, a dialog box is displayed, listing all Wingz function types associated with the selected radio button. The radio buttons select types of functions that can be performed and list each available function in the right side of the window.

The Find command searches a worksheet, text field, or script for text strings, values, formulae, specific criteria, or cell locations. When the Find command is used for a cell or range, a dialog box is displayed allowing you to select the item to search. The following options are available:

• Text --- indicates a search item is text; quotation marks used in search string are interpreted literally.

• Value --- indicates the search item is to be interpreted as a numeric value.

• Formula --- searchs for the cell with a formula containing the search string; quotation marks in search string are interpreted literally.

• Criteria --- indicates that the search item is int3erpreted as a conditional expression that is recalculated for each cell until the equation returns a non-zero (True) value.

• Cell --- indicates that the search item represents a worksheet cell or range reference.

The Select command selects all items of a chosen type. The following options are available from the Select submenu:

• Notes --- selects all text fields defined as cell notes.

• Fields --- selects all text fields not defined as cell notes.

• Controls --- selects all controls except text fields and cell notes, both visible and hidden.

• Graphics --- selects all charts, graphic objects, and pictures in the current worksheet.

• Text Cells --- selects all cells in the current worksheet that contain text; formulae that return text strings are not selected.

• Value Cells --- selects all cells in the current worksheet that contain numeric values.

• Formula Cells --- selects all cesll in the current wirsheet aht contain formulae.

• Error Cells --- selects all formula cells in the current worksheet that return errors.

• Locked Cells --- selects all locked cells in the current worksheet.

• Blank Cells --- highlights blank cells in the current worksheet. (A blank cell is one that has been formatted but does not contain data.)

• Heading --- selects worksheet row and column headings.

• All Precedents --- selects cells in the current worksheet that affect the formula in the current cell.

• Direct Precedents --- selects all cells in the current worksheet affected by the data in the currently selected cell.

• Direct Dependents --- selects only those cells that directly reference the currently selected cell.

• References to Blanks --- selects all cells in the current worksheet that contain formulae referencing blank cells.

• Unreferenced Cells --- selects all cells in the current worksheet that are neither empty nor referenced blank cells.

• Current Cell --- displays the currently selected cell or range in the current window.

• Last Cell --- selects the last cell in the worksheet's active range.

• Active Cells --- selects the smallest range that begins at cell A1 and contains all non-empty cells and objects in the current worksheet.

• Report Header --- selects the crrently defined report header, enabling you to format the header area using the Fill, Line, and Border commands in the Format menu.

• Report Footer --- selects the currently defined report footer, enabling you to format the footer area using the Fill, Line, and Border commands in the Format menu. This option does not visibly selet the report footer on the worksheet.

• Report Border --- selects the report border, enabling you to format the printer border using the Line and Border commands in the Format menu. This option does not visibly select the report border on the worksheet.

The Name command displays a submenu of defined names. Choose a name to select the cell or rangte assigned that name. (You assign names to a cell or range using either the Define Name or Create Names command.)

The Define Name command assigns a name to a cell or range. The name can be used in a formula in place of the range it identifies. The first character etnered in the name must be a letter; subsequent characters can be letters, numbers, spaces, or underscore characters. Worksheet names are stored as part of the worksheet. When you create or change a name, you must save the worksheet to save the new name.

When you select the Define Name command, the Define Name dialog box is displayed. Under the Name field is the Reference field. Enter the range reference for the specified name. If a range is currently selected in the worksheet, that range is displayed in the Reference area. All range references are displayed as absolute references. If a range is entered as a relative reference, it is changed to an absolute reference with it is saved.

The Create Names command assigns names to the columns or rows in a specified range, corresponding to the text entered in the top row or left column of the range. When you select Create Names, a submenu is displayed with the following options: Top Row and Left Column. The Top Row option assigns names to the columns in the selected range, based on the text in the first cell of each column. The Left Column option assigns names to the rows in the selected range, based on the text in the first cell of each row.

The Remove Name command remvoes a defined name from the current worksheet, without affecting the data stored in the defined range. If you attempt to remove a name used in a formula, an error message informs you Wingz is unable to remove a name in use.

To locate the formulae using the range name you wnat to remove, choose Find in the Go menu. Then select the Formula opton in the Find dialog box and etner the range name in the text field.