Difference between revisions of "Cell Format Expression"
(created) |
m (Broken links) |
||
| Line 5: | Line 5: | ||
The page on [[Computed cell formats]] provides an overview of how you created expressions to compute cell formats. | 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 | + | 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 | + | 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 | + | 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 == | == Showing the Cell Format Expression attribute == | ||
| Line 21: | Line 21: | ||
== See also == | == See also == | ||
* [[Computed cell formats]] | * [[Computed cell formats]] | ||
| − | * [[category | + | * [[Cell format dialog]] |
| + | * [[:category:Cell format functions|Cell format functions (predicates)]] | ||
Revision as of 00:07, 4 March 2017
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.
After doing so. the Cell Format Expression attribute can be edited from the Attribute panel or Object window.
Enable comment auto-refresher