Pasting from Excel
slylabs13 at mac.com
Mon Mar 31 13:19:04 EDT 2008
This not methinks a bug in Rev. This is the way Microsoft does
clipboards. Microsoft has ALWAYS had a custom way to do clipboards,
and Rev is not the first app to have a problem with that. I am using
Office 2001 for Mac still, and copying in Excel and switching to
another program and then back to Excel will likely crash Excel. Why
you ask? Because Excel is doing some kind of custom conversion with
the clipboard contents.
Calvary Chapel CM
On Mar 29, 2008, at 4:35 PM, Bryan McCormick wrote:
> 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:
> 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
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode