Viewing Large Data Cells

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Retrieving and Editing Data >

Viewing Large Data Cells

In data cells containing a large amount of text, the Result tab displays only the first part of the text followed by an ellipsis (...). In this case, also the Auto Size Columns option in the context menu is limited to displaying 250 pixels. You can, however, always drag the column border to show more text.

 

Expanding cells temporarily

If cell content is larger than the currently visible cell width (e.g., in tables with a large number of columns), the width of a certain cell is temporarily extended if you move the mouse cursor over the data cell (see screenshot below). This applies also to column headings.

tab_result-large-cells

 

To expand single data cells temporarily:

Place the mouse cursor over the cell you want to expand.

 

Using the Data Inspector

Where the temporary expansion of long data cells is insufficient, for example if you want to check the content of XML columns, DatabaseSpy provides the Data Inspector to display data cells containing a large amount of data.

dlg_data-inspector

The Data Inspector window can be displayed by clicking the Show the Data Inspector window ic_show-data-inspector icon in the toolbar of the Result window or Database Data Comparison Result window, respectively, or by choosing the menu option View | Data Inspector window.

tab_result-toolbar

 

To view data using the Data Inspector:

1.In the Result window or Database Data Comparison Result window, select a data cell and click the Show the Data Inspector window ic_show-data-inspector icon in the toolbar. Optionally, select the menu option View | Data Inspector Window. The Data Inspector window opens and shows the content of the selected data cell.
2.Optionally, click the Word wrap ic_wrap button to wrap the text in the Data Inspector window.
3.Optionally, click the Pretty Print ic_pretty-print button to display the text in a hierarchical way.
4.Optionally, click the Save As button to save the content as text or XML.

© 2019 Altova GmbH