INFO


Description Returns the specified type of information about the current workbook and system.

Syntax INFO (info_type)
Argument Description
info_type The type of information you want. It must be text, surrounded by quotation marks. The following are the valid entries and the types of information they return, in alphabetical order:
  "author" Returns #N/A.
  "creation-date" Returns #N/A.
  "editing-time" Returns #N/A.
  "dbreturncode" Returns #N/A.
  "dbdrivermessage" Returns #N/A.
  "dbrecordcount" Returns #N/A.
  "directory" Returns the path of the current directory or folder.
  "last-revision-by" Returns #N/A.
  "last-revision-date" Returns #N/A.
  "macro-step" Returns No.
  "macro-trace" Returns No.
  "memavail" Returns the amount of memory available, in bytes.
  "memused" Returns the amount of memory being used for data.
  "mode" Returns 1.
  "numfile" Returns #N/A.
  "origin" Returns #N/A.
  "osreturncode" Returns 0.
  "osversion" Returns the current operating system version as text.
  "recalc" Returns the current recalculation mode: either Automatic or Manual.
  "release" Returns the release number of the version of Formula One for Java you are using, as text.
  "setup-user-name" Returns #N/A.
  "screen-height" Returns #N/A.
  "screen-width" Returns #N/A.
  "selection" Returns #N/A.
  "selection-part" Returns #N/A.
  "selection-type" Returns #N/A.
  "system" Returns the name of the operating system as text.
  "totmem" Returns the total memory available, including memory in use, in bytes.
  "windir Returns #N/A.
  "worksheet-number" Returns the identification number of the current worksheet.
  "worksheet-size" Returns #N/A.

Remarks This function is included in Formula One for Java in order to be compatible with Excel, which in turn included it in order to be compatible with other worksheet formats, notably Lotus 1-2-3.

Developers will find it more efficient to extract this type of information using Java direct calls.

Example This function returns 7.0:

INFO("release")

See Also CELL