OpenOffice3.org Calc 3. Information Functions

INFO(Text) Function

It allows to kow information related to the computer where it is intalled OpenOffice, software version and another information as the content of the argument. The argument “Text” contanis a text. Indicates information that you want obtained. The different options of the argument “text” is described in the following table:

 

Argument Description

"osversion”

Always returns “Windows (32-bit) NT 5.01”. Option provided for compatibility.

"system”

Returns the operating system they are working: Returns “WNT” if the operating system is Windows. Returns “LINUX” if the operating system is Linux. Returns “SOLARIS” if the operating system is Solaris.

"release”

Identifies the software.

"numfile”

Returns 1. Option provided for compatibility.

"recalc”

Can return one of two possible values: "Automátic” if the setting causes the recalculation of the sheets is automatic. "Manual” If you should have manual recalculation.

 

For example:

=INFO("osversion") Returns “Windows (32-bit) NT 5.01”.

=INFO("system") Returns “WNT”. My computer has Windows operating system.

=INFO("release") Returns “330m20(Build:9567)”.

=INFO("numfile") Returns 1. Always returns this value.

=INFO("recalc") Returns “Automatic”. When changes are made in the leaves, the content is updated automatically.

 

Back to the list of information functions