Select the respective column in the object dialog on the "Cell definition" tab. To select multiple cells, hold down the Ctrl key or you can draw a border around the cells with the mouse.
Property |
Description |
Value |
Description | |
Value |
Formula for the value of the cell. This will be evaluated by the Crosstab.Cells functions. |
Formula |
Formula wizard | |
Displayed contents |
Text to be displayed in the cells. This can differ from the value specified in the "Value" property, e.g. if it is formatted. |
Formula |
Formula wizard | |
Link URL |
Link that is accessed when clicked (only real data preview, PDF or HTML export). Example: file://c:\users\public\x.log or URL |
Link |
Link Formula wizard | |
Rotation |
Rotates the object anticlockwise. For example, you can rotate the column title by 90° with this function.
|
0 1 2 3 Formula |
0° 90° 180° 270° Formula wizard | |
Vert. alignment |
Vertical alignment of the content in the available space. |
0 1 2 Formula |
Top Centered Bottom Formula wizard | |
Alignment (text) |
Text alignment Decimal means that numbers are aligned by their decimal points. |
0 1 2 3 Formula |
Left Centered Right Decimal Formula wizard | |
|
Decimal position |
Position of the decimal point (only valid with decimal alignment, negative means: from the right.) |
Number Formula |
Formula wizard |
Blank Optimization |
Leading and double spaces are removed. |
True False Formula |
Yes No Formula wizard | |
Maximum width |
Specifies the maximum width for a cell. A line break will be triggered if the text is wider. You can use this property in combination with the Join$() function to display the individual values in one cell. |
Number Formula |
Formula wizard | |
Minimum width |
Sets the minimum width for the type of cell. |
Number Formula |
Formula wizard | |
Minimum height |
Sets the minimum height for the type of cell. |
Number Formula |
Formula wizard | |