Adding a New Sheet and Working with It

To work with the tool in Foresight Analytics Platform 10, use the new interface.

Available operations with sheets:

Add a sheet.
Delete sheet.

To add a sheet, click the Add Sheet button next to sheet tabs. The sheet named Sheet N, where N is a sequence number of added sheet, will be added.

To delete a sheet, click the Delete Sheet button to the right on the sheet tab. The sheet will be deleted. At least one sheet must be present in data entry form. The single sheet cannot be deleted.

To work with a cell, select it.

Available operations with cells:

Add or delete cells.
Cell format.
Edit cell contents.
Setting up cell editor. It is autofitted by default depending on data type.

Adding or Deleting Cells

To insert cell/column/row, select one of the options in the Insert Cells item drop-down menu in the cell's context menu:

Move cells down.
Move cells right.
Insert row below.
Insert row above.
Insert column left.
Insert column right.

To delete cell/column/row, select one of the options in the Delete Cells item drop-down menu in the cell's context menu:

Shift cells up.
Shift cells left.
Delete rows.
Delete columns.

Format Cells

To open the Format Cells dialog box, select one or several cells:

Click the Set Formatting button on the Format ribbon tab.

The specified formatting will be applied to the area selected in the drop-down list in the Current Section group on the Format ribbon tab.

The dialog box contains the tabs:

Editing Cell Contents

To edit cell contents:

Select a cell in the report sheet and enter required data.
Double-click the selected cell
Select a cell and press F2, after this enter the data.

The following operations can be executed with selected cells:

To work with a column, select it by clicking the header.

The available operations with columns include:

Changing column width.
Adding or deleting column.
Hiding or showing column.

Changing Column Width

To change column width:

Use mouse. Hover the cursor to column border in the header area and drag the border to the required distance holding down the mouse button. When the mouse pointer appears as a two-headed arrow, you can click and drag an item.
Select the Column Width context menu item. A dialog box with the same name opens after executing the command:

Enter a value in the dialog box that opens.

Adding or Deleting Column

To add or delete a column, select the following items in the command header context menu:

Insert Column Left.
Insert Column Right.
Delete Column.

NOTE. To add or delete a column in table area, use the Create Record/ Delete Record buttons.

Hiding or Showing Column

If it is required to hide or show hidden column or column range, select the following header context menu item:

Hide.
Show. The item becomes active if the sheet contains any hidden columns.

The setting is available on working with ready data entry form.

To work with rows, select them by clicking the header.

The available operations with rows include:

Change row height.
Add or delete cell.
Hide or show row.

Changing Row Height

To change row height:

Use mouse. Hover the cursor to row border in the header area and drag the border to the required distance holding down the mouse button. When the mouse pointer appears as a two-headed arrow, you can click and drag an item.
Select the Row Height context menu item. A dialog box with the same name opens after executing the command:

Enter a value in the dialog box that opens.

Adding or Deleting Row

To add or delete a row, select the following items in the command header context menu:

Insert Row At the Top.
Insert Row On the Bottom.
Delete Row.

NOTE. To add or delete a row in table area, use the Create Record/ Delete Record buttons.

Hiding or Showing Row

If it is required to hide or show hidden row or row range, select the following header context menu item:

Hide.
Show. The item becomes active if the sheet contains any hidden rows.

The setting is available on working with ready data entry form.