The sleuthing had to change. It turns out to be the width of the columns, not
the number of them. Here's a screen recording:
http://xfiles.funnygarbage.com/~colinholgate/video/excel_to_lc_dragdrop.mov
On Sep 14, 2011, at 12:27 AM, Pete wrote:
Good sleuthing!
It looks like it may not be the width of the column, because you have another
column there that easily exceeds the width of your test column. Rather, it
appears that the excel selection exceeds the visible part of the source window
before you start to drag it. Why this would affect anything is
I'm trying to copy some cells from Excel (Mac, 2008 Office version) and paste
it into a field in LiveCode. If I do that with Numbers all is good. From Excel
I get nothing.
'the clipboard' tells me that it contains 'text, but that 'the clipboarddata'
is apparently empty.
If I take a moment to
How would you do that? 'the clipboard' just reports having 'text'.
Jonathan, the actual application is for a client to be able to convert a
selected range of cells into a specific format XML. By far the easiest way to
have them do that is to select the cells, Copy, go to the revlet window, and
On Tue, Sep 13, 2011 at 10:30 AM, Colin Holgate co...@verizon.net
wrote:
I'm trying to copy some cells from Excel (Mac, 2008 Office version)
and
paste it into a field in LiveCode. If I do that with Numbers all is
good.
From Excel I get nothing.
'the clipboard' tells me that it contains
6:32 am
Subject: pasting clipboard from Excel
I'm trying to copy some cells from Excel (Mac, 2008 Office version) and paste
it
into a field in LiveCode. If I do that with Numbers all is good. From Excel I
get nothing.
'the clipboard' tells me that it contains 'text
Yes, the strange thing is that sometimes it cooperates. It seems to fail more
often when copying cells that have a particular data type assigned to them.
Jim, as Craig did too, I'm only attempting to get tab delimited text onto the
clipboard. It doesn't matter in any way at all what cells the
-Original Message-
From: Colin Holgate co...@verizon.net
To: How to use LiveCode use-livecode@lists.runrev.com
Sent: Tue, Sep 13, 2011 6:32 am
Subject: pasting clipboard from Excel
I'm trying to copy some cells from Excel (Mac, 2008 Office version) and paste
it
into a field
On Sep 13, 2011, at 8:37 AM, Colin Holgate wrote:
Yes, the strange thing is that sometimes it cooperates. It seems to
fail more often when copying cells that have a particular data type
assigned to them.
Jim, as Craig did too, I'm only attempting to get tab delimited text
onto the
I can select exactly the same range of cells, and one time a copy/paste will
work, and another time it won't. There are no formulas in the spreadsheet I'm
using, but the contents of many of the cells are derived from popup lists.
I think it's just a clipboard conversion issue, that sometimes
As you can control the source, is it worth (at least to test) saving the range
into a CSV format to force everything to plain text. That way non-text elements
shouldn't get into the clipboard?
I often wish for an Office 'Copy Special' function to mirror 'Paste Special',
so I can grab just
That would be more steps than what I do now, which is to just do a paste in any
other program, then the next paste into LiveCode works ok.
On Sep 13, 2011, at 12:36 PM, Keith Clarke wrote:
As you can control the source, is it worth (at least to test) saving the
range into a CSV format to
...indeed, hence the suggestion - to test whether the problem is non-text
elements getting into the clipboard that LC doesn't like.
That way, you can at least prove whether you have the option to add LC-friendly
pre-processing via a user-friendly Excel trick, such as a nice big 'Export to
LC'
I would not mind if there were an external that gives an LC user complete
access to even the most obscure corners of the clipboard.
On Tue, Sep 13, 2011 at 1:02 PM, Keith Clarke
keith.cla...@clarkeandclarke.co.uk wrote:
...indeed, hence the suggestion - to test whether the problem is non-text
I suspect the clipboard is a circle...
I have a new issue on this same challenge. If data in a cell has a rogue return
character, Excel places quotes around the two lines. Numbers does better. I'm
looking for that don't wrap text no matter what option in Excel.
On Sep 13, 2011, at 6:01 PM,
comes over as you would expect. Tabs are there, returns, everything.
Craig
-Original Message-
From: Colin Holgate co...@verizon.net
To: How to use LiveCode use-livecode@lists.runrev.com
Sent: Tue, Sep 13, 2011 6:32 am
Subject: pasting clipboard from Excel
I'm trying
I wonder if drag and drop works? I have seen it behave differently when working
with Office clipboards.
Bob
On Sep 13, 2011, at 3:04 PM, Colin Holgate wrote:
I suspect the clipboard is a circle...
I have a new issue on this same challenge. If data in a cell has a rogue
return
I can't figure out a way to drag and drop away from Excel.
On Sep 13, 2011, at 6:34 PM, Bob Sneidar wrote:
I wonder if drag and drop works? I have seen it behave differently when
working with Office clipboards.
___
use-livecode mailing list
Start dragging on the edge of the selection when the cursor turns into a hand.
Bob
On Sep 13, 2011, at 4:23 PM, Colin Holgate wrote:
I can't figure out a way to drag and drop away from Excel.
On Sep 13, 2011, at 6:34 PM, Bob Sneidar wrote:
I wonder if drag and drop works? I have seen
Thanks for the tip. Dragging onto the LiveCode field shows the + cursor, but
nothing gets dropped there.
On Sep 13, 2011, at 7:33 PM, Bob Sneidar wrote:
Start dragging on the edge of the selection when the cursor turns into a
hand.
___
Maybe this should be reported to the RQCC, at least as a known issue. If
something pastes OK into another app but not LC, seems like LC has some role
in the problem.
Pete
Molly's Revenge http://www.mollysrevenge.com
On Tue, Sep 13, 2011 at 6:43 PM, Colin Holgate co...@verizon.net wrote:
Thanks for the suggestion.
In testing it carefully, so I could report the problem with exact details, I
found that six columns of one row of Excel will drag and drop, or copy and
paste, ok. But seven columns of one row of Excel fails. That ought to be enough
of a clue to them!
On Sep 13,
Good sleuthing!
Pete
Molly's Revenge http://www.mollysrevenge.com
On Tue, Sep 13, 2011 at 8:53 PM, Colin Holgate co...@verizon.net wrote:
Thanks for the suggestion.
In testing it carefully, so I could report the problem with exact details,
I found that six columns of one row of Excel will
23 matches
Mail list logo
