Cell Autofill with Data

NOTE. Autofill is available, if report is in the edit mode, not in the view mode. The Dashboards tool enables the user to autofill if data editing is enabled. Autofill is available only in the Dashboards, Analytical Queries (OLAP), Time Series Analysis, Reports tools in the desktop application, and Modeling and Forecasting in the web application.

This option fills cells without changing source data.

To fill cells without changing source data:

By means of the mouse:

Hover the cursor over fill marker of the selected range and hold down the CTRL key. The cursor will look as a pointer - .
Hold down the mouse button and move the cursor to the required table area.

Using the Autofill button in the web application or the Autofill button in the desktop application:

Hover the cursor over fill marker of the selected range. The cursor will look as a pointer - .
Hold down the mouse button and move the cursor to the required table area. The button appears in the bottom right corner of the obtained range:

Autofill in the web application.
Autofill in the desktop application.

Execute the command in the specified button's menu:

Copy in the web application.
Copy in the desktop application.

On double-click:

Hover the cursor over fill marker of the selected range. The cursor will look as a pointer - .
Double-click the fill marker.

Copying features:

If one cell is selected, its value is copied:

In the web application:

In the desktop application:

If multiple cells are selected, their values are copied sequentially:

In the web application:

In the desktop application:

This option fills cells using linear trend.

Linear trend is a trend of time series changing described by linear equation.

To fill cells using linear trend:

Use mouse:

Hover the cursor over fill marker of the selected range. The cursor will look as a pointer - .
Hold down the mouse button and move the cursor to the required table area.

Use the menu of the Autofill button in the web application or the Autofill button in the desktop application:

Hover the cursor over fill marker of the selected range. The cursor will look as a pointer - .
Hold down the mouse button and move the cursor to the required table area. The button appears in the bottom right corner of the obtained range:

Autofill in the web application.
Autofill in the desktop application.

Execute the command in the specified button's menu:

Fill in the web application.
Fill in the desktop application.

On double-click:

Hover the cursor over fill marker of the selected range. The cursor will look as a pointer - .
Double-click the fill marker.

Fill features:

If one cell is selected, its value increases by one on autofill:

In the web application:

In the desktop application:

If multiple cells are selected, the linear trend value is calculated during autofill:

In the web application:

In the desktop application:

This option fills cells with the specified step.

To determine step value:

Apply one of the autofill options: copy or fill.
Execute the command:

Fill with Step in the menu of the Autofill button in the web application.
Fill with Step in the menu of the Autofill button in the desktop application.

The Fill with Step dialog box opens:

In the web application:

In the desktop application:

Specify required fill step.

NOTE. Fill step value may be negative.

Features of fill with step:

If one cell is selected, its value changes by one step:

In the web application:

In the desktop application:

If multiple cells are selected, value of each cell changes by the specified step:

In the web application:

In the desktop application:

After executing autofill, the extended range is filled based on the contents of source range cells and selected autofill option. On next editing of cells in the selected range, the

Autofill button in the web application or the

Autofill button in the desktop application will be hidden. The autofill result is saved.

Cell Autofill Features

NOTE. Copying data with formatting is available only in the Reports tool. To undo copying of the mentioned parameters in a report, deselect the

Copy Formatting checkbox in the menu of the

Autofill button in the web application or the Copy Formatting checkbox in the menu of the

Autofill button in the desktop application.

To save copied formatting in the table visualizer, select the Use Sheet Formatting checkbox of the Parameters tab of the Table group of tabs. Otherwise, on saving or on undoing saving the copied formatting is reset.

On autofill with double-click, cells are filled from the current selected range down to the table end; if a column contains cells with already entered data, autofill is executed to these cells.

How to Determine What will be Done: Copy or Fill?

If the cursor is hovered over fill marker of the selected range, the mouse button is held down and the user is going to stretch the range to necessary size, how to determine what will be done: copy or fill?

NOTE. If the CTRL key was held down on spreading, it is copied no matter the selected range and direction of spreading.