See Also
The Case Information Toolbar Copy, Paste and Send Menu displays the identical options as shown in the Copy/Paste/Send menu of the case information display local menu. This is depicted in the figure below. The options are described below the figure.
Select Paste from the local menu to copy a record set from the Windows clipboard into the case information display. See Copying Simulator Data to and from Other Applications for more details.
The Copy Selection menu option copies the records selected in the case information display to the Windows clipboard, from which the selection can be copied into other programs such as Microsoft Excel for further analysis. See Copying Simulator Data to and from Other Applications for more details.
The Copy All menu option copies the entire record set contained in the case information display to the Windows clipboard, from which it can be copied into other programs such as Excel for further analysis. See Copying Simulator Data to and from Other Applications for more details.
Copy / Send Special
The Copy / Send Special menu option will open the a dialog that allows the user to set a few custom options before completing the data copy. The user can choose to copy all or a selection, and to copy the data either to the Windows clipboard or send it directly to Excel. Also, you can choose to copy or send the transpose. In addition, the user can choose whether to use the normal column headings or variable names (see the list of fields in Data Argument List for Auxiliary Files) as column identifiers. Lastly, the user can specify whether or not to include a row containing the type of object the data represents (Object Name) and a row containing the column headers for each column of data. Note that for pasting the information back into Simulator, the Object Name and Column Heading rows must be contained with the data to be pasted. If you have changed the settings on this dialog and wish to make them the case default settings, click on the Make Default for all Copy Actions button.
Send All to Excel (or to Open Office Calc)
The Send All to Excel menu option copies the entire record set contained in the case information display and automatically sends it to Excel. The first time this option is selected, Simulator will start a new instance of Excel on your machine and paste the data on the first sheet. Subsequent calls to Send to Excel will continue to add sheets and paste data to this instance of Excel, until the Excel instance is closed manually by the user. This functionality works identically for the Open Office Calc spreadsheet as well.
Send Selection to Excel (or to Open Office Calc)
The Send Selection to Excel menu option copies the selected record set in the case information display and automatically sends it to Excel. The first time this option is selected, Simulator will start a new instance of Excel on your machine and paste the data on the first sheet. Subsequent calls to Send to Excel will continue to add sheets and paste data to this instance of Excel, until the Excel instance is closed manually by the user.This functionality works identically for the Open Office Calc spreadsheet as well.
Note: When Choosong to Send To Excel, previously Simulator split exports of more than 256 columns into separate sheets in an Excel Workbook. For Excel versions 2007 and later, it will now only do this when the export have more than 16,384 columns.