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 | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
_______________________________________________
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
