Documentation/Calc Functions/INFO

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

INFO

Category:

Information

Summary:

Returns specific information about the current working environment. The function receives a single text argument and returns data depending on that parameter.

Syntax:

INFO("Type")

Returns:

Arguments:

The following table lists the values for the text parameter Type and the return values of the INFO function.

Value for "Type" Return value
"osversion" Always "Windows (32-bit) NT 5.01", for compatibility reasons
"system" The type of the operating system.

"WNT" for Microsoft Windows
"LINUX" for Linux
"MACOSX" for macOS
"SOLARIS" for Solaris

"release" The product release identifier, for example "300m25(Build:9876)"
"numfile" Always 1, for compatibility reasons
"recalc" Current formula recalculation mode, either "Automatic" or "Manual" (localized into LibreOffice language)

Other spreadsheet applications may accept localized values for the Type parameter, but LibreOffice Calc will only accept the English values.

Additional details:

Examples:

=INFO("release") returns the product release number of the LibreOffice in use.

=INFO(D5) with cell D5 containing a text string system returns the operation system type.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: