Grid To Sheet Transfer


There are two modes of transferring data from the grid shown in the
Browse Area to spreadsheet:
As Formula: The grid data are returned by a special spreadsheet formula referencing the appropriate dependencies and therefore might change when the the sheet is recalculated.
As Values: The grid data are pasted as hard-coded values and therefore never change when the the sheet is recalculated.
The required steps for both modes are:
1) Grid Selection:
Select the grid data you are interested in.
The whole grid can be alternatively selected by keeping all cells unselected (you may have to press ESC to do this)
Avoid selecting whole rows or columns through a single click on the edge cell as the ensued selection is not processed properly!
Always select partial ranges by left-clicking on the top-left cell, holding down and dragging to the bottom-right cell.
Certain
Grid Cells Selection Rules apply in the as Formula mode.
2) Copying: (applies only to the as Values transfer mode)
Either press CTRL-C or right-click while over the grid and choose the desired option from the appeared context menu.
3) Spreadsheet Selection:
Select any empty spreadsheet cell that has sufficient empty space underneath to hold the pasted data.
4) Pasting:
As Formula: Click on the Go button and select the Paste Object Contents choice.
As Values: Either press CTRL-V or right-click and select Paste