| Verify Data in Spreadsheet |
| See Also |
Once a set of columns have been selected for verification, the items in the spreadsheet display are hidden and a centred entry of "---" is displayed in each cell. On re-entering a value in the cell, when moving on to the next cell, the new item is compared with the current value. If there is a difference between the two values, a prompt is put on the screen and you are given a number of choices:
| Typed | Use the value just typed |
| Original | Use the original value |
| New | Use the neither the original value or the value just typed, but use the new value given in the edit box to the right |
Also there is an option to add a bookmark with a note to the cell.
Once the difference is resolved, a record of the difference is created in a small spreadsheet. Each difference is recorded in a row of the spreadsheet which contains columns called VColumn, VRow, Original, Typed and New. These columns contain the column and row number of cell where the difference occurred, the original cell value, the re-entered value and the value the cell was finally allocated respectively.
When in verification mode, the Tab and Enter keys proceed to the next cell to be verified, skipping columns in the spreadsheet that are not being verified.
If you do anything during verification such as deleting or inserting a row or column, then the verification process will be stopped. If this happens, a warning will be given.