Copying Data from Web Reports
About copying data
You can copy data in contiguous cells from a report to the Windows clipboard. You can choose to copy data that has not been rounded and has been stripped of special formats such as thousands separators, currency signs, and percent symbols or you can copy rounded data that includes these elements. You can also copy row and column labels.
Procedure: Copying data from a report
To copy data from a report, follows these steps.
- With the report open in the workspace, select the cell or cells that you want to copy.
You can select cells by using row and column selectors. You can also select cells by selecting a cell as a starting point, dragging the mouse pointer, and then releasing the mouse button at the end of the block.
Note: You cannot select cells that are not contiguous.
- Click the Copy to Clipboard button on the Document toolbar.
Alternatively, you can click the right mouse button and select a copy option from the popup menu.
- Choose a copy option:
- Copy -- Copies data that is not rounded and excludes formats such as thousands separators, currency signs, and percent symbols.
- Copy Special -- Presents a submenu from which you can select one of the following:
- Copy Data with Labels -- Copies data that is not rounded and excludes formats such as thousands separators, currency signs, and percent symbols. Also copies row and column labels.
- Copy Number Formatted Data -- Copies data that is rounded and includes formats such as thousands separators, currency signs, and percent symbols.
- Copy Number Formatted Data with Labels -- Copies data that is rounded and includes formats such as thousands separators, currency signs, and percent symbols. Also copies the labels.
- Copy Row Labels -- Copies the row labels that are associated with the selected data. Does not copy the actual data.
- Copy Column Labels -- Copies the column labels that are associated with the selected data. Does not copy the actual data.
- If you see a dialog requesting additional privileges, choose Grant.
Result: The data is copied to the Windows clipboard.