Other functions

The other functions allow for example the interaction with the user by utilising of information dialogs.

Other functions		Syntax
MSGBOX - MELDUNG	opens a information dialog. Example: =MSGBOX("advice text"; 0; "titel text")	MSGBOX(literal text; number [type]; literal [title]) text: Text which is displayed at the information dialog. Type: Type of the information box. From one value group values can be added. For getting a information dialog with the buttons OK und Cancel with the warning icon, it is to deliver the value 33 (so 1+32) . 0 = OK button only 1 = OK and Cancel buttons 2 = Abort, Retry, and Ignore buttons 3 = Yes, No, and Cancel buttons 4 = Yes and No buttons 5 = Retry and Cancel buttons 16 = Critical Message icon 32 = Warning Query icon 48 = Warning Message icon 64 = Information Message icon 0 = First button is default 256 = Second button is default 512 = Third button is default 768 = Fourth button is default Titel: Title text for the title line of the information dialog.
INPUTBOX - EINGABEFELD	Öffnet ein einen Eingabedialog der die Eingabe eines einzeiligen Textes ermöglicht. Der Eingabetext wird bei Betätigen der Schaltfläche OK zurückgegeben. Die Schaltfläche Abbrechen gibt immer eine leere Zeichenkette zurück. Beispiel: =INPUTBOX("Meldungstext"; "Titeltext"; "Textvorbelegung")	INPUTBOX(literal text; [literal title]; [literal text preallocation]; [number xpos]; [number ypos]) Text: Text which is displayed in the enter dialog. Title: Title text for the title line of the information dialog. Text preallocation: Text which is already preallocated before opening the enter dialog. xpos: Position of the enter dialog at the display, starting from the upper left dialog corner to the upper left display corner. ypos: Position of the enter dialog at the display, staring from the upper left dialog corner to the upper left display corner.
FILECHOOSER	Opens a file chooser dialog (javax.swing.JFileChooser) where the user can select a file or a folder. Example: =filechooser("select folder";;; true))"	FILECHOOSER([literal Title]; [literal Folder]; [literal Extension]; [boolean directories]) Title: The title which is displayed in file file chooser dialog. Folder: The default folder which is set after the file chooser dialog opens. Extension: The file chooser dialog only show files with a file extension specified here. Multiple file extensions can be specified using the '|' character. For example .jpg|.gif. directories: If this parameter is set to true, only folders are displayed. The default value is false.
DIRECTORYCHOOSER	Opens a directory chooser dialog (com.odc.eva3.rt.se.form.SDirectoryChooser) where the user can select a folder. Example: =filechooser("select folder";;; true))"	FILECHOOSER([literal Title]; [literal Header]; [literal Folder];) Title: The title which is displayed in file directory chooser dialog. Header: The text which is displayed at the upper body of the directory chooser dialog. Folder: The default folder which is set after the directory chooser dialog opens.
RGB	Creates an RGB object which can be used for example for invoking functions of components. The RGB object retruns a numeric value which represents the RGB color. Beispiel: =RGB(255; 30; 30) Result: 1974015	RGB(number Red; number Green; number Blue) oder RGB(number Color) Red: A value between 0 and 255 which represents the red color part. Green: A value between 0 and 255 which represents the green color part. Blue: A value between 0 and 255 which represents the blue color part. Color: The color value is a decimal integer. This numeric value is equivalent to this one which is created by the RGB object.
EVAL	Evaluates an expression and returns it's result. Beispiel: =EVAL("'Hell' & 'o'") Result: Hello	EVAL(literal Expression) Expression: A string which will be executed as an expression.
NOP	The NOP function did not have own functionallity and no return value, but can contain one or more parameters which will be executed in the parameters order.	NOP([variant Variant]...) Variant: A various amount of parameters wo be processed.
PRINTLN	Prints a text to the console (stdout).	PRINTLN(literal Text) Text: The string to be printed.
READFILE	Allows to read a file from the filsystem or via the http protocoll. Predefined path stataments can also be used. The result value is the text or null if the text could not be read. This function is unsuitable for binary data.	READFILE([literal FileName]; [literal Codepage]; [boolean AllowAskUser]) FileName: The path and file name for the file to be loaded. If this is not specified, a file requester will be opened to the user. If there is only a path specified, the file requester to be opened use this path as default value. Codepage: Specifies the codepage for the document to be loaded. Some mostly reocmmended codepages are: "ISO-8859-1", "UTF-8", "UTF-16", "US-ASCII". Is no codepage be specified, the default operating system one is used. AllowAskUser: If the path statement for the file to be loaded is ambiguous a file dialog is opened. If this parameter is false, the file dialog will not open. (Default value is true)
WRITEFILE	Allows to save text into a file. Predefined path stataments can also be used. This function is unsuitable for binary data.	WRITEFILE([literal FileName]; [literal Text]; [literal Codepage]; [boolean AllowAskUser]) FileName: The path and file name for the file to be saved. If this is not specified, a file requester will be opened to the user. If there is only a path specified, the file requester to be opened use this path as default value. Text: The text to be saved. Codepage: Specifies the codepage for the document to be loaded. Some mostly reocmmended codepages are: "ISO-8859-1", "UTF-8", "UTF-16", "US-ASCII". Is no codepage be specified, the default operating system one is used. AllowAskUser: If the path statement for the file to be loaded is ambiguous a file dialog is opened. If this parameter is false, the file dialog will not open. (Default value is true)

functions