Grid Cells Selection Rules

The following apply to transferring data from the grid shown in the Browse Area to spreadsheet in the as Formula transfer mode.
The as Values transfer mode carries no restrictions.
These two transfer modes are explained at Grid To Sheet Transfer
Case 1: Grids containing Key-Value pairs:
1: Only one single selected Value can be transferred to the spreadsheet.
2: The transfer of multiple Values is not supported.
3: In order to transfer the whole grid, keep all cells unselected (you may have to press ESC to do this)
4: The transfer of Keys alone, is not supported.
5: Selecting any single Key will result in transferring the associated Value but not the Key itself.
6: If the Value consists of a row of cells, all such cells are transferred.
Case 2: Grids containing array:
1: Any part of the grid can be selected and transferred to the spreadsheet.
2: The whole grid can be alternatively transferred by keeping all cells unselected (you may have to press ESC to do this)