Difference between revisions of "Documentation/How Tos/Calc: INFO function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
Line 36: Line 36:
 
|}
 
|}
 
</blockquote>
 
</blockquote>
 +
<br style="clear:both;" />
  
 
=== Example: ===
 
=== Example: ===
<tt>'''INFO(A1)'''</tt>
+
<tt>'''INFO("system")'''</tt>
: if cell A1 shows error <tt>'''Err:518'''</tt>, returns <tt>'''518'''</tt>.
+
: returns <tt>'''WNT'''</tt> on a Windows system, or other text on other operating systems as above.
  
 
=== See also: ===
 
=== See also: ===
 
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''',
 
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''',
 
'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]'''
 
'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]'''
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 13:09, 13 September 2008


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.

See also:

Information functions, Spreadsheet functions

Functions listed alphabetically, Functions listed by category

Personal tools