Clipboard pastes into single spreadsheet cell

Paul Foraker paul at whitefeather.com
Thu Oct 19 09:24:45 EDT 2017


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 <paul at whitefeather.com> 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 at 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 at 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



More information about the Use-livecode mailing list