Information

  • CELL information of type about cell
  • COUNTBLANK the number of blank cells in range
  • ERROR the error with the given name
  • ERROR.TYPE the type of error
  • EXPRESSION expression in cell as a string
  • GET.FORMULA the formula in cell as a string
  • GET.LINK the target of the hyperlink attached to cell as a string
  • GETENV the value of execution environment variable name
  • INFO information about the current operating environment according to type
  • ISBLANK TRUE if value is blank
  • ISERR TRUE if value is any error value except #N/A
  • ISERROR TRUE if value is any error value
  • ISEVEN TRUE if n is even
  • ISFORMULA TRUE if cell contains a formula
  • ISLOGICAL TRUE if value is a logical value
  • ISNA TRUE if value is the #N/A error value
  • ISNONTEXT TRUE if value is not text
  • ISNUMBER TRUE if value is a number
  • ISODD TRUE if n is odd
  • ISREF TRUE if value is a reference
  • ISTEXT TRUE if value is text
  • N text converted to a number
  • NA the error value #N/A
  • TYPE a number indicating the data type of value

CELL

CELL information of type about cell

Synopsis

CELL(type,cell)

Arguments

type: string specifying the type of information requested

cell: cell reference

Description

type specifies the type of information you want to obtain:

address Returns the given cell reference as text.

col Returns the number of the column in cell.

color Returns 0.

contents Returns the contents of the cell in cell.

column Returns the number of the column in cell.

columnwidth Returns the column width.

coord Returns the absolute address of cell.

datatype same as type

filename Returns the name of the file of cell.

format Returns the code of the format of the cell.

formulatype same as type

locked Returns 1 if cell is locked.

parentheses Returns 1 if cell contains a negative value

and its format displays it with parentheses.

prefix Returns a character indicating the horizontal

alignment of cell.

prefixcharacter same as prefix

protect Returns 1 if cell is locked.

row Returns the number of the row in cell.

sheetname Returns the name of the sheet of cell.

type Returns "l" if cell contains a string,

"v" if it contains some other value, and

"b" if cell is blank.

value Returns the contents of the cell in cell.

width Returns the column width.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

INDIRECT.

COUNTBLANK

COUNTBLANK the number of blank cells in range

Synopsis

COUNTBLANK(range)

Arguments

range: a cell range

Microsoft Excel Compatibility

This function is Excel compatible.

See also

COUNT.

ERROR

ERROR the error with the given name

Synopsis

ERROR(name)

Arguments

name: string

See also

ISERROR.

ERROR.TYPE

ERROR.TYPE the type of error

Synopsis

ERROR.TYPE(error)

Arguments

error: an error

Description

ERROR.TYPE returns an error number corresponding to the given error value. The error numbers for error values are:

#DIV/0! 2

#VALUE! 3

#REF! 4

#NAME? 5

#NUM! 6

#N/A 7

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISERROR.

EXPRESSION

EXPRESSION expression in cell as a string

Synopsis

EXPRESSION(cell)

Arguments

cell: a cell reference

Note

If cell contains no expression, EXPRESSION returns empty.

See also

TEXT.

GET.FORMULA

GET.FORMULA the formula in cell as a string

Synopsis

GET.FORMULA(cell)

Arguments

cell: the referenced cell

OpenDocument Format (ODF) Compatibility

GET.FORMULA is the OpenFormula function FORMULA.

See also

EXPRESSION, ISFORMULA.

GET.LINK

GET.LINK the target of the hyperlink attached to cell as a string

Synopsis

GET.LINK(cell)

Arguments

cell: the referenced cell

Note

The value return is not updated automatically when the link attached to cell changes but requires a recalculation.

See also

HYPERLINK.

GETENV

GETENV the value of execution environment variable name

Synopsis

GETENV(name)

Arguments

name: the name of the environment variable

Note

If a variable called name does not exist, #N/A! will be returned. Variable names are case sensitive.

INFO

INFO information about the current operating environment according to type

Synopsis

INFO(type)

Arguments

type: string giving the type of information requested

Description

INFO returns information about the current operating environment according to type:

memavail Returns the amount of memory available, bytes.

memused Returns the amount of memory used (bytes).

numfile Returns the number of active worksheets.

osversion Returns the operating system version.

recalc Returns the recalculation mode (automatic).

release Returns the version of Gnumeric as text.

system Returns the name of the environment.

totmem Returns the amount of total memory available.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

CELL.

ISBLANK

ISBLANK TRUE if value is blank

Synopsis

ISBLANK(value)

Arguments

value: a value

Description

This function checks if a value is blank. Empty cells are blank, but empty strings are not.

Microsoft Excel Compatibility

This function is Excel compatible.

ISERR

ISERR TRUE if value is any error value except #N/A

Synopsis

ISERR(value)

Arguments

value: a value

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISERROR.

ISERROR

ISERROR TRUE if value is any error value

Synopsis

ISERROR(value)

Arguments

value: a value

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISERR, ISNA.

ISEVEN

ISEVEN TRUE if n is even

Synopsis

ISEVEN(n)

Arguments

n: number

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISODD.

ISFORMULA

ISFORMULA TRUE if cell contains a formula

Synopsis

ISFORMULA(cell)

Arguments

cell: the referenced cell

OpenDocument Format (ODF) Compatibility

ISFORMULA is OpenFormula compatible.

See also

GET.FORMULA.

ISLOGICAL

ISLOGICAL TRUE if value is a logical value

Synopsis

ISLOGICAL(value)

Arguments

value: a value

Description

This function checks if a value is either TRUE or FALSE.

Microsoft Excel Compatibility

This function is Excel compatible.

ISNA

ISNA TRUE if value is the #N/A error value

Synopsis

ISNA(value)

Arguments

value: a value

Microsoft Excel Compatibility

This function is Excel compatible.

See also

NA.

ISNONTEXT

ISNONTEXT TRUE if value is not text

Synopsis

ISNONTEXT(value)

Arguments

value: a value

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISTEXT.

ISNUMBER

ISNUMBER TRUE if value is a number

Synopsis

ISNUMBER(value)

Arguments

value: a value

Description

This function checks if a value is a number. Neither TRUE nor FALSE are numbers for this purpose.

Microsoft Excel Compatibility

This function is Excel compatible.

ISODD

ISODD TRUE if n is odd

Synopsis

ISODD(n)

Arguments

n: number

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISEVEN.

ISREF

ISREF TRUE if value is a reference

Synopsis

ISREF(value,…)

Arguments

value: a value

Description

This function checks if a value is a cell reference.

Microsoft Excel Compatibility

This function is Excel compatible.

ISTEXT

ISTEXT TRUE if value is text

Synopsis

ISTEXT(value)

Arguments

value: a value

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISNONTEXT.

N

N text converted to a number

Synopsis

N(text)

Arguments

text: string

Note

If text contains non-numerical text, 0 is returned.

Microsoft Excel Compatibility

This function is Excel compatible.

NA

NA the error value #N/A

Synopsis

NA()

Microsoft Excel Compatibility

This function is Excel compatible.

See also

ISNA.

TYPE

TYPE a number indicating the data type of value

Synopsis

TYPE(value)

Arguments

value: a value

Description

TYPE returns a number indicating the data type of value:

1 = number

2 = text

4 = boolean

16 = error

64 = array

Microsoft Excel Compatibility

This function is Excel compatible.