Documentation/Calc Functions/INFO

Function name:
INFO

Category:
Information

Summary:
Provides requested information about Calc's current operating environment.

Syntax:
INFO(Text)

Returns:
Returns a value whose type depends on the nature of the information requested.

Arguments:
Text is a text string, or a reference to a cell containing a text string, that determines the type of information to be returned. Text is case-insensitive and must correspond to one of the following permitted options – "DIRECTORY", "MEMAVAIL", "MEMUSED", "NUMFILE", "ORIGIN", "OSVERSION", "RECALC", "RELEASE", "SYSTEM", or "TOTMEM". More detail about each of these options is given in the table below.


 * If Text does not correspond to one of the expected strings, then INFO reports an invalid argument error (Err:502).
 * The five strings "directory", "memavail", "memused", "origin", and "totmem" are recognised by INFO because they are listed in the ODF 1.2 description of the INFO function. However, they each lead to a return value of #N/A to indicate the unavailability of the relevant information.

Additional details:

 * INFO is a volatile function. This means that Calc will update the string or value returned by INFO when any cell is updated by selecting or pressing "F9", or on any input event.

Examples:
The following examples have been generated running a copy of LibreOffice Community with the following version information:


 * Version: 7.2.4.1 (x64) / LibreOffice Community
 * Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
 * CPU threads: 6; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
 * Locale: en-GB (en_GB); UI: en-US
 * Calc: CL

You can check your version information on the dialog.

Related LibreOffice functions:
CELL

ODF standard:
Section 6.13.13, part 2

Equivalent Excel functions:
INFO