Cell Properties

combit List & Label Designer

combit List & Label

Cell Properties

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