Table cells and table sheet cells are selected in the same way. Table heading and sidehead are identical to headers of columns and rows of regular report table sheet.
NOTE. Working with selected range is available only in the edit mode of the report.
When the Deny Selection checkbox is selected in the Protection group of elements of the Other tab, the cell becomes unselectable on opening the report in the view mode. The context menu for this cell will not be called.
Cell selection methods:
NOTE. To navigate by cells of the selected range, use the ENTER key. In this case the contour of the selected range is kept.
A fill marker is a square marker at the corner of the selected range or single cell contour.
Depending on the chosen cell selection method, fill marker may be positioned differently:
On selecting a range or a single cell, fill marker is located at the bottom right corner:
On selecting one or several columns, fill marker is located at the top right corner:
On selecting one or several rows, fill marker is located at the bottom left corner:
Put the cursor over the border of selected range contour. The cursor will look as a pointer - .
Hold down the mouse button and drag the selected range to the required table area.
NOTE. On moving the selected range to any merged cell a warning appears. Moving is cancelled.
Put the cursor over the border of the selected range contour and hold down the CTRL key. The cursor will look as a pointer - .
Hold down the mouse button and drag the selected range to the required table area.
NOTE. On copying the selected range to any merged cell a warning appears. Copying is cancelled.
On executing the specified actions the following is copied from the selected range along with data:
Cell formatting:
Color of table cell background.
Color of table cell borderline.
Type of table cell borderline.
Thickness of table cell borderline.
Format of displaying table cell data.
Table cell text font.
Horizontal alignment of cell text.
Cell hyperlink parameters.
Format of displaying cell data taking into account the current system localization and regional parameter settings.
Text indents in table cell (in millimeters).
Table cell background pattern.
Color of table cell background pattern.
Vertical alignment of table cell text.
Method of text wrapping in table cells.
Merge selected table cells into one cell.
Formulas set in cells' address. Formulas are automatically corrected on executing operations with selected ranges. To cancel automatic correction on executing operations, use the $ character in cell address that prevents the corresponding formula part from changing.
See also:
Working with Interactive Table Features | Cell Autofill with Data | Features of Cell Value Input