Clipboard pastes into single spreadsheet cell

[J. Landman Gay]

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:

<https://stackoverflow.com/questions/29498324/tab-characters-converted-to-spaces-in-google-apps-script>

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         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com