Table properties

The Properties collection on the Table object contains a collection of Property objects. Each property consists of a name and value and controls a table option, such as what to display for percentage values that are rounded to zero. The table properties automatically take their values from the corresponding properties in the Document.Default.Properties collection. This means that you can set up default properties for all new tables and optionally overwrite one or more of them on individual tables. Changing the default properties does not change the properties of tables that have already been created.

Rounding anomalies mean that row and column percentages created from single response variables do not always add up to 100%. This property has a Boolean value that controls whether the rounding of row and column percentages is to be adjusted so that they add up to 100%. See Rounding for more information.

Defines the specification for the base element that the Table Object Model automatically adds to tables with no base. This enables you to change the label, hide the autobase, or base it on an expression.

Controls whether the Table Object Model automatically adds an unweighted base element to all weighted tables. For more information, see Base element.

Defines the specification for the unweighted base element that the Table Object Model automatically adds to weighted tables. This enables you to change the label, hide the autobase, or base it on an expression.

Specifies a minimum value for the base. No results are displayed in cells where the base is below this value. If there are multiple bases in an axis because of nesting or because additional bases have been specified, the nearest base to the cell is used to determine the cell’s suppression state.

Additional options for use when specifying a minimum base value. Multiple options can be combined by adding the values together. See following table for details of individual options.

Specifies a symbol to display instead of the result when a cell value is suppressed because the base is below the minimum specified in MinBase.

Defines the default rounding options. A value of 0 means round 0.5 to even; a value of 1 means round 0.5 up (away from 0). Refer to the “RoundOptions” topic in the UNICOM Intelligence Developer Documentation Library for more information.

Defines one or more characters that are used to represent count values that have been rounded to zero. The value can be any text string.

Defines one or more characters that are used to represent values that have been rounded to zero for cell contents that are not counts or percentages. The value can be any text string.

Defines one or more characters that are used to represent percentage values that have been rounded to zero. The value can be any text string.

Defines one or more characters that are used to represent zero count values in table cells. The value can be any text string.

Defines one or more characters that are used to represent zero values in cell contents that are not counts or percentages. The value can be any text string.

Defines one or more characters that are used to represent zero percentage values in table cells. The value can be any text string.

▪Setting the value of any of the zero symbol properties to an empty string “switches off” that symbol, so that the numeric value is shown instead with the required number of decimal places. However, you can set the value to a space character to set the symbol to a blank space.

▪To reduce confusion, do not use for the zero symbols any of the 52 characters that are used for the column IDs in the statistical tests. The column IDs are the alphabetic characters in uppercase and lowercase (A–Z and a–z). Instead, use non-alphabetic characters or other text strings.