Pasting from Excel

Bryan McCormick bryan at deepfoo.com
Sat Mar 29 19:35:56 EDT 2008


To clarify, yes, the problem in copying any range of rows and columns 
from Excel and then trying to paste them into a field is that tabs are 
not preserved. I am trying to paste from Excel, to Rev. It works fine 
pasting from Rev to Excel. This is on Windows. I was keeping my fingers 
crossed this would be rectified in 2.9.

To clarify by example, what you end up with in pasting from Excel to Rev 
is no separation character of any kind, so you simply get a run of text 
concatenated together.

--------- Example

For example a spreadsheet with the following (tabs to show columns)

Hot	Blue	Red	Almond


...results in this when pasted into a Rev field:

hotblueredalmond


If one pastes into NotedPad first and then into Rev, the proper 
formatting returns.

-----------

Checking the clipboard to do something simple like replace tab with 
(pick a delimiter) does not work. I thought of that as well Jim, but no 
go, the tabs just do not appear to be there.

Perhaps it is a flaw with the internal clipboard of Excel. However 
Notepad seems to be able to handle it fine as does pretty much any other 
  text editor on Windows.

I'm not sure this would be a bug per se as long as this is not really 
Rev's problem. It is however really annoying, perhaps it becomes a 
feature request?

I would think this would potentially impact any developer trying to come 
up with a solution that interfaces with Office products.




More information about the Use-livecode mailing list