The Prospero Line Definition workspace provides you with a number of usability options for managing data in your workspace. Similar to other Microsoft® applications, you can use the Find, Replace, Select or Sort options to allow you to quickly find values or make multiple updates to your data. These options are located on the Home ribbon and can be used in the active workspace grid.
The Find option will take you to the cell which contains the value you enter in the Find dialog. Additionally, you can use the Ctrl button and the F key to return the Find dialog.
The Replace option will perform multiple replacement on values in the cells based on your input. The following conditions and exceptions impact how the Replace feature will function in the workspace:
•Fields with drop-down lists will allow the replace to occur as long as the replacement text matches the beginning of a string in the list.
•Fields which are checkboxes, disabled cells, or are read-only will not allow the Replace function to change the value.
•Field which are hidden in the workspace, such as columns in a Line Definition, will not be included in the Replace even if they match.
The Sort option will sort the data in the current open set or workspace.
The Select option will select all the data in the current open set or workspace. You can choose to “Select All” or “Select None” to clear your selection. You can then choose to Copy or Cut the information selected.