Online-help

Interface of the Table Editor Dialog

Interface of the Table Editor Dialog

Interface of the Table Editor Dialog

The full table editor (the Table edit dialog box) can be opened:

·         by double-clicking on the frame inserted into the drawing table,

·         by right button clicking on the table frame (the full table editor will be opened if you press CTRL).

Please note that the Table edit dialog box can be opened only if Yes is chosen for the Program objects option of the Settings nanoCAD Int dialog box (the Tools menu – Advanced Settings) on the Main options tab of the Edit - By double-click section.

The edit and fedit commands allow you to open the Table edit dialog box, it does not matter what value is chosen for the Program objects option.

The Table edit dialog box can be also opened:

·         by placing the cursor over the table and selecting the Edit in the tooltip:

Note: To invoke the dialog this way you should choose Yes for the Show tooltips option (the Settings nanoCAD Int dialog box – the Main option tab – the Tooltips section):

 

·         by selecting the table, pressing the right button and choosing the Edit command in the context menu.

The Table edit dialog box:

The dialog box contains:

·         standard pull-down menus

;

·         tool palette buttons

·         rulers with sliders allowing column width or row height to be quickly adjusted

·         the cell grid with name headers

.

Each table section has a header:

·         First page header

·         Header

·         Last page header

·         Report header

·         Report template

·         Report

·         Report sum

·         First page footer

·         Footer

·         Last page footer

Click the left mouse button on a row or column name to select it.

To select the table, click the rectangle at the intersection of the lines and columns names:

Names (addresses) of table cells are fully equivalent to those used in MS Excel: columns are marked alphabetically (A, B, C, D, ... , Z; AA, BB etc.) while rows are marked with ordinal numbers.

Filling of adjacent cells with data

To accelerate the data input in the table, it is possible to use the function of automatic data filling. The table editor can automatically continue a line of numbers, number combinations and text with a set pattern. By selecting several cells and dragging the filling marker, it is possible to quickly fill in the data lines with the different types.

Filling cells with sequences of numbers or combinations of numbers and text with a set pattern:

For example: Filling cells with sequences of 1, 2, 3, 4, 5 numbers.

     

1.    Select the first of the filled cells:

2.    Enter the initial value for the values line:

3.    Enter a value in the following cell to set the filling pattern:

4.    Select the cell or cells containing the initial values:

5.    Drag the filling marker over the range with which it is necessary to fill:

6.    The cells will be filled with the set sequence of numbers:

Examples:

     

1.    If the sequence 2, 4, 6, 8… is required, enter 2 and 4.

2.    If the sequence 2, 2, 2, 2… is required, the second cell can be left empty.

3.    The sequence filling proceeds as shown in the table below:

Initial value

Line extension

1, 2, 3, ...

4, 5, 6, ...

First period, Second period, …

Third period...

Article 1, Article 2, …

Article 3...

Note! To fill in an increasing order, drag the marker down or to the right. To fill in a decreasing order, drag the marker up or to the left.

Use the autofilling to continue lists containing the values from collections (main menu/rows/user sorting).

Cell colors

Cell containing an expression.

Not edited cell, for example, in report.

Cell with a mistake in expression.

Cell containing data of report section.

Basic Tools

The files tools:

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.

The standard windows clipboard tools:

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 and redo last change tools:

Undo last change:

Undo last change.

Redo last change:

Redo last change.

Formatted cell navigation tools:

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.

Tools used for sorting cells by contents:

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).

Other tools:

Create summary function:

Info: NanoCAD is an easy-to-use, inexpensive, and yet powerful, CAD application for Windows, that provides a great user experience by providing high performance, full capability, a classic interface and native.dwg format support. nanoCAD has been built to deliver design and project documentation for all engineering purposes. nanoCAD includes a full suite of basic and advanced CAD tools for 2D/3D drafting and creating industry-standard DWG-compatible CAD files. Our program ensures groundbreaking, collaborative and customizable features to raise your efficiency, and includes a number of API's, allowing anything from routine task automation to complex CAD application development. You may try nanoCad for free, using the links below, and buy later, if you like it.
We collect Cookies
We use cookies to ensure that we give you the best experience on our website. By clicking “Accept”, you agree to our website’s cookie use as described in our Privacy Statement.