ToolTipText: -

PasteGrid pastesp.htm  - Paste Special - manually copy to clipboard immediately prior and must surround data with labels, descriptions and html space..



This function is used to completely setup all the data within the Grid Table. It has been successfully tested with Excel and must include exactly one surrounding row and column around the data area. This needed for the labels and descriptions of the elements and constructs. NB. Sometimes when copying a previously unsaved HTML table via Excel, if the last (description) row or column is entirely blank, i.e., all those cells are un-initialized, it is not copied and thus your grid will show one row or column too few. If this occurs you can force the last row or column to be a fixed size so you don't need perform your copy and PasteSpecial again.

Spaces in the labels are converted to underscores and semicolons are converted to colons. You don't need to worry about blank data cells as these will be converted to the number zero when the grid is saved.

For both the Paste and PasteSpecial methods there is the data extraction routine in which common fractions are converted and data cells that are initially set to "...." are converted using the cross currency rule implied in the source code for the following URL:-

http://money.cnn.com/markets/currencies/crosscurr.html
(To determine the conversion ratio, a "1" must appear in a cell for each column at its nominal row, i.e. the Pound column must have a 1 in the row for the U.K. - not quite psychology, but useful nonetheless. The first column must be the basic rate i.e. U.S.$ so that the cell for this column that has 4 dots becomes the division of column one for that row divided by column one for the row that has a "one" in this column.)
This method  first creates a NewGrid to contain the import and any data headings from the last grid that were in memory are cleared by this operation.

If you want to preserve the descriptive features of an existing grid and only import just the data area is to use just the Edit > Paste  method.


The following image represents what your data would look like having just copied it from Excel.

Note: - you must not select to copy any more than the single boundary row and column of labels and extended descriptions that surround the data cells. In other words for this 14x14 grid you must select exactly the 16 rows and 16 columns that encompasses the data.

If there is any error in your import you will get something like the following message and will may or may not have to restart the procedure. Maybe some other action came in between the cut & paste special to interrupt the clipboard. Nonetheless, you are given the opportunity to continue anyway and to adjust the size of the grid.

You are also given the chance of not committing the grid straight into its array base. You can use this new feature to retain non numeric data while you transform it. You can later use the Grid Table 'Weight' checkbox to attempt a final conversion. For convenience the 'Copy' and 'Paste' commands have been extended to merge columns using a slash '/' seperator as well the 'Weight' command can convert sorted columns into numeric groupings. The new 'Replace' command is also useful.


If everything comes across as it should you will NOT get the following message.

You then need to set up the rest of the remaining fields in the Adjust Parameters (F5) screen.


The arrangement of data within the spreadsheet for the inGridX "Paste Special" function is designed to exactly setup the Grid Table in the Enter Scores  (F2) screen. It is not quite the same arrangement that is required if you were manually constructing a inGridX input text file. See File > Open   Ctrl+O for more details.