Output functions

imageIf(if_condition, path_true, path_false, type)

Displays the specified image in a cell (overflowing the cell boundaries if necessary).
The parameters are as follows:

if_condition:
If 'if_condition' evaluates to a non-zero value, the 'path_true' image is displayed, otherwise the 'path_false'.
path_true / path_false:
Specify the image file paths. If 'type' is 1, 'path_true' and 'path_false' are assumed to be external disk files, for example:
e:\music_file1.png
if 'type' is 0, 'path_true' and 'path_false' are assumed to be full worksheet paths (in the current workbook) of files inserted with the 'Insert > File' command, for example:
folder1\image_file1.jpg
image_file2.gif
type:
Determines how to interpret the 'path_true' and 'path_false' parameters as explained above.

Images are displayed/re-drawn immediately after all the formulas are evaluated/updated and the updating process is completed.

=imageIf(P251 > 0, "e:\image_file1.png", "e:\image_file2.png", 1)

=imageIf(S10:S120 = 0, "folder1\music_file1.jpg", "image_file2.gif", 0)

messageIf(message, type, if_condition, reference-as-text)

Displays a message box with the specified 'message', the 'OK' and 'Cancel' buttons.

message:
Any text to display.
type:
1 - a message box with 'information' icon; 2 - a message box with the warning icon; 3 - the question icon;
if_condition:
A given message is played only if 'if_condition' evaluates to a non-zero value.
reference (as text):
A text string representing an optional cell/range reference with a full worksheet path; if the parameter is not empty and if you click the 'OK' button in the displayed message box, GS-Calc will jump/scroll to the specified cell/range.

Messages are displayed immediately after all the formulas are evaluated/updated and the updating process is completed. Thus you can use such a function with 'if_condition' set to a fixed value of 1 to signal the end of updating.

=messageIf("need to inspect this cell", 1, isError(folder2\sheet2!P251), "folder2\sheet2!P251")

=messageIf("need to inspect this cells", 1, isError(S120), "S121:S200")

playSoundIf(path, type, if_condition, loops, volume)

Plays mp3 and wav files. The parameters are as follows:

path:
Specifies the path of the file to play; if 'type' is 1, 'path' is assumed to be an external disk file, for example: e:\music_file1.mp3 If 'type' is 0, 'path' is assumed to be a full worksheet path (in the current workbook) of a file inserted with the 'Insert > File' command, for example:
folder1\music_file1.mp3
music_file2.wav
type:
Determines how to interpret the 'path' parameters as explained above.
if_condition:
A given file is played only if the 'if_condition' evaluates to a non-zero value.
loops:
Specifies the number of times a given file is to be played in a loop; if it's -1, it'll be played in an endless loop.
volume:
Specifies the volume for the played *.mp3 file. This can be a relative value from 0 to 100%.

Music files are played immediately after all the formulas are evaluated/updated and the updating process is completed. Thus you can use such a function with 'if_condition' set to a fixed value of 1 to signal the end of updating.

If there are multiple files to play, there are played one after another.
To stop playing, simply press ESC or use the 'Tools > Cancel Update' command (even though updating at this point updating is already successfully completed.

=playSoundIf("e:\music_file1.mp3", 1, true, 1, 40)

=playSoundIf("folder1\music_file1.mp3", 0, true, 100, 80)