[devboy]

'peterlaursen' wrote:

If you copy to clipboard from Excel a 'window' with 2 horizontal cells reading

Code:

a b

.. the clipboard will have a string like

Code:

ab

This string is a valid string for a single 'cell' in a database. It is something very specific for spreadsheets that a cell cannot hold a TAB character. For all other programs this is just a string. Similar situation with linebreaks. Data in a database are not formatted like in a spreadsheet. There is an ambiguity with TABs and linebreaks. That is the problem.

Again, but what if my target is NOT a spreadsheet. What I want is to be able to copy stats from SQLyog in paste in an Outlook email as HTML (or whatever it is in there). Is that still the same problem? Regardless, I would assume that even if we are talking about spreadsheets, in the majority of cases I won't be finding tabs embedded in the data I'm copying from th SQLyog result grid. A functionality that will not work for 1% of the cases is still very desirable IMHO.

[devboy]

'peterlaursen' wrote:

Much the same as those I think:

http://code.google.com/p/sqlyog/issues/detail?id=276

http://code.google.com/p/sqlyog/issues/detail?id=1461

The problem is that there is no way to decide if any TAB or Linebreak (or whatever) copied are *data* or *symbols* .

The polemic question: can you do this with Access?

I'm no expert on how the MS guys do it exactly, but from reading a little bit, what I saw is that for copying and pasting to excel you just need to format your cell range in the right way. Since you can already do that in the “copy all rows to clipboard option” I don't see what the problem is here, but maybe I misunderstood.

To do the same and be able to paste Outlook for example I'd expect just the formatting to change. Take a look at this: CF_HTML. I have to say I couldn't get this method to work the “simple” way. I.e. grab the HTML as text, copy it and try and paste it in outlook. However when you copy some HTML table in a browser and paste it notepad++ you get a simple tab separated table. When you do the same and paste to Outlook the table formatting is carried over as well. Somewhere behind the scene something is keeping this meta data. I don't know for sure if it's in textual format inside the 'normal' clipboard and the paste operation just interprets it, or that it is some OLE object that is linked to the textual clipboard. Either way, the fact that you can copy HTML off of say Firefox and paste it in an outlook mail with formatting, suggests that it should be possible in any app (unless this requires direct calls to win32 API).

I'll ask around with my MS guru friends and see… maybe they will be able to shed some light.

Cheers,

DB

[Author]

Posts