The column properties correspond with the properties of the respective object type, with some table-related restrictions.
Text and RTF text columns are special cases. A column property lets you switch between these two text variations later on. The property list also changes accordingly depending on this property.
Also see chapter "Common Object Properties".
Property |
Description |
Value |
Description |
||
Options |
Opens the "Content" dialog for the relevant object type. |
|
Content dialog |
||
Drilldown links |
Opens the dialog for editing the drilldown links. A drilldown report can also be started from the preview. |
|
Drilldown dialog |
||
Link URL |
Link target (only effective for preview and PDF export). |
Link Formula |
Formula wizard |
||
Save as JPEG (only with pictures) |
Print the image as a JPEG file if possible (not all file types support this option). |
True False Formula |
Yes No Formula wizard |
||
Rotation |
Rotates the object anticlockwise. For example, you can rotate the column title or barcode by 90° with this function. |
0 1 2 3 Formula |
0° 90° 180° 270° Formula wizard |
||
Format |
Please consider that the formatting relates to the result of the entire expression. Use the Date$() and Fstr$() functions in the formula wizard if you only want to format part of the expression (e.g. with text and number within an expression). |
True False |
Dialog |
||
Bar width |
The narrowest bar width in SCM units (1/1000 mm). 0 = automatic adjustment. Not supported by all barcodes. |
Formula |
Formula wizard |
||
|
Orientation |
Orientation of the barcode within the object's frame |
0 1 2 Formula |
Left Centered Right |
|
Bar color (only with barcodes) |
Color of the barcode. |
|
|
||
Bar width ratio (only with barcodes) |
The relationship of the different widths of bars or spaces. Not supported by all barcodes. |
Formula |
Formula wizard |
||
Show text |
This property lets you specify whether the content of the barcode is to be printed as text. |
True False Formula |
Yes No Formula wizard |
||
Background |
The background of the columns. |
|
|
||
Text format |
For presenting the text column differently. |
True False |
Normal text RTF Text |
||
Sort Orders |
Sort orders (ascending+descending) for interactive switching in the preview. Stacked sort orders can be defined via a dialog (requires application support), e.g. the data is first sorted by country, and then according to city/town. Single-tiered sort orders can be selected via the list. |
|
Dialog |
||
Alignment (pictures) |
Describes how the image is to be arranged in the available area. |
0 1 2 3 4 5 6 7 8 9 |
Centered Next to each other (tiled) Left top Left bottom Right top Right bottom Left Right Top Bottom |
||
Vert. Alignment (barcodes) |
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 |
The position of the decimal point within the field, measured from the left edge of the previous frame. |
Number Formula |
Formula wizard |
|
Justified |
Text is aligned to the right and the left (block text). |
True False Formula |
Yes No Formula wizard |
||
Width |
The width of the column. You will get an error message if the sum of the column widths exceeds the total width of the table object. |
Number Formula |
Formula wizard |
||
Fit |
Specifies the behavior if the text is too long for one line. To prevent long words from being truncated with value "1" (wrap), you can use the "Force wrap" option to ensure that a break occurs after the last suitable character. Value "3" (compress) reduces the character spacing and should only be used to a limited extent in order to guarantee legibility. |
0 1 2 3 Formula |
Truncate Wrap Shrink Compress Formula wizard |
||
|
Widow/ Orphan control |
Prevents widow and orphan lines. The last line of a paragraph is referred to as a widow line if it is also the first line of a new column or page. If a new page or column is triggered after the first line of a new paragraph, this line would appear alone at the end of the page or column. In this case, it is referred to as an orphan line. |
True False Formula |
Yes No Formula wizard |
|
|
Force wrap |
If a long word cannot be wrapped, a line break will be forced after the last suitable character. |
True False Formula |
Yes No Formula wizard |
|
Height (not text or RTF text). |
Fixed height of the field, the content is scaled (0: no fixed height). The highest column determines the overall height of a table row. |
Number |
|
||
Fixed height (text or RTF text). |
Fixed height of the field irrespective of the content. Excess text is discarded (0: no fixed height). The highest column determines the overall height of a table row. |
Number |
|
||
Blank Optimization |
Leading and double spaces are removed. |
True False Formula |
Yes No Formula wizard |
||
Line spacing (only with text) |
Spacing between the text lines. |
Number |
|
||
Frame |
Specifies the frame characteristics and margins for the individual table cells. Together with the selected font, the "top" and "bottom" cell margins determine the height of the table rows. |
Number Formula |
Dialog |
||
