Re: Pasting tabs into Excel

2018-02-05 Thread Richard Burkett via use-livecode
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

2018-02-03 Thread Brian Milby via use-livecode
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

2018-02-03 Thread Brian Milby via use-livecode
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

2018-02-03 Thread Richard Gaskin via use-livecode
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

2018-02-03 Thread J. Landman Gay via use-livecode
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

2018-02-03 Thread J. Landman Gay via use-livecode
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

2018-02-03 Thread Brian Milby via use-livecode
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

2018-02-03 Thread J. Landman Gay via use-livecode
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

2018-02-03 Thread dunbarx via use-livecode
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

2018-02-03 Thread Brian Milby via use-livecode
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

2018-02-03 Thread hh via use-livecode
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

2018-02-02 Thread Matthias Rebbe via use-livecode
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

2018-02-02 Thread Mike Bonner via use-livecode
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

2018-02-02 Thread dunbarx via use-livecode
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

Pasting tabs into Excel

2018-02-02 Thread J. Landman Gay via use-livecode
Someone asked me this and I don't have an answer: Before LC 8, you could put tabbed strings into the clipboard, paste into Excel or Google Sheets, and each tabbed item would go into a separate cell. After LC 8, the tabbed items go into a single cell as one string. How can we make Excel