Interface of the Table Editor Dialog

Initial value

Line extension

1, 2, 3, ...

4, 5, 6, ...

First period, Second period, …

Third period...

Article 1, Article 2, …

Article 3...

Cell containing an expression.

Not edited cell, for example, in report.

Cell with a mistake in expression.

Cell containing data of report section.

Open table:

Allows a data set from a previously created *.dat file to be imported, or a standard table template from the nanoCAD library to be imported.

Clicking the black triangle shows additional buttons which are used to select the data source:

 - Insert a table from the library.

 - Insert a table from an external file *.tbl, *.dat, *.mdb, *.txt, *.csv, *.xml, *.xls, *.xlsx.

If the Excel file is chosen, only the first list will be inserted.

Save to file:

Exports the cell data to a special *.dat file format, or saves it in the nanoCAD library.

Clicking the black triangle shows additional buttons used to select the desired destination:

 - Save table in nanoCAD library.

 - Export table to an external file *.dat, *.txt, *.csv, *.xml, *.xls.

Export to Excel:

Exports the table data to MS Excel. Clicking this button creates a new Excel worksheet containing all the table data with identical formatting.

Import from Excel:

Imports calculated data from an open MS Excel worksheet.

Cut:

Copy the selected data into the clipboard and delete from the table.

Copy:

Copy the selected data into the clipboard.

Paste:

Paste data from the clipboard.

Undo last change:

Undo last change.

Redo last change:

Redo last change.

Move row down:

Moves the selected row one position down.

Move row up:

Moves the selected row one position up.

Move column left:

Moves the selected column one position left.

Move column right:

Moves the selected column one position right.

Page division:

This tool is intended for dividing a table into multiple fragments without losing its integrity.

Use this function to split a large table in order to place it on a smaller sheet of paper, while still being able to edit it as a whole.

Sort ascend:

Sorts rows in ascending order of cell values in the current column (column of the selected cell).

Sort descend:

Sorts rows in descending order of cell values in the current column (column of the selected cell).

Create summary function:

Summarises the contents of the chosen cells:

·         Select the cell in which it is required to calculate the sum.

·         Click the button.

·         Select the cells which are to be summarised:

·         Press Enter:

Open calculator:

Opens the Calculator window.

Open Notepad:

Opens the Notepad window.

Insert material:

Use this tool to insert formatted rows of material into the table. Click the icon to open the Material dialog box:

Special Symbols:

Allows a special symbol to be inserted from the menu.

Recalculate Table:

This button is used to manually update the calculated cell data after editing reference cell values or altering expressions.

Automatic calculation:

Operates a mode of automatic recalculation of the values of the table cells.

By default, the automatic calculation mode is included.

Update reports:

Click this button to update the report.

Automatic report update:

Operates a mode of automatic recalculation of the report.

By default, the automatic report update mode is included.

Group selection:

Merges multiple cells into a single cell.

Ungroup selected cells:

Restores the original cells from merged cells.

Change count of rows and columns:

Use to change the count of rows and (or) columns in the chosen cells range:

·         Select one or several cells.

·         Click the Change count of rows and columns button.

·         In the Regroup dialog box that appears, enter the required values for breakdown

Split table cells with pencil tool

Use to insert new cells by manually drawing new grid lines:

·         Specify the start and end point of a line which will divide each cell that is crossed by it into two:

·         Right-click on a cell border to delete this border:

·         Click Split table cells with pencil tool button to finish.

Text alignment

Use to control the text alignment in the selected cells.

Clicking the black triangle brings up additional buttons:

The remaining tool icons are self-explanatory.

Borders:

Use to display or hide the borders of the selected cells. Clicking the black triangle brings up additional buttons used to toggle border visibility:

 - No border lines.

 - Display all lines around the selected cells.

 - Display all borders - inner and outer.

The remaining tool icons are self-explanatory.

Border Color:

To set the border parameters:

·         It is necessary to select again the color or lineweight.

·         Choose the border (use the Borders  command) to which it is necessary to apply the set parameters.

Border Lineweight: