Pasting tabs into Excel

Matthias Rebbe matthias_livecode_150811 at m-r-d.de
Sat Feb 3 02:52:24 EST 2018


Hi,

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.


Regards,
Matthias


> 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:
> http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the Use-livecode mailing list