Clipboard pastes into single spreadsheet cell

[Mike Kerner]

What I discovered when I was fiddling around with this was that when I copy
text from a text editor (ST, atom, BBE, TW), and check the
fullClipboardData in LC, the only key is "text".  The rtf, html, etc. are
all missing (put the keys of the fullClipboardData).  When I put something
into the clipboard in LC, all of the keys are populated, and I haven't
figured out how to remove those keys.  Putting empty into those values does
not seem to fix it.

On Wed, Oct 18, 2017 at 6:41 PM, Monte Goulding via use-livecode <
use-livecode at lists.runrev.com> wrote:

>
> > On 19 Oct 2017, at 1:34 am, Bob Sneidar via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >
> > That is a function of how Google Spreadsheet and BBEdit treat tabs, not
> the Livecode Clipboard.
> >
> > Bob S
> >
> >
> >> On Oct 18, 2017, at 01:27 , Paul Foraker via use-livecode <
> use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>>
> wrote:
> >>
> >> Tabs coming from LiveCode are converted to spaces when pasted to a
> Google
> >> spreadsheet, but are not converted when pasting from BBEdit.
>
> I have a theory for you.
>
> I suspect that because when you copy text in LC then not only the plain
> text representation is put on the clipboard but also a html one, an rtf one
> and so on. Some apps might preferentially read the html one for example and
> in google sheets 	 might be replaced with space to fit the html chunk to
> a single cell. So moral of the story is to either control what
> representations are placed on the clipboard by setting the appropriate
> array keys or tell users to use the Edit > Paste special > Paste values
> only menu.
>
> Cheers
>
> Monte
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."