Lars-Olof,
From the msdn documentation about the clipboard:
"Multiple Clipboard Formats
A window can place more than one clipboard object on the clipboard, each representing the same information in a different clipboard format. When placing information on the clipboard, the window should provide data in as many formats as possible. To find out how many formats are currently used on the clipboard, call the CountClipboardFormats function.
Clipboard formats that contain the most information should be placed on the clipboard first, followed by less descriptive formats. A window pasting information from the clipboard typically retrieves a clipboard object in the first format it recognizes. Because clipboard formats are enumerated in the order they are placed on the clipboard, the first recognized format is also the most descriptive.
For example, suppose a user copies styled text from a word-processing document. The window containing the document might first place data on the clipboard in a registered format, such as RTF. Subsequently, the window would place data on the clipboard in a less descriptive format, such as text (CF_TEXT).
When the content of the clipboard is pasted into another window, the window retrieves data in the most descriptive format it recognizes. If the window recognizes RTF, the corresponding data is pasted into the document. Otherwise, the text data is pasted into the document and the formatting information is lost."
When you do a "copy" in Excel, it puts the information onto the clipboard in many, many different formats, including RTF, CSV, and plain text. When you do a "paste" in another program, it looks through each format in the clipboard until it finds one that it can handle, then pastes it. That way Word can handle the information in one way, Notepad in a different way, and Flexsim in a different way all from the same "Copy" command from Excel. There are many clipboard programs that you can use that can read these various formats. The clipboard program I use displays 29 formats that Excel writes to when you do a "Copy" command there, including as a bitmap so that you can copy/paste from Excel to Paint.
When you do a "Copy" in a Flexsim table, it only uses the "Csv" format on the clipboard. When you do a "Paste" in a Flexsim table, it only reads the "Csv" format from the clipboard.
The whole thing is confusing because Flexsim is properly copy/pasting to Excel. Something strange is happening on some computers that is causing Flexsim's paste functionality not to work though, and we can't figure out exactly what it is. My best guesses are in my previous post. If someone with this issue can track down what is causing the problem, then we may be able to resolve it, but none of the computers in our office have this problem any more to investigate further.
Last edited by Phil BoBo; 01-13-2010 at 10:12 AM.
|
