Table cell

The Table Cell control represents an individual cell within a Table.

Table cell

In general, the table cell control's properties are similar to the properties of the Label control.

In the Property Grid, the table cell's properties are divided into the following groups.

Appearance

Property Description
Background Color Specifies the background color for the control.
Borders, Border Color, Border Dash Style, Border Width Specify border settings for the control.
Font Specifies the font settings for the control.
Foreground Color Specifies the text color for the control.
Formatting Rules Opens the Formatting Rules Editor, allowing you to choose which rules should be applied to the control during report generation, and define the precedence of the applied rules. To learn more on this, see Conditionally change a control's appearance.
Padding Specifies indent values which are used to render the contents of a Label.
Style Priority Allows you to define the priority of various style elements (such as background color, border color, etc.). For more information on style inheritance, see Understand styles concepts.
Styles This property allows you to define odd and even styles for the control, as well as to assign an existing style to the control (or a newly created one). For more information on style inheritance, see Understand styles concepts.
Text Alignment Allows you to change the alignment of the control's text.
Text Trimming Allows you to set the trimming behavior employed when text overflows the check box area.

Behavior

Property Description
Angle Specifies the rotation angle of a cell's text. The measurement unit is a degree, and the orientation is counter-clockwise. Since standard HTML does not support text orientation, this parameter is ignored when a report is displayed within a web page.
Can Grow When this property is set to Yes, a cell's height can be automatically increased, if required, to display the text. If there are other controls below the current cell, they will be pushed down to prevent them from overlapping. Note that if a control overlaps the growing cell by even one pixel, it will not be pushed down by the growing cell.
Can Shrink When this property is set to Yes, and the text does not completely fill a cell, then the cell's height will be decreased to the height of its text. If there are other controls below the current cell, they will be moved up to fill the gap. Note that if a control overlaps the shrinking cell by even one pixel, it will not be pushed up by the shrinking cell.
Keep Together Specifies whether the contents of a cell can be horizontally split across pages. In other words, if a cell occupies more space than remains on the page, this property specifies whether this cell should be split between the current page and the next, or whether it will be printed entirely on the next page. This property is in effect only when a cell's content does not fit on the current page. If it does not fit on the next page either, then the cell will be split despite this property's value.
Multiline When this property is set to Yes, a cell processes newline characters found in the text to start a new line. For example, when editing a cell's text, you can insert a new line by pressing ENTER, and in this case the Multiline property will be automatically set to Yes.
Process Duplicates Mode Determines the control's behavior when its data source contains consecutive repeating records. They can be processed as is (when the property is set to Leave), suppressed except for the first entry (Suppress) and suppressed with the blank space printed instead of the repeated records (Suppress and Shrink).
Process Duplicates Target Specifies whether to process duplicate values of the XRControl.Text, or XRControl.Tag property.
Process Null Values Determines whether to process Null (blank) values if they appear in the control's data source. They can be processed as is (when the property is set to Leave), suppressed (Suppress) and suppressed with the blank space printed instead of the blank records (Suppress and Shrink).
Row Span Specifies the number of rows in the XRTable control that the cell spans.
Scripts This property contains events, which you can handle with the required scripts. For more information on scripting, see Handle events via scripts.
Visible Specifies whether the control should be visible in Print Preview.
Word Wrap When this property is set to Yes, text entered into the multiline cell is wrapped to the next line if it doesn't fit the line or comes across a newline character. If this property is set to No, text entered into the multiline cell will be displayed on the same line until a newline character is entered.

Data

Property Description
(Data Bindings) This property allows you to bind some of a cell's properties (Bookmark, NavigateURL, Tag and Text) to a data field obtained from the report's data source, and to apply a format string to it.
Lines Provides access to the Text property of a cell in the Multiline mode.
Null Value Text Determines the text that is displayed if the label is bound to an empty data field.
Summary

Allows you to perform calculations (summary, max, min, average, etc.) over a data field. For more information on calculating summaries, see Add totals to a report.

Note: Summarization is possible for a single data column only. To perform calculations with several data fields, use calculated fields.

Tag This property allows you to add some additional information to the control; for example its id, by which it can then be accessible via scripts. The Tag property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and in the Tag.Binding drop-down selector, select the required data field.
Text

Allows you to define a line of static text to be displayed. When a cell is selected in the designer, you may simply start typing the text, and it will be automatically entered into the in-place editor.

Text property

To type several lines of text, use the Lines property. The Text property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property, and in the Text.Binding drop-down selector, select the required data field.

Xlsx Format String Specifies the native XLSX format string for the control's content, which is to be preserved when the report is being exported to XLSX. This format string is independent from the general value formatting.

Design

Property Description
(Name) Determines a control's name, by which it can be accessed in the Report Explorer, Property Grid or via scripts.

Layout

Property Description
Width Specifies the cell's width, in report measurement units.
Snap Line Margin Specifies the margin (in report measurement units), which is to be preserved around the control when it is aligned using Snap Lines, or when other controls are aligned next to it.

Navigation

Property Description
Bookmark, Parent Bookmark These properties are intended for the creation of a hierarchical structure within a report called a document map. For an explanation and help, see Add bookmarks. The Bookmark property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and in the Bookmark.Binding drop-down selector, select the required data field.
Navigate URL and Target Use the Navigate URL property to specify a URL for web browser navigation when a user clicks on a cell. The web browser displays a page in a window or a frame as specified by the Target property. Note that a URL should have an appropriate prefix (e.g. "http://"). You can create cross-references within the report by assigning the name of the target control to the Navigate URL property, and setting the Target property to "_self". For more information, see Create hyperlinks. The Navigate URL property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and in the Navigate URL.Binding drop-down selector, select the required data field.