Errors and Gotchas

When the application receives invalid commands, it may occasionally return errors. If the destination column is text or long text, it displays "#ERROR!" in the cell and sends an application notification. For other destination column types, only an application notification is sent.

1. Formatting with newline

Attempting to use a new line for formatting isn't supported and Formula PRO will display and #ERROR! message in the cell.

Workaround:

Use the CONCAT function to concatenate multiple strings.

1. Attempting to concatenate placeholders by placing them on the same line.

Attempting to concatenate multiple placeholders by placing them on the same line isn't supported and Formula PRO will display and #ERROR! message in the cell.

Workaround:

Use the CONCAT function to concatenate multiple placeholders.

1. Stacking multiple placeholders on top of each other with a new line

Attempting to stack multiple placeholders on top of each other with a new line will return the values of the placeholders in square brackets ([<value>])

1. Leaving a trailing comma at the end of a command

Leaving a trailing comma at the end of a command will result in an error (#ERROR!).