Please enable JavaScript to view this site.

Altova XMLSpy 2022 Professional Edition

The settings of Grid View are defined in the Grid View Settings dialog (screenshot below), which is accessed via the Settings icon in the Grid View toolbar.



Grid View Settings icon in the Grid View toolbar


Grid View settings are described below. Note that these settings apply to the Grid View of all documents (XML, JSON, DTD).



The check boxes in the Display section are fairly self-explanatory. Given below are a few notes for clarification.


If all cells are not expanded on loading, then the root node and all its descendants are collapsed. You will need to expand each node as you go deeper into the document.

If Show inline previews is not checked, then, instead of a preview of the cell being shown, only the index number of the element in the cell will be shown. If inline previews are enabled, then you can opt to show a preview that contains (i) both element content and attributes, or (ii) attributes only. To opt for the latter, check For attributes only; to opt for the former, uncheck For attributes only. Note that only the first part of the inline content of a cell will be shown; you can hover over an element's start tag to see all of its content.

When optimal widths are switched on, the entire width of the grid is displayed. To achieve this, text in some cells will wrap.

When text overflows a cell, the overflow can be shown either as text that fades or be indicated by an ellipsis.

You can switch the display of whitespace in grid cells on or off. A space character is shown as a vertically centered dot and a tabs is displayed as an arrow. An end-of-line is indicated with a new linefeed inside the cell.

Sibling nodes can be displayed into sibling groups of 100, 1k, or 10k nodes (see screenshot below). This is useful for two reasons: (i) If you want to save display space in files that have a large number of sibling nodes, you can group sibling nodes in large groups; (ii) If you want to process only a subset of sibling nodes (thus saving processing time), you can expand the relevant sibling groups you want to process and carry out the processing action on these nodes only; for example, when you use search-and replace or when you convert the type of a node (see Editing below).




Basically, you can use the arrow keys to navigate the grid. These setting provide smart options for using the keys.


Expand on Right Arrow key: If a cell item is collapsed, then pressing the Right Arrow key expands the item in the cell. If the cell item is not collapsed, the Right Arrow key takes you to the next cell on the right (including to the child if the next cell on the right is a child). If the option is not selected, the Right Arrow key stops at a collapsed cell. Note that the Expand on Right Arrow key feature does not apply to cells within tables; in table cells, the action takes you to the next cell on the right.

Collapse on Left Arrow key: When you move left with the Left Arrow key, then, at some points, you must also move up the document hierarchy. If this option is selected, then items that can be collapsed will be collapsed when the Left Arrow key is pressed; otherwise such items will not be collapsed although the focus will shift to the parent item. Note that the Collapse on Lef Arrow key feature does not apply to cells within tables; in table cells, the action takes you to the next cell on the left.

Expand/Collapse on Spacebar: The spacebar functions as a toggle to expand/collapse an item. It can therefore be used as an additional key for navigating the grid.

Keep Column Position on Up/Down Arrow keys: The Up and Down Arrow keys take you, respectively, up and down through cells of the grid, including through parent and children items—which are hierarchically at different levels, and so in different columns. If this option is selected, levels that are represented in columns other than the current column are skipped. This works, for example, like this. Say the cursor is in the column for the element subject/course/books/book/title. With the Keep Column Position option selected, you can use the Up and Down arrow keys to navigate only through titles of books (without going into the book, books, course, or subject columns, or any columns for descendant items of Title.)




The check boxes in the Display section are fairly self-explanatory. Given below are a few notes for clarification.


When changing the type of multiple selected cells, you are given the following options about whether to go ahead with the action of the setting: Always, Never, or Ask (for user decision).

When changing a JSON type to from an atomic type to object or array, you are given the following options about whether to go ahead with the action of the setting: (i) Ask (whether the value of the atomic type should be retained as the value of an unnamed child key:value pair, or discarded), (ii) Always (retain the value in an unnamed child key:value pair), (iii) Never (retain the value, that is, discard the value).

The Paste direction option determines whether a selection in the clipboard is pasted above or below the selected cell.




Filters and formulas can be stored in the metadata of XML and JSON documents. Formulas are stored as processing instructions in XML documents and as comments in some types of JSON document. These settings specify how to proceed with the storing of filters and formulas. In the case of formulas, the if possible terminology refers to the fact that formulas can not be saved as comments in all JSON documents (only in JSON5 and JSONC documents).




The following settings are available:


If the setting to detect JSON Grid View tables automatically on loading is selected, then you can select the minimum percentage of filled table cells that qualify tables to be detected as tables. If the number of filled table cells does not exceed this level, then the structure is displayed as a normal grid with the repeating elements listed one below the other. Note that this setting applies to JSON Grid View only; in XML Grid View, tables are detected automatically irrespective of what percentage of table cells is filled.

You can also choose whether clipboard contents should be stored as tab-separated values (TSV), or as XML/JSON (depending on the document type). This is a very useful feature: If you want to paste a table from the clipboard to another document, this setting enables you to choose whether the copied table is stored as TSV or with markup. (To see the difference, try pasting a table to a text editor after copying the table to the clipboard in each of the formats.)


© 2015-2021 Altova GmbH