Documentation/How Tos/Calc: INFO function

CALC FUNCTIONS

Spreadsheet Functions

< Previous Section

Next Section >

FUNCTIONS

Spreadsheet Lookup functions

• Address
• Choose
• Hlookup
• Index
• Indirect
• Lookup
• Math
• Offset
• Vlookup

Spreadsheet Information functions

• Areas
• Column
• Columns
• Errortype
• Info
• Row
• Rows
• Sheet
• Sheets

Other functions

• Dde
• Hyperlink
• Style

< Previous Page

Next Page >

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("system")

returns WNT on a Windows system, or other text on other operating systems as above.

Template:Documentation/SeeAlso