PasteGrid pastesp.htm - Paste Special -
manually copy to clipboard immediately prior and must surround data with
labels, descriptions and html space..
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:-
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.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.)
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
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.