Different result in LC 6 to LC 8 when copying field text into Excel?

[Jim MacConnell]

Beat me to it and good to know. 
Paste special as Unicode Text also works but Paste special as HTML does not.

As a wrinkle... pasting into NotePad has no line feeds (e.g. gives " Line
1Line 2Line 3")
Copying that from NotePad and pasting into LC, Word, Excel, etc.  gives
correct result (meaning 3 different lines)

Still too wonky for me to use I'm afraid. 
My users are simple "copy and pasters" and asking them to do different
flavors of Paste isn't going to work.

Jim

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of Tiemo Hollmann TB via use-livecode
Sent: Friday, February 03, 2017 8:53 AM
To: 'How to use LiveCode'
Cc: Tiemo Hollmann TB
Subject: AW: Different result in LC 6 to LC 8 when copying field text into
Excel?

the headquarter could confirm this interaction to Excel bug and pointed me
to the workaround with "paste special as text"
Tiemo 

-----Ursprüngliche Nachricht-----
Von: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] Im Auftrag
von Tiemo Hollmann TB via use-livecode
Gesendet: Freitag, 3. Februar 2017 15:26
An: 'How to use LiveCode' <use-livecode at lists.runrev.com>
Cc: Tiemo Hollmann TB <toolbook at kestner.de>
Betreff: AW: Different result in LC 6 to LC 8 when copying field text into
Excel?

Can anybody on Windows with LC 8 confirm this:

- create a new stack
- create a scrolling list field
- enter three lines of text, each with one word
- enter into the message box: *set the clipboarddata["text"] to fld 1*
- open MS Excel (in my case Windows 10, Excel 2013)
- paste
- see an extra empty line between each line of text

Pasted in a text editor there are no extra lines and up to LC 7 there also
was no extra line in Excel.

Can anybody confirm this behavior or even has an idea for a workaround?

Thanks
Tiemo



-----Ursprüngliche Nachricht-----
Von: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] Im Auftrag
von Tiemo Hollmann TB via use-livecode
Gesendet: Donnerstag, 2. Februar 2017 12:13
An: LiveCode User Liste senden <use-livecode at lists.runrev.com>
Cc: Tiemo Hollmann TB <toolbook at kestner.de>
Betreff: Different result in LC 6 to LC 8 when copying field text into
Excel?

Hello,

I have a standard scrolling list field with multiple lines of text. I copy
the text by:

*set the clipboarddata["text"] to fld "List"*

The User now can past the text into MS Excel on Windows. With LC 6 the text
was pasted into Excel line by line, as it showed up in LC. In LC 8.1.2 the
text is pasted with an extra space line between each two lines.

I checked the line ends in both versions. There is only one "LF"
(byteToNum=10) at the end of each line and it looks the same in both
versions.

What has changed in LC 8 to cause such a different behavior? Is this again a
Unicode thing what I don't understand? I already tried different
clipboarddata keys, without success.

It can't be an Excel option, because I tested it with the same Excel version
on the same machine.

Any idea, what has to be changed to get the same clipboard result as in LC
6?

Thank you

Tiemo

 

 

_______________________________________________
use-livecode mailing list
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


_______________________________________________
use-livecode mailing list
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


_______________________________________________
use-livecode mailing list
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