The JSON: Grid View section (screenshot below) enables you to define options for the Grid View of JSON documents (JSON Grid View).
The following options are available:
•Change type of all selected cells simultaneously: If multiple cells are selected and the type of one is changed, you can specify what XMLSpy should do: (i) Ask (whether the change should be applied to all the cells or to only the cell in focus); (ii) Always (apply the change to all selected cells); (iii) Never (apply to all cells; instead apply only to the cell in focus).
•Keep simple value when changing type to object or array: If a type is changed from an atomic type to an object or array, you can specify what XMLSpy should do: (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, the value should be discarded.
•Keep filters and formulas in metadata: These are options that enable the user to choose whether filters and formulas should be kept in the metadata file (see next point for location of metadata file). The following options are available: (i) Ask: When a file containing a filter or a formula is closed (whether you have saved the file or not) or when you switch from Grid View to another view, you will be asked whether to keep or discard the filters and formulas; (ii) Always automatically saves all filters and formulas to the metadata file; (iii) Never does not save filters and formulas to the metadata file.
•Metadata location: The path to the JSON file in which metadata (about filters and formulas) is stored. You can pass the metadata file to other XMLSpy users so that the same filters and formulas can be used to view and work with the related JSON file/s. To use another metadata file, set this option to point to the metadata file you want.
•Store formulas in document (JSON5/JSONC): If selected, the option to store formulas as part of the content of JSON5 and JSONC documents (the disk icon in JSON Grid View) is available, and formulas will be stored in the document.
•Minimum amount of filled table cells for table auto-detection: Specifies the amount as a percentage of the number of child cells that must be filled in order for a node to be detected as a table.
After making the settings, click OK to finish.