Cell Format Expression

Revision as of 00:07, 4 March 2017 by Lchrisman (talk | contribs) (Broken links)

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 format 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 format dialog.

Setting that are set using the Cell format 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.

AttributeDlg CellFormatExpression.png

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

See also

Comments


You are not allowed to post comments.