Sys CellAlignmentHybridDefault
New to Analytica 6.4
This system variable holds a bit field that determines which data types are right or left aligned in table cells. This is only used when the 'Default' horizontal cell alignment is used.
In most cases, numbers usually display better in a table when they are right-aligned in cells, whereas for textual content left-alignment is usually preferred. Because the same alignment setting results in two different alignments in different cells, it is an example of hybrid alignment.
By changing this system variable, you can change the global behavior in the default case. This won't impact tables (or table cells) that have the cell alignment explicitly specified. It would be unusual for you to change this, but it is possible. The primary reason it exists is because the defaults were changed in Analytica 6.4, so this provides a way to configure a legacy model to behave the same after upgrading to Analytica 6.4.
The value
The value of this system variable is a bit field in which a subset of the following values are added together:
- 1 = Numbers
- 2 = Dates and times
- 4 = Single-line text
- 8 = Multi-line text
- 16 = Nulls
- 32 = Handles
- 1024 = Other
The bits that appear determine which data types are right-aligned. The bits that do not appear are the data types that are left-aligned.
Legacy settings
In Analytica 6.4 the default is 19 = 1+2+16. I.e., all textual items are left-aligned regardless of whether they are single-line or multi-line.
In Analytica 6.3 this system variable doesn't exist, so cannot be configured, but the equivalent setting is 2047-8 = 2039 (everything except multi-line text is right-aligned).
To configure a legacy model to have the same alignment behavior in Analytica 6.4 as it had in Analytica 6.4, follow these steps:
- Press F12 to open the Typescript window
- Type:
Sys_CellAlignmentHybridDefault := 2039
The one case where you might want to do this is when your model does a lot of customized number formatting, where you have your own UDFs that convert numbers to text and then you display these text values in your tables. Since the value being displayed is single-line text, Analytica 6.3 would right-align (as you would normally want for a number), whereas Analytica 6.4's default would left-align. Hence, you might in that rare and esoteric case prefer for the default to right-align single-lined text.
If your model does something like this in only a couple tables, you might find it preferable to leave this default alone and simply customize the alignment on the few tables that have unusual needs. Do this from the Cell format dialog. You will probably find the Analytica 6.4 to be an improvement even where it is slightly different.
Enable comment auto-refresher