Appearance

INFO function ​

Overview ​

INFO returns information about the current operating environment and the workbook.

Language note

The type_text argument is always in English, regardless of the workbook's locale or the user's display language. See Regional Settings for more details.

Usage ​

Syntax ​

INFO(type_text) => text | number

Argument descriptions ​

  • type_text (text, required). A string specifying which type of environment information to return. Always written in English. See the table of supported values below.

Supported type_text values ​

type_textReturns
"numfile"The number of worksheets in the current workbook.
"recalc"The current recalculation mode. IronCalc always returns "Automatic".
"release"The version of IronCalc as a text string.
"system"The name of the operating environment: "browser" in the web app, or the OS name (e.g. "linux", "windows", "macos") in other contexts.

The following type_text values are recognized but not yet implemented and return a #N/IMPL! error: "directory", "origin", "osversion".

Case-insensitive

The type_text argument is case-insensitive. "release", "RELEASE", and "Release" all work the same way.

Returned value ​

INFO returns a text string, or a number for "numfile".

Error conditions ​

  • If the wrong number of arguments is supplied, INFO returns the #ERROR! error.
  • If type_text is not a recognized string, INFO returns the #VALUE! error.
  • If type_text is one of the unimplemented values ("directory", "origin", "osversion"), INFO returns the #N/IMPL! error.

Examples ​

FormulaResultComment
=INFO("release")"v0.7.1-202-g847240b0"IronCalc version (example; actual output depends on the build and may include a leading v and additional suffixes)
=INFO("system")"browser"Running in the web app
=INFO("numfile")3Workbook has 3 sheets
=INFO("recalc")"Automatic"Always automatic in IronCalc