Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The grid editor supports pasting data from the major spreadsheet applications, such as Excel and OpenOffice. The grid editor supports pasting single data as well as block of data. Copy/paste of binary data is transparent between grids or in the same grid. Binary files may also be copied in an external application and pasted in a cell in DbVisualizer (target cell must be a binary type). 

Copy from spreadsheet
 

Paste into DbVisualizer grid

A single cell is copied

Image Modified

 

 

 




Image Modified

 


Paste into selected target cell

Image Modified

A single cell is copied

Image Modified

 

 




Image Modified

Paste and fill the single column target selection

Image Modified

Multiple cells in a single row is copied

Image Modified

 

 




Image Modified

Paste and fill the target selection

Image Modified

A block of cells is copied

Image Modified

 

 




Image Modified

The block is pasted into the selected region

Image Modified

A block of cells is copied

Image Modified

 

 




Image Modified

The block is pasted into a non equal number of target cells

Image Modified

Updates and Deletes Must Match Only One Table Row

...

If a cell in the grid editor or form editor contains new line, carriage return or tab characters, these are not visually represented in the grid. Instead a warning will be displayed whenever you try to edit such value:

You may chose choose to edit the value in the Cell Editor, which we recommend, as the control characters will then be preserved. Alternatively, you can edit the value in the grid anyway but you then risk loosing the control characters. 

...

Index term
secondaryedit
primaryBLOB
Index term
secondaryedit
primaryCLOB
Due to the nature of binary/BLOB and CLOB data, cells of these types can only be fully modified and viewed in the Cell Editor. (There is partial support in the Form Editor to view image data and to load from file).

In the grid, Binary/BLOB and CLOB data is by default presented by an icon and the size of the value. You can select another presentation format in the Tools Properties dialog, in the Grid General/ Binary/BLOB and CLOB Data Formats category under the General tab. Selecting By Value results in performance penalties and the memory consumption increases dramatically.

...