The BEEP and ALERT functions of ClarisWorks let you warn users of mistakes they make when using a ClarisWorks spreadsheet or database template.
BEEP sounds the system beep; ALERT sounds the beep and displays an alert box with the message you specify.
For example, the formula :
=IF(A10<0, ALERT("Illegal negative value in Cell A10"),A3*A10)
will display a warning message if cell A10 contains a negative number. Otherwise, this formula displays the product of cells A3 and A10.
Figure 1 contains a ClarisWorks spreadsheet template showing a warning message produced by the ALERT function.
VI. Use ClarisWorks Pane Tools to lock titles on your spreadsheet screen.
ClarisWorks lets you lock the top rows and left-hand columns of your spreadsheet templates as "titles" on the screen. The titles stay on the screen when you scroll around a large worksheet.
ClarisWorks titles go in a separate window "pane" at the top or left side of your screen. (For example, note the separate horizontal pane in Figure 2 that contains the titles at the top of the screen.) You create the pane by dragging the horizontal Pane Tool down the screen to set your titles. You can use the vertical Pane Tool to the right of the Zoom Controls at the bottom of the spreadsheet window to lock columns as titles on the left-hand edge of your screen.
BEEP sounds the system beep; ALERT sounds the beep and displays an alert box with the message you specify.
For example, the formula :
=IF(A10<0, ALERT("Illegal negative value in Cell A10"),A3*A10)
will display a warning message if cell A10 contains a negative number. Otherwise, this formula displays the product of cells A3 and A10.
Figure 1 contains a ClarisWorks spreadsheet template showing a warning message produced by the ALERT function.
VI. Use ClarisWorks Pane Tools to lock titles on your spreadsheet screen.
ClarisWorks lets you lock the top rows and left-hand columns of your spreadsheet templates as "titles" on the screen. The titles stay on the screen when you scroll around a large worksheet.
ClarisWorks titles go in a separate window "pane" at the top or left side of your screen. (For example, note the separate horizontal pane in Figure 2 that contains the titles at the top of the screen.) You create the pane by dragging the horizontal Pane Tool down the screen to set your titles. You can use the vertical Pane Tool to the right of the Zoom Controls at the bottom of the spreadsheet window to lock columns as titles on the left-hand edge of your screen.
VII. Use the NOW function to enter the current date or time in a spreadsheet cell or a database record.
The NOW function of ClarisWorks displays the current date or time in a spreadsheet cell or database record.
In a spreadsheet, enter =NOW() as the formula and set the number format of the cell to display a date or time. In the database environment, define the field as a calculated field, enter the formula NOW(), and select "Date" or "Time" from the "Format result as..." pull-down menu.
Figure 1: