Clipboard pastes into single spreadsheet cell

Paul Foraker paul at whitefeather.com
Thu Oct 19 15:18:40 CEST 2017


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


More information about the use-livecode mailing list