Re: Clipboard pastes into single spreadsheet cell

[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,
> -- 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 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 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 spreadsheet. For example:
>>>
>>> *put theData["Date"] &tab& theData["First name"] \*
>>> *&tab& theData["Surname"] into theRow*
>>>
>>> *set the ClipboardData["text"] to theRow*
>>>
>>>
>>> When I go to a Google Spreadsheet, click in an empty cell and paste, the
>>> tabs are ignored (converted to spaces) and the entire row gets pasted
>>> into
>>> the single cell as space-delimited.
>>>
>>> I have discovered a workaround. If I first paste from LiveCode to BBEdit
>>> (the tabs are recognized) and then copy and paste from BBEdit to the
>>> spreadsheet, the tabs are OK and the data populates into separate cells.
>>>
>>> I've tried this with Safari, Firefox, and Chrome, so the problem isn't
>>> browser-specific.
>>>
>>>
>>> I don't want to ask my end-user to paste into another application before
>>> pasting into the spreadsheet.
>>>
>>> Anyone know of a fix for this?
>>>
>>> -- Paul
>>>
>>>
>>
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
>
>
> --
>
> White Feather Software
> www.whitefeather.com
> Cell: 408-391-1480 <(408)%20391-1480>
>
>


-- 

White Feather Software
www.whitefeather.com
Cell: 408-391-1480
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 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 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 spreadsheet. For example:
>>
>> *put theData["Date"] &tab& theData["First name"] \*
>> *&tab& theData["Surname"] into theRow*
>>
>> *set the ClipboardData["text"] to theRow*
>>
>>
>> When I go to a Google Spreadsheet, click in an empty cell and paste, the
>> tabs are ignored (converted to spaces) and the entire row gets pasted into
>> the single cell as space-delimited.
>>
>> I have discovered a workaround. If I first paste from LiveCode to BBEdit
>> (the tabs are recognized) and then copy and paste from BBEdit to the
>> spreadsheet, the tabs are OK and the data populates into separate cells.
>>
>> I've tried this with Safari, Firefox, and Chrome, so the problem isn't
>> browser-specific.
>>
>>
>> I don't want to ask my end-user to paste into another application before
>> pasting into the spreadsheet.
>>
>> Anyone know of a fix for this?
>>
>> -- Paul
>>
>>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 

White Feather Software
www.whitefeather.com
Cell: 408-391-1480
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 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@lists.runrev.com> wrote:

>
> > On 19 Oct 2017, at 1:34 am, Bob Sneidar via use-livecode <
> use-livecode@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@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@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."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 
>> mailto:use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 found this:



--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 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 spreadsheet. For example:

*put theData["Date"] &tab& theData["First name"] \*
*&tab& theData["Surname"] into theRow*

*set the ClipboardData["text"] to theRow*


When I go to a Google Spreadsheet, click in an empty cell and paste, the
tabs are ignored (converted to spaces) and the entire row gets pasted into
the single cell as space-delimited.

I have discovered a workaround. If I first paste from LiveCode to BBEdit
(the tabs are recognized) and then copy and paste from BBEdit to the
spreadsheet, the tabs are OK and the data populates into separate cells.

I've tried this with Safari, Firefox, and Chrome, so the problem isn't
browser-specific.


I don't want to ask my end-user to paste into another application before
pasting into the spreadsheet.

Anyone know of a fix for this?

-- Paul




--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 PAUL IPST

On Wed, Oct 18, 2017 at 8:22 AM, Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> 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
> an event we can trap for when text is copied in the script editor? Maybe we
> can put something in a frontscript that "cleans" the clipboarddata.
>
> Bob S
>
>
> > On Oct 18, 2017, at 08:12 , Alejandro Tejada via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > I suspect that Unicode is working behind the scenes
> > to produce the result that Paul is getting in his own
> > MacOSX setup.
> >
> > Al
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 

White Feather Software
www.whitefeather.com
Cell: 408-391-1480
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 an 
event we can trap for when text is copied in the script editor? Maybe we can 
put something in a frontscript that "cleans" the clipboarddata. 

Bob S


> On Oct 18, 2017, at 08:12 , Alejandro Tejada via use-livecode 
>  wrote:
> 
> I suspect that Unicode is working behind the scenes
> to produce the result that Paul is getting in his own
> MacOSX setup.
> 
> Al


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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.
>
> 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
>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 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 spreadsheet. For example:

*put theData["Date"] &tab& theData["First name"] \*
*&tab& theData["Surname"] into theRow*

*set the ClipboardData["text"] to theRow*


When I go to a Google Spreadsheet, click in an empty cell and paste, the
tabs are ignored (converted to spaces) and the entire row gets pasted into
the single cell as space-delimited.

I have discovered a workaround. If I first paste from LiveCode to BBEdit
(the tabs are recognized) and then copy and paste from BBEdit to the
spreadsheet, the tabs are OK and the data populates into separate cells.

I've tried this with Safari, Firefox, and Chrome, so the problem isn't
browser-specific.


I don't want to ask my end-user to paste into another application before
pasting into the spreadsheet.

Anyone know of a fix for this?

-- Paul




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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 then copy and paste from BBEdit to the
> spreadsheet, the tabs are OK and the data populates into separate cells.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Clipboard pastes into single spreadsheet cell

[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
> spreadsheet, but are not converted when pasting from BBEdit.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Clipboard pastes into single spreadsheet cell

[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
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Clipboard pastes into single spreadsheet cell

[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 spreadsheet. For example:

*put theData["Date"] &tab& theData["First name"] \*
*&tab& theData["Surname"] into theRow*

*set the ClipboardData["text"] to theRow*


When I go to a Google Spreadsheet, click in an empty cell and paste, the
tabs are ignored (converted to spaces) and the entire row gets pasted into
the single cell as space-delimited.

I have discovered a workaround. If I first paste from LiveCode to BBEdit
(the tabs are recognized) and then copy and paste from BBEdit to the
spreadsheet, the tabs are OK and the data populates into separate cells.

I've tried this with Safari, Firefox, and Chrome, so the problem isn't
browser-specific.


I don't want to ask my end-user to paste into another application before
pasting into the spreadsheet.

Anyone know of a fix for this?

-- Paul

-- 

White Feather Software
www.whitefeather.com
Cell: 408-391-1480
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode