Re: Pasting tabs into Excel

This is clearly closely related to the problem I had recently copying text from Livecode into Mac Mail. YES, Livecode should copy PLAIN text when you ask it to copy PLAIN unformatted text. That said, Here’s the script that I ended up using that work for copying a list of tabbed data into

Re: Pasting tabs into Excel

PR 6293 should correct this issue (19206). When plain text is copied to the clipboard, styled text will not be added. On Sat, Feb 3, 2018 at 4:32 PM Brian Milby wrote: > http://quality.livecode.com/show_bug.cgi?id=19206 > http://quality.livecode.com/show_bug.cgi?id=20336 > On

Re: Pasting tabs into Excel

http://quality.livecode.com/show_bug.cgi?id=19206 http://quality.livecode.com/show_bug.cgi?id=20336 On Sat, Feb 3, 2018 at 4:28 PM Richard Gaskin via use-livecode < use-livecode@lists.runrev.com> wrote: > Brian Milby wrote: > > > More info on those 2 bugs: > > > > The first bug is about LC

Re: Pasting tabs into Excel

Brian Milby wrote: > More info on those 2 bugs: > > The first bug is about LC placing too much on the system clipboard. > Prior to 8, LC only put text+RTF on the clipboard. With 8, HTML was > added - LC ran everything through its internal conversion to LC styled > text and put LC HTMLtext on

Re: Pasting tabs into Excel

On 2/3/18 1:52 AM, Matthias Rebbe via use-livecode wrote: But what i noticed is the following: When i just click on a cell, so that it is selected without showing the blinking write cursor in the cell, then pasting is working w/o problems. When i double click a cell, so that it is selected and

Re: Pasting tabs into Excel

On 2/3/18 12:23 PM, Brian Milby via use-livecode wrote: Try this function (LC 8/9): *on* stripClipboard *local* tData *lock* the clipboard *put* the rawClipboardData["public.utf8-plain-text"] into tData *set* the rawClipboardData to empty *set* the

Re: Pasting tabs into Excel

I don’t think it changed. But Excel currently supports tab and return characters within cells. If you paste text with tabs/returns into the formula bar area it will all go into that cell. I'm using Excel 16.9 (180116) Try this function (LC 8/9): *on* stripClipboard *local* tData *lock*

Re: Pasting tabs into Excel

Like Mike, I found that the text to columns tool, using space as delimiter, will separate the entry into columns. That seems to imply that somewhere the tabs are changed to spaces. Also, pasting into a text editor does show the tabs, and copying from there preserves them when pasting into

Re: Pasting tabs into Excel

I have no access to Excel at the moment, but I cannot believe that the default field delimiter could possibly have changed from tab. May just as well change the record delimiter from return It would break just about everything. Craig -- Sent from:

Re: Pasting tabs into Excel

I got the same results as Matthias on 6, 7, and 9 (Mac Sierra) On Sat, Feb 3, 2018 at 8:56 AM hh via use-livecode < use-livecode@lists.runrev.com> wrote: > Possibly this is not LC but an Excel update that changed > Excel's default delimiter from tab to comma. > Does comma as delimiter work? > >

Re: Pasting tabs into Excel

Possibly this is not LC but an Excel update that changed Excel's default delimiter from tab to comma. Does comma as delimiter work? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage

Re: Pasting tabs into Excel

Hi, i cannot reproduce that here on Mac OS X and Excel 2016 (V 15.30). I executed your sample code in the messagebox and was able to paste successfully the clipboard to Excel. I even tried with alpha numeric values. But what i noticed is the following: When i just click on a cell, so that it is

Re: Pasting tabs into Excel

It's strange. If you paste into excel, then select the cell and use the text to columns tool, using Space as delimiter, poof. Columns. Also, in libreoffice, paste special can be used to choose "unformatted text" and that works also. Surely there is a way to pop a simple tab delimited string into

Re: Pasting tabs into Excel

Jacque. As if you needed this, confirmed here. What on earth can v.8 be doing to the tab character??? Craig -- Sent from: http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html ___ use-livecode mailing list