Cell Properties	Contents
	Formatting Numbers and Dates
	Row/Col Positioning and Sizing

The cell properties appear in the property area at the bottom left of the editing window when you select a cell, or when you select a cell style in the style panel. Cell styles are cascading. Clearing a value or choosing the special value inherit makes a property undefined, so that it will be taken from the environment instead.

Cell styles are organized int three tabs:

1. Cell:
   The cell properties. It gives information about the cell type, the specific properties for this cell type and its size.
2. Style:
   The style settings of the cell. Spans, etc.
3. Text:
   The properties for fomatting the look of the text. I.e. the font and its size and foreground, background colours. Text formatting.
4. Additional properties that depend on the cell kind appear here.

These are the standard properties of each cell.

Cell Kind:

What kind of cell ist is. Label, text, image etc.

Column Width:

The width of the column where this cell is located in.

Row Height:

The height of the row where this cell is located in.

Visibility:

The OQL formula that controls the visibility of the cell.

Other cell kinds have additional properties. For data cells they are:

Mode:

How the data is displayed. As text or as a type of graphic.

Data:

The data field where the content comes from.

Type:

The data type of the field.

Name:

The name of the style.

Note: The style name is optional. Naming a style causes it to appear in the style panel and in the formatting toolbar. From there it can be applied to other cells. Changing a property of a named style changes the format of all cells that use this style. An unnamed style only affects the cell that it is applied to.

Note: When you are editing a cell and you change a property then it is frequently undesired and unexpected that all cells with the same style change. Therefore ReportsAnywhere makes the change in a local unnamed style, that is based on the named style.

Base:

This specifies the name style that the current style is based on. This means any open properties are first looked for in the base style, before cascading to the environment. Click into the value column to select a base style from the drop down list.

Align Horizontal/Vertical:

This defines how the cell contents are aligned within the cell. Click into the value area to select a setting from the drop down list.

Span Horizontal/Vertical:

This defines whether a cell spans several rows or columns. Enter a value for the span.

Text Type:

This specifies how multi-line text in a cell shall be treated. ReportsAnywhere supports 3 types of text:
Plain, Flow and Html. Plain text displays any newlines that occur in the text as they are.
Flow reflows text to the available width. Any newlines are removed and text is broken at word boundaries.
Html treats the text as formatted text with html markup. ReportsAnywhere uses the built in Html renderer of Java which has some limitations on the html that it can render. However for inline textmarkup it is usualy sufficient.

Breakable

Specifies whether a multi line cell can be split at page boundaries, or whether it is kept together on a single page.

Integer/Float/Date Format

Specifies how whole numbers will be displayed in the cell. It uses Java formatting specifications.

Prefix/Suffix

Allows you to specify a text to appear before or after the cell contents.

The Cell Border

The four toggle buttons around the preview area set the border to the values specified above.

The current setings of the cell border are shown in the preview area at the bottom.

Outer Indent

Specifies the space outside of the painted border line in typograhical points (pt). The indent is painted using the background color from the environment (table/frame/page).

Width

Specifies the width of the painted border line in typograhical points (pt). Choose one of the predefined values from the combo box or enter a floating point value.

Inner Padding

Specifies the space betwen the painted border line and the contents in typograhical points (pt).

Color

Specifies the color of the border.

Style

Please select one of the toggle buttons for the line style.

Instant

Shortcut buttons to set all 4 borders at once, or to remove all borders or to inherit all borders.

Note: The border settings are applied when you press one of the four toggle buttons. To change a border press the toggle buton twice.

Row/Col Positioning and Sizing

Contents

Formatting Numbers and Dates