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 | array
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_text | Returns |
|---|---|
"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. |
"timezone" | The timezone of the workbook. |
"timezones" | The list of all available timezones. |
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, a number for "numfile" or the list of supported timezones.
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
| Formula | Result | Comment |
|---|---|---|
=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") | 3 | Workbook has 3 sheets |
=INFO("recalc") | "Automatic" | Always automatic in IronCalc |
=INFO("timezone") | "Australia/Hobart" | If you happen to be in Tasmania, Australia |
=INFO("timezones") | (...) | A long list of the timezones supported by your system |
Links
- Visit Microsoft Excel's INFO function page.
- LibreOffice Calc also provides a version of the INFO function.