Documentation/Calc Functions/INFO

    From The Document Foundation Wiki
    Other languages:


    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.

    Description of valid Text argument strings
    Text argument Return value
    "directory" Always returns #N/A.
    "memavail" Always returns #N/A.
    "memused" Always returns #N/A.
    "numfile" Always returns the number 1, for compatibility reasons.
    "origin" Always returns #N/A.
    "osversion" Always returns "Windows (32-bit) NT 5.01", for compatibility reasons.
    "recalc" Calc's current formula recalculation mode. Either "Automatic" or "Manual".
    "release" The product release identifier. For example, "27d75539669ac387bb498e35313b970b7fe9c4f9".
    "system" The type of the operating system. One of:
    • "AIX" for Advanced Interactive Executive IBM computer operating systems
    • "ANDROID" for Google mobile operating system
    • "DRAGONFLY" for DragonFly operating system forked from FreeBSD
    • "EMSCRIPTEN" for browser WebAssembly system
    • "FREEBSD", "OPENBSD", or "NETBSD" for operating systems based on the Berkeley Software Distribution (BSD)
    • "HAIKU" for BeOS compatible operating system
    • "iOS" for Apple mobile operating system
    • "LINUX" for GNU/Linux based operating systems
    • "MACOSX" for Apple Mac OS X
    • "SOLARIS" for Oracle Solaris operating system
    • "WNT" for Microsoft Windows
    "totmem" Always returns #N/A.
    • 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 Data ▸ Calculate ▸ Recalculate 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 Help ▸ About LibreOffice dialog (LibreOffice ▸ About on macOS).

    Formula Description Returns
    =INFO("numfile") Here the function always returns a fixed number for compatibility. 1
    =INFO("OSVERSION") Here the function always returns a fixed string for compatibility. "Windows (32-bit) NT 5.01"
    =INFO("recalc") Here the function returns either "Automatic" or "Manual". "Automatic"
    =INFO("release") Here the function returns the LibreOffice product release identifier. "27d75539669ac387bb498e35313b970b7fe9c4f9"
    =INFO(D5) where cell D5 contains the string "system". Here the function returns the type of the operating system. "WNT"

    Related LibreOffice functions:

    CELL

    ODF standard:

    Section 6.13.13, part 2

    Related (or similar) Excel functions:

    INFO