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.

_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to