INFO Function

image_pdfimage_print

The INFO() function in Jedox Web returns different information than its Excel Add-in counterpart.

The table below shows how the function works in Jedox Web, with its different arguments, a result example, and its purpose:

Function

Result Example

Purpose

=INFO(“numfile”)

3

Shows number of active worksheets in the open workbooks

=INFO(“osversion”)

Windows

Shows name of the host OS

=INFO(“release”)

6.0.4.7814

Shows exact version of Jedox Spreadsheet Server

=INFO(“currentuser”)

admin

Shows name of the user currently logged in

=INFO(“currentlanguage”)

en_US

Shows the language set for the current user

     

Example for =INFO(“usergroups”): Array function in range of 4 cells

{=INFO(“usergroups”)}

designer

Lists the usergroups the current user is part of in an array

{=INFO(“usergroups”)}

sales

{=INFO(“usergroups”)}

marketing

{=INFO(“usergroups”)}

#NV

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...