Re: Clipboard pastes into single spreadsheet cell

2017-10-19 Thread Paul Foraker via use-livecode
I just checked this in LC 7.1.1, running in High Sierra. It works as expected; the tabs survive into the spreadsheet. -- Paul On Thu, Oct 19, 2017 at 6:18 AM, Paul Foraker wrote: > G.W., glad to hear it works OK on a PC. My end user will be using one. > Thanks, > --

Re: Clipboard pastes into single spreadsheet cell

2017-10-19 Thread Paul Foraker via use-livecode
G.W., glad to hear it works OK on a PC. My end user will be using one. Thanks, -- Paul On Wed, Oct 18, 2017 at 7:52 AM, G.W.Gaich via use-livecode < use-livecode@lists.runrev.com> wrote: > I made a test: > > set the clipboarddata to 1 & tab & 2 & tab & 3 > > pasted into a google spreadsheet cell

Re: Clipboard pastes into single spreadsheet cell

2017-10-19 Thread Mike Kerner via use-livecode
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

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Monte Goulding via use-livecode
> On 19 Oct 2017, at 1:34 am, Bob Sneidar via use-livecode > 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 >>

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread J. Landman Gay via use-livecode
On 10/18/17 4:17 PM, J. Landman Gay via use-livecode wrote: It isn't just LC, a search shows this isn't an uncommon problem. I couldn't find an answer, but this suggests mime types: Also

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread J. Landman Gay via use-livecode
It isn't just LC, a search shows this isn't an uncommon problem. I couldn't find an answer, but this suggests mime types: On 10/18/17 3:27 AM, Paul Foraker via use-livecode wrote: On a Mac

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Paul Foraker via use-livecode
Results after copying data from LiveCode (string starts with a tab) 1hooIO16dbbNtjCvISrTzQ== 45539 TEST -- SEND TO PAUL IPST Results after pasting in BBEdit 1hooIO16dbbNtjCvISrTzQ== 45539 TEST -- SEND TO PAUL IPST After copying from BBEdit 1hooIO16dbbNtjCvISrTzQ== 45539 TEST -- SEND TO

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Bob Sneidar via use-livecode
That has been my suspicion all along since this began. Still, I think it is incumbent upon the other software developers to properly interpret the clipboard and respond accordingly. That of course, is a pipe dream, so I suppose it's now up to us the end developers to do the conversion. Is there

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Alejandro Tejada via use-livecode
I suspect that Unicode is working behind the scenes to produce the result that Paul is getting in his own MacOSX setup. Al On Wed, Oct 18, 2017 at 9:37 AM, Alejandro Tejada wrote: > Hi Paul, > > Paste this in a button (or the message box) and > post back your results. >

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread G.W.Gaich via use-livecode
I made a test: set the clipboarddata to 1 & tab & 2 & tab & 3 pasted into a google spreadsheet cell and three cells were filled as expected. Livecode 8.1.6 windows 7 firefox 56 perhaps it's a mac or browser thing Am 18.10.2017 um 10:27 schrieb Paul Foraker via use-livecode: On a Mac with

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Bob Sneidar via use-livecode
If that is the case, then tabs in LC are not tabs, they are something else. Bob S > On Oct 18, 2017, at 01:27 , Paul Foraker via use-livecode > wrote: > > I have discovered a workaround. If I first paste from LiveCode to BBEdit > (the tabs are recognized) and

Re: Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Bob Sneidar via use-livecode
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 > wrote: > > Tabs coming from LiveCode are converted to spaces when pasted to a Google >

Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Alejandro Tejada via use-livecode
Hi Paul, Paste this in a button (or the message box) and post back your results. Results after copying data from Livecode Results after pasting in BBEdit Results after copying text from BBEdit put base64encode(md5digest(the clipboarddata["text"])) & cr & the clipboarddata["text"] Al

Clipboard pastes into single spreadsheet cell

2017-10-18 Thread Paul Foraker via use-livecode
On a Mac with LC 8.6.1 (Community) Tabs coming from LiveCode are converted to spaces when pasted to a Google spreadsheet, but are not converted when pasting from BBEdit. I'm collecting data into a tab-delimited row (line) and putting it on the Clipboard, then pasting the row into a Google