Using the Workbook Designer Menus

The following tables highlight the commands available on the Workbook Designer menu bar and provide a brief description of each command.

File Menu

Command Description

New Creates a new workbook file.

Open Opens a workbook file from disk. You can open files saved in Formula One 3.x and newer format (.VTS files), Excel format (.XLS file), and tabbed text (.TXT).

Close Closes the current workbook file. Prompts you to save any unsaved changes.

Save
Save As Saves the current workbook. Workbook Files can be saved in Formula One formats 3.x, 4.x, 5.x, 6.x, 7.x (.VTS files), Excel Versions 5, 7, Excel 97, Excel 2000 formats (.XLS files), tabbed text, or values-only tabbed text (.TXT).

Page Setup Displays the Page Setup dialog box. This dialog box allows you to define header and footer text, page margins, page print order, page orientation and size, page centering, page numbering, worksheet-related print options, and scale.

Print Area > Set Print Area Defines the currently selected range in the active worksheet as the Print_Area user-defined name.

Print Area >Clear Print Area Cancels the above action.

Print Titles > Set Print Titles Defines the currently selected range in the active worksheet as the Print_Titles user-defined name.

Print Titles >Clear Print Titles Cancels the above action.

Print Allows you to select print options and print the active worksheet.

Exit Exits the Workbook Designer.

Command	Description
New	Creates a new workbook file.
Open	Opens a workbook file from disk. You can open files saved in Formula One 3.x and newer format (.VTS files), Excel format (.XLS file), and tabbed text (.TXT).
Close	Closes the current workbook file. Prompts you to save any unsaved changes.
Save Save As	Saves the current workbook. Workbook Files can be saved in Formula One formats 3.x, 4.x, 5.x, 6.x, 7.x (.VTS files), Excel Versions 5, 7, Excel 97, Excel 2000 formats (.XLS files), tabbed text, or values-only tabbed text (.TXT).
Page Setup	Displays the Page Setup dialog box. This dialog box allows you to define header and footer text, page margins, page print order, page orientation and size, page centering, page numbering, worksheet-related print options, and scale.
Print Area > Set Print Area	Defines the currently selected range in the active worksheet as the Print_Area user-defined name.
Print Area >Clear Print Area	Cancels the above action.
Print Titles > Set Print Titles	Defines the currently selected range in the active worksheet as the Print_Titles user-defined name.
Print Titles >Clear Print Titles	Cancels the above action.
Print	Allows you to select print options and print the active worksheet.
Exit	Exits the Workbook Designer.

Edit Menu

Command Description

Undo Nullifies the last action performed with the mouse or keyboard in Formula One for Java. (up to 100 undos).

Redo Re-performs the nullified action (up to 100 redos).

Cut Removes the selected object or the contents of the selected cells and places it on the clipboard.

Copy Copies the the selected object or the contents of the selected cells to the clipboard.

Paste Pastes the contents of the clipboard into the selected cells.

Paste Special Pastes the formats, values, or formulas of copied cells into the selected cells. In addition, Paste Special controls how data copied from a different application is pasted.

Copy Cell Format Copies the current cell's formatting and applies the formatting to the next cell or range of cells selected.

Polygon Points Toggles between normal polygon editing and polygon point editing.

Select All Objects Selects all of the graphical objects on the active worksheet.

Sort Displays the Sort dialog box. This dialog box allows you to set the sorting method and sort keys for data sorting.

Fill > Down Places a copy of the data from the cells in the top row of the selected range into every cell below in the selected range. Existing data in the selected cells is replaced with the new data.

Fill > Right Places a copy of the data in the cells in the leftmost column of the selected range into every cell to the right in the selected range. Existing data in the selected cells is replaced with the new data.

Clear > All Clears formats and values from the selected cells.

Clear > Formats Clears cell formats from the selected cells; leaves the data intact.

Clear > Contents Clears values from the selected cells; leaves the formatting intact.

Delete > Options Deletes the selected cells or objects. Options allow you to designate which cells adjacent to the deleted cells are shifted to fill the space left by the vacated cells and to choose to delete an entire row or column of cells.

Delete Sheet Removes the selected worksheets.

Find Searches in selected cells or the active worksheet for the characters you specify and selects the first cell that contains those characters. If only one cell is selected, searches the entire worksheet.

Replace Searches in selected cells or the active worksheet for the characters you specify and replaces them with your specified replacement characters. If only one cell is selected, searches the entire worksheet.

Goto Displays the Goto dialog box, which allows you to specify a cell to display in the worksheet window. The specified cell is then made the active cell.

Preferences Displays the Preferences dialog box where you may choose a Look and Feel and set the number of undos.

Command	Description
Undo	Nullifies the last action performed with the mouse or keyboard in Formula One for Java. (up to 100 undos).
Redo	Re-performs the nullified action (up to 100 redos).
Cut	Removes the selected object or the contents of the selected cells and places it on the clipboard.
Copy	Copies the the selected object or the contents of the selected cells to the clipboard.
Paste	Pastes the contents of the clipboard into the selected cells.
Paste Special	Pastes the formats, values, or formulas of copied cells into the selected cells. In addition, Paste Special controls how data copied from a different application is pasted.
Copy Cell Format	Copies the current cell's formatting and applies the formatting to the next cell or range of cells selected.
Polygon Points	Toggles between normal polygon editing and polygon point editing.
Select All Objects	Selects all of the graphical objects on the active worksheet.
Sort	Displays the Sort dialog box. This dialog box allows you to set the sorting method and sort keys for data sorting.
Fill > Down	Places a copy of the data from the cells in the top row of the selected range into every cell below in the selected range. Existing data in the selected cells is replaced with the new data.
Fill > Right	Places a copy of the data in the cells in the leftmost column of the selected range into every cell to the right in the selected range. Existing data in the selected cells is replaced with the new data.
Clear > All	Clears formats and values from the selected cells.
Clear > Formats	Clears cell formats from the selected cells; leaves the data intact.
Clear > Contents	Clears values from the selected cells; leaves the formatting intact.
Delete > Options	Deletes the selected cells or objects. Options allow you to designate which cells adjacent to the deleted cells are shifted to fill the space left by the vacated cells and to choose to delete an entire row or column of cells.
Delete Sheet	Removes the selected worksheets.
Find	Searches in selected cells or the active worksheet for the characters you specify and selects the first cell that contains those characters. If only one cell is selected, searches the entire worksheet.
Replace	Searches in selected cells or the active worksheet for the characters you specify and replaces them with your specified replacement characters. If only one cell is selected, searches the entire worksheet.
Goto	Displays the Goto dialog box, which allows you to specify a cell to display in the worksheet window. The specified cell is then made the active cell.
Preferences	Displays the Preferences dialog box where you may choose a Look and Feel and set the number of undos.

View Menu

Command Description

Formula Bar Toggles the display of the Formula Bar.

Toolbars > Standard Toggles the display of the Main Toolbar.

Toolbars > Formatting Toggles the display of the Formatting Toolbar.

Toolbars > Drawing and Forms Toggles the display of the Drawing and Forms Toolbar.

Zoom > Percentage Magnifies or shrinks the current view to the percentage indicated.

Command	Description
Formula Bar	Toggles the display of the Formula Bar.
Toolbars > Standard	Toggles the display of the Main Toolbar.
Toolbars > Formatting	Toggles the display of the Formatting Toolbar.
Toolbars > Drawing and Forms	Toggles the display of the Drawing and Forms Toolbar.
Zoom > Percentage	Magnifies or shrinks the current view to the percentage indicated.

Insert Menu

Command Description

Cells Inserts cells at the location of the current selection. Options allow you to choose which cells adjacent to the insertion are shifted to make room for the new cells and to choose to insert entire rows or columns of cells.

Rows Inserts a new row above the selected cell or row. You can insert multiple rows by highlighting the number of rows you want to insert prior to executing this command.

Columns Inserts a new column to the left of the selected cell or column. You can insert multiple Columns by highlighting the number of columns you want to insert prior to executing this command.

Worksheet Inserts a new worksheet before the active worksheet and makes the new worksheet the active one. If more than one worksheet is selected, this command inserts the same number of worksheets as the number selected. This command fails if non-contiguous sheets are selected. You can also insert a new worksheet after the current worksheet while keeping the current worksheet active by pressing the Control key and clicking Insert > Worksheet.

Page Break Places a horizontal page break adjacent to the top edge of the active cell and a vertical page break adjacent to the left edge of the active cell. If a row or column is selected, a page break is placed above the selected row or to the left of the selected column.

Name Displays the Defined Name dialog box, which allows you to replace cell and range references with user-defined cell names. You can also name constants and formulas.

Chart Allows you to insert a chart that plots the data in the selected cells.

Picture Allows you to draw a frame into which you may later insert a picture file.

Drawing Object > Arc Selects the Arc tool which allows you to draw arcs.

Drawing Object > Line Selects the Line tool which allows you to draw lines.

Drawing Object > Oval Selects the Oval tool which allows you to draw ovals.

Drawing Object > Polygon Selects the Polygon tool which allows you to draw polygons.

Drawing Object > Rectangle Selects the Rectangle tool which allows you to draw rectangles.

Forms Object > Button Selects the Button tool which allows you to draw buttons.

Forms Object > Checkbox Selects the Check Box tool which allows you to draw check boxes.

Forms Object > Dropdown Listbox Selects the Drop Down List Box tool which allows you to draw drop-down list boxes.

Cancel Insert Object Allows you to deselect a graphical object tool.

Command	Description
Cells	Inserts cells at the location of the current selection. Options allow you to choose which cells adjacent to the insertion are shifted to make room for the new cells and to choose to insert entire rows or columns of cells.
Rows	Inserts a new row above the selected cell or row. You can insert multiple rows by highlighting the number of rows you want to insert prior to executing this command.
Columns	Inserts a new column to the left of the selected cell or column. You can insert multiple Columns by highlighting the number of columns you want to insert prior to executing this command.
Worksheet	Inserts a new worksheet before the active worksheet and makes the new worksheet the active one. If more than one worksheet is selected, this command inserts the same number of worksheets as the number selected. This command fails if non-contiguous sheets are selected. You can also insert a new worksheet after the current worksheet while keeping the current worksheet active by pressing the Control key and clicking Insert > Worksheet.
Page Break	Places a horizontal page break adjacent to the top edge of the active cell and a vertical page break adjacent to the left edge of the active cell. If a row or column is selected, a page break is placed above the selected row or to the left of the selected column.
Name	Displays the Defined Name dialog box, which allows you to replace cell and range references with user-defined cell names. You can also name constants and formulas.
Chart	Allows you to insert a chart that plots the data in the selected cells.
Picture	Allows you to draw a frame into which you may later insert a picture file.
Drawing Object > Arc	Selects the Arc tool which allows you to draw arcs.
Drawing Object > Line	Selects the Line tool which allows you to draw lines.
Drawing Object > Oval	Selects the Oval tool which allows you to draw ovals.
Drawing Object > Polygon	Selects the Polygon tool which allows you to draw polygons.
Drawing Object > Rectangle	Selects the Rectangle tool which allows you to draw rectangles.
Forms Object > Button	Selects the Button tool which allows you to draw buttons.
Forms Object > Checkbox	Selects the Check Box tool which allows you to draw check boxes.
Forms Object > Dropdown Listbox	Selects the Drop Down List Box tool which allows you to draw drop-down list boxes.
Cancel Insert Object	Allows you to deselect a graphical object tool.

Format Menu

Command Description

Cells Displays the Format Cells dialog box, which allows you to set cell formatting such as numeric display, alignment, fonts, borders, fill patterns, protection, and validation.

Row > Height Displays the Row Height dialog box, which allows you to set the height of the selected rows, specify default row heights, and specify automatic row height.

Row > Hide Hides the selected rows. This does not delete them from the worksheet.

Row > Unhide Shows the hidden rows in a selection.

Row > Default Height Displays the Default Row Height dialog box which allows you to define a default height for rows.

Column > Width Displays the Column Width dialog box, which allows you to set the width of the selected columns, specify default column widths, and specify automatic column width.

Column > Autofit Selection Adjusts the width of the column to accommodate the size of the longest text string or value in the selected cell or range.

Column > Hide Hides the selected columns. This does not delete them from the worksheet.

Column > Unhide Shows the hidden columns in a selection.

Column > Default Width Displays the Default Column Width dialog box, which allows you to define a default width of columns.

Sheet > Properties Displays the Format Sheet dialog box, which allows you to set viewing, editing, selection, color, and other properties for the active worksheet.

Sheet > Enable Protection Enables protection for protected cells in the worksheet. A check next to this command means that protection is enabled. Select the command again to disable protection.

Freeze Panes Freezes or unfreezes the rows above the top selected row and the colums left of the leftmost selected column. Frozen columns and rows do not scroll and cannot be edited. Choose this command again to unfreeze the cells.

Default Font Displays the Default Font dialog box, which allows you to set the default font and the font size used to display data in worksheets. The default font affects the widths of worksheet columns and heights of worksheet rows.

Object Displays the Format Object dialog box, which displays the appropriate tabbed pages for the selected object.

Bring to Front Places the selected object(s) in front of other objects in the worksheet.

Send to Back Places the selected object(s) behind other objects in the worksheet.

Command	Description
Cells	Displays the Format Cells dialog box, which allows you to set cell formatting such as numeric display, alignment, fonts, borders, fill patterns, protection, and validation.
Row > Height	Displays the Row Height dialog box, which allows you to set the height of the selected rows, specify default row heights, and specify automatic row height.
Row > Hide	Hides the selected rows. This does not delete them from the worksheet.
Row > Unhide	Shows the hidden rows in a selection.
Row > Default Height	Displays the Default Row Height dialog box which allows you to define a default height for rows.
Column > Width	Displays the Column Width dialog box, which allows you to set the width of the selected columns, specify default column widths, and specify automatic column width.
Column > Autofit Selection	Adjusts the width of the column to accommodate the size of the longest text string or value in the selected cell or range.
Column > Hide	Hides the selected columns. This does not delete them from the worksheet.
Column > Unhide	Shows the hidden columns in a selection.
Column > Default Width	Displays the Default Column Width dialog box, which allows you to define a default width of columns.
Sheet > Properties	Displays the Format Sheet dialog box, which allows you to set viewing, editing, selection, color, and other properties for the active worksheet.
Sheet > Enable Protection	Enables protection for protected cells in the worksheet. A check next to this command means that protection is enabled. Select the command again to disable protection.
Freeze Panes	Freezes or unfreezes the rows above the top selected row and the colums left of the leftmost selected column. Frozen columns and rows do not scroll and cannot be edited. Choose this command again to unfreeze the cells.
Default Font	Displays the Default Font dialog box, which allows you to set the default font and the font size used to display data in worksheets. The default font affects the widths of worksheet columns and heights of worksheet rows.
Object	Displays the Format Object dialog box, which displays the appropriate tabbed pages for the selected object.
Bring to Front	Places the selected object(s) in front of other objects in the worksheet.
Send to Back	Places the selected object(s) behind other objects in the worksheet.

Tools Menu

Command Description

Recalc Recalculates all open cells, worksheets, and workbooks.

Options Displays the Options dialog box, which allows you to set general, calculation, and color options.

Command	Description
Recalc	Recalculates all open cells, worksheets, and workbooks.
Options	Displays the Options dialog box, which allows you to set general, calculation, and color options.

Window Menu

Command Description

New Window Opens another view of the currently active workbook. All changes made in either view display in both views.

Cascade Arranges all of the open workbooks in a cascade from the upper left to the lower right in the order opened, with the lower right workbook active.

Tile Arranges all of the open workbooks into equally sized windows within the Workbook Designer (like floor tiles) with the lower right workbook active.

Tile Vertical Arranges all of the open workbooks into equally sized side-by-side windows within the Workbook Designer, with the far right workbook active.

Tile Horizontal Arranges all of the open workbooks into equally sized stacked windows within the Workbook Designer with the bottom workbook active.

[workbook name] The names of all the open workbooks are listed as menu options. Clicking a workbook makes it active.

Windows... Opens the Windows dialog, which lists all the open workbooks. Select a workbook and click Activate to make it active, or click Close to close it.

Command	Description
New Window	Opens another view of the currently active workbook. All changes made in either view display in both views.
Cascade	Arranges all of the open workbooks in a cascade from the upper left to the lower right in the order opened, with the lower right workbook active.
Tile	Arranges all of the open workbooks into equally sized windows within the Workbook Designer (like floor tiles) with the lower right workbook active.
Tile Vertical	Arranges all of the open workbooks into equally sized side-by-side windows within the Workbook Designer, with the far right workbook active.
Tile Horizontal	Arranges all of the open workbooks into equally sized stacked windows within the Workbook Designer with the bottom workbook active.
[workbook name]	The names of all the open workbooks are listed as menu options. Clicking a workbook makes it active.
Windows...	Opens the Windows dialog, which lists all the open workbooks. Select a workbook and click Activate to make it active, or click Close to close it.

Help Menu

Command Description

Contents and Index Displays Formula One for Java Designer Help.

About Formula One for Java Displays the About Formula One for Java dialog box which includes the version number, copyright, and other legal information.

Command	Description
Contents and Index	Displays Formula One for Java Designer Help.
About Formula One for Java	Displays the About Formula One for Java dialog box which includes the version number, copyright, and other legal information.

Using the Workbook Designer Menus

Tools Menu Command Description Recalc Recalculates all open cells, worksheets, and workbooks. Options Displays the Options dialog box, which allows you to set general, calculation, and color options.

Help Menu Command Description Contents and Index Displays Formula One for Java Designer Help. About Formula One for Java Displays the About Formula One for Java dialog box which includes the version number, copyright, and other legal information.

Tools Menu

Command Description

Recalc Recalculates all open cells, worksheets, and workbooks.

Options Displays the Options dialog box, which allows you to set general, calculation, and color options.

Help Menu

Command Description

Contents and Index Displays Formula One for Java Designer Help.

About Formula One for Java Displays the About Formula One for Java dialog box which includes the version number, copyright, and other legal information.