TEXTFIELD

From iMath
Jump to navigation Jump to search

Syntax

TEXTFIELD ( expression )

Implemented in iMath since version 2.2.0 or earlier.

Up to version 2.2.6 only literal strings are allowed, not string expressions..

Explanation

Access the value of a text field. The expression must be a string expression containing the text field type, e.g. DDE.<dde-name> for a DDE text field or User.<varname> for a user-defined text field. DDE text fields can reference single cells or cell ranges. The text field value is always a string. iMath tries to guess the value type and will create either numbers or strings. If the argument is a cell range, iMath will create a vector filled with the referenced cell values. The vector will be a row or column vector, depending on the cell range. To create a user-defined fields, go to Insert - Fields - More fields and click the Variables tab. Choose type User defined and create your variable in the input boxes below. Click the tick mark to finish. For German users: ooowiki has a good explanation of how to create DDE links.

Example

EQDEF fname = "User.myfield"

EQDEF fval = TEXTFIELD (VAL(fname))

Note that VAL is required here to create a string expression from the variable.

See also

CALCCELL TABLECELL SETTABLECELL SETCALCCELLS