Cell Format Expression

Attribute CellFormatExpression

The Cell Format Expression attribute, whose identifier is CellFormatExpression, is used for created Computed cell formats, in which the colors, borders, fonts and other properties of a table (usually result table, not as commonly edit tables) are computed, and might be based on the variable's value, the indexes, or even other computed values.

The page on Computed cell formats provides an overview of how you created expressions to compute cell formats.

It is not necessary to use the Cell Format Expression for most cell formatting. Most formatting involves simple, static changes to the table, and can be done using the Cell formats dialog in the Analytica user interface. The [[Cell Format Expression is only used when you want to compute formats using code.

Any formats computed by the Cell Format Expression take precedence over any formats set using the Cell formats dialog.

Setting that are set using the Cell formats dialog are stored in the attribute Att_CellFormat, which is not expected to be edited by a model builder or user.

Showing the Cell Format Expression attribute

Before you can create expressions that compute cell formats, you must make the Cell Format Expression attribute visible. To do this, go to the Attributes dialog on the Object menu, and with the Variable class selected, click on Cell Format Expression to put a check in front.

After doing so. the Cell Format Expression attribute can be edited from the Attribute panel or Object window.

See also

• Computed cell formats
• [[category::Cell format functions|Cell format predicates]]