Type formatting

In the data source explorer, you can copy a table by dragging-and-dropping the table onto the table container. The Type formatting dialogue box is the third window of the Copy table dialogue box.

List box

Lists the data fields that will be included in the copied table.

Column information

Field name

Displays the name of the selected data field. If you want, you can enter a new name.

Field type

Select a field type.


Enter the number of characters for the data field.

Decimal places

Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.

Default value

Select the default value for a Yes/No field.

Automatic type recognition

LibreOffice can automatically recognise field contents when you copy database tables by drag-and-drop.

(max.) lines

Enter the number of lines to use for automatic type recognition.


Enables automatic type recognition.

Please support us!