Clipboard pastes into single spreadsheet cell
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.
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
> 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
>> 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:
White Feather Software
More information about the use-livecode