Dynamic texts

The Analysis expression category is only available in the context of legend headings and individual diagrams.

The expression category Sheet is only available in the context of objects that are on a sheet (for example, text elements, legend headings).

Here you have access to the properties of the sheet in which the object is located. Since tables, for example, cannot be assigned to a specific sheet, these properties are not available for calculated columns or filters.

Various functions are available to output the current date or format date values.

Here you have access to the properties of the workbook, which you can enter in the properties (Menu File → Properties).

Here you have access to the properties of the workbook, which you can enter in the properties (Menu File -> Properties).

Here you have access to the properties of the sheet in which the object is located.

Here you have access to the properties of the workbook, which you can enter in the properties (Menu File -> Properties).

Returns the name of the table that was used to display the table object.

In this category some functions are offered to work with texts or character strings.

error text

The combination of type '<Type>' and type '<Type>' is not compatible with the '{0}' operator.

explanation

An attempt is made to use an operator to link two values for which this operator is not suitable.

Example:

Multiplication of two character strings.

„3“ * „3“

Correcting the error

Both operands must be converted to the appropriate type, usually a number. The value() conversion function can be used for this purpose.

Value("3")*Value("3")

error text

No matching function with the name '<Function>' found.

explanation

There are two possibilities:

Either a function with this name does not exist because you entered the function name yourself and there is an error in the spelling.

Or the function exists, but is called with an invalid data type.

Example

Wrongly written function.

Aps(-5)

Absolute value with a string as argument.

Abs("-5")

Correcting the error

For the first error situation: Correct the spelling.

For the second error situation: Convert the function argument to the appropriate data type. The conversion function value() can be used for this purpose.

Abs(value("-5"))

error text

The '<Name>' property or variable does not exist.

explanation

Their expression contains parts that do not correspond to constants, functions, or operators.

Maybe it's a typo?

The most common cause, however, might be that you have not limited a string with quotation marks ("quotation marks"), but are using it directly.

Example

ABC+DEF

Correcting the error

Use quotation marks to delimit the strings:

"ABC "+"DEF"

error text

syntax error

explanation

Your printout is not a valid printout.

It could be that their expression simply contains 2 separate expressions.

Example

{3+4 5+6}

Correcting the error

Divide the expression into 2 expressions:

{3+4} {5+6}

The output of this expression would then be 7 11.

error text

A call target has caused an exception error.

explanation

In contrast to the other errors, this error only occurs when their expression has to be evaluated. This can lead to errors that cannot yet be detected when the printout is checked, but only occur during evaluation.

Example

{Value([columnA])}

This expression converts all values from columnA to a number. However, if columnA contains a value that cannot be converted into a number, the error described above occurs.

Correcting the error

In this case, by correcting the data, you must ensure that your printout works with all available data.