<< Click to Display Table of Contents >> CLIP |
![]() ![]() ![]() |
CLIP has the same syntax and functionality as SHEET, so please see this statement.
Instead of sending the result to Excel as SHEET does, CLIP sends the result to the clipboard. Thus, the cells can be pasted into any spreadsheet (or other applications) accepting tab-delimited cells from the clipboard. Formatting of the cells is lost in comparison with SHEET, but otherwise the cells are the same. The loss of formatting may even be considered a benefit in some cases, for instance when pasting cells into different locations in the same spreadsheet.
The functionality is very similar to the 'Copy' button in the Gekko user interface. This button copies the last PRT/MULPRT or table to the clipboard (as tab-delimited cells).
CLIP uses the same internal component as PRT, so regarding operators and other details, also see the PRT help page.
Syntax
Please see the SHEET statement regarding syntax.
Note
The decimal separator used when copying to the clipboard can be changed by means of the option shown below. (This option will also apply to the 'Copy' button).
Related options
OPTION interface clipboard decimalseparator = [comma|period].
Related statements