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 <p...@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@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
