Pasting tabs into Excel
matthias_livecode_150811 at m-r-d.de
Sat Feb 3 02:52:24 EST 2018
i cannot reproduce that here on Mac OS X and Excel 2016 (V 15.30).
I executed your sample code in the messagebox and was able to paste successfully the clipboard to Excel.
I even tried with alpha numeric values.
But what i noticed is the following:
When i just click on a cell, so that it is selected without showing the blinking write cursor in the cell, then pasting is working w/o problems.
When i double click a cell, so that it is selected and the blinking write cursor is shown, then i cannot paste it correctly.
Tried with LC 8.19RC2 and LC9DP11.
Will try on Windows later this day.
> Am 03.02.2018 um 05:19 schrieb J. Landman Gay via use-livecode <use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>>:
> Someone asked me this and I don't have an answer:
> Before LC 8, you could put tabbed strings into the clipboard, paste into Excel or Google Sheets, and each tabbed item would go into a separate cell. After LC 8, the tabbed items go into a single cell as one string.
> How can we make Excel recognize the tabs?
> For example:
> put 1 &tab& 2 &tab& 3 into temp
> set the clipboardData["text"] to temp
> Jacqueline Landman Gay | jacque at hyperactivesw.com <mailto:jacque at hyperactivesw.com>
> HyperActive Software | http://www.hyperactivesw.com <http://www.hyperactivesw.com/>
> use-livecode mailing list
> use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode