Documentation/How Tos/Calc: INFO function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 04:51, 27 January 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


INFO

Returns information about the current working environment.

Syntax:

INFO(type)

type is a text string which determines the type of information to return:
type information returned
"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
"SOLARIS" for Solaris.
"release" The product release identifier, for example "680m9(Build:9238)".
"numfile" Always 1, for compatibility reasons.
"recalc" The current formula recalculation mode, either "Automatic" or "Manual", or the equivalent in your language (Tools - Options - Language Settings - Language).

Example:

INFO(A1)

if cell A1 shows error Err:518, returns 518.

See also:

Information functions, Spreadsheet functions

Personal tools