Gobe Productive User's Guide - Miscellaneous Functions

- Working in the spreadsheet environment
- Formatting cells
- Row & column sizes
- Number formats
- Insert, Delete, Move & Go to Cells
- Locking cells
- Filling cells
- Sorting cells
- Calculating cells & Dependent cells
- Formulas & functions
- Function reference
- Creating a chart
- Working with charts
- Styles
- Named selections
- Display options
- Spell checking
- Writing tools
- Views & layers
- Working with spreadsheet frames

# Miscellaneous Functions

ALERT | BEEP | LAUNCH | SYSTEM

Miscellaneous functions handle some actions used in special formulas and evaluations.

## ALERT

> Displays a standard dialog box with he text given. Clicking the OK button closes the dialog box.

> ### Syntax

> ALERT( text-expression )

> ### Arguments

> text-expression | Text to display in the alert dialog box.

> ### Example

> ALERT ("Thank you for using Gobe Productive.")

> When evaluated, displays a dialog box with the text above.

## BEEP

> Beeps the computer's speaker.

> ### Syntax

> BEEP( )

> ### Arguments

> none

> ### Example

> BEEP ()

## LAUNCH

> This function executes a shell command line and returns the output of the script or program. This function is identical to SYSTEM except that it executes the command asynchronously and does not return any output from the command.

> ### Syntax

> LAUNCH( command, {command-input} )

> ### Arguments

> command | Command line to execute.
> command-input | Standard input to pass to the executing command.

> ### Example

> LAUNCH( "/boot/apps/CDPlayer" )

> Launches the CDPlayer application located in the /boot/apps directory.

## SYSTEM

> This function executes a shell command line and returns the output of the script or program. The output is returned as text. The optional parameter is used for standard input to the shell command.

> ### Syntax

> SYSTEM( command, {command-input} )

> ### Arguments

> command | Command line to execute.
> command-input | Standard input to pass to the executing command.

> ### Example

> SYSTEM( "ls /boot" )

> Returns a stream of text listing the contents of the boot drive.

Copyright © 1999, Gobe Software, Inc